How to access value selcted by SQL Script in the installer

[arupkrdas]

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?

[CandiceJones]

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

[Gizm0]

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.

[mehran]

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

[Roostar2004]

I would also like to know how to do this