InstallAware

How can i store/use a value selected by sql statment from sql server. the SQL goes some thing like this...
"SELECT DB_VERSION FROM TBL_VERSION"

now i want to use the the value of the field "DB_VERSION " selected by SQL and use it in the installer. But i am not being able to use it.

I have also tried using this
SELECT $CURRENT_VERSION$ = DB_VERSION FROM TBL_VERSION

Where $CURRENT_VERSION$ is declared in the Installer.

But not being able to access the value selected. How to do it?

Sorry, the SQL plug-ins do not write back to script variables or return data.

You can create an sql script that writes data on a .txt file to a temp directory and read the content you want (return values) from there, for example, line by line.

Does anyone know how we can do this? How we can we save result of a sql script into a text file?

I would also like to know how to do this