Assign a variable from an MS SQL Server query

[AdrianGray]

How do I assign an Installaware variable from an MS SQL Server query. I can use an Installaware variables within the Query but how I assign it back. I need to ascertain the country from a database table, then use this variable to later decide which set of files to copy. Thanks, Adrian.

[FrancescoT]

Dear Adrian,

you may have a look at the following link.
http://www.installaware.com/forums/viewtopic.php?t=6063

Anyway, a sql query doesn't return a value and you need to use a stored procedure.

Hope this helps you.

Regards