Return Values from SQL Script

[TimStVCS]

Hello, I have an InstallScript project that I am working on and would like to be able to execute an SQL script and store a return value from the SQL script in a variable defined in my InstallScript function. For example, I would like to do something like:

STRING szSQLResult;

szSQLResult = fnRunSQLScript(nHwnd);

Does anyone know if/how this can be done?

Thanks.

Tim

[TimStVCS]

I created an incident about this with Acresso product support and was told that this cannot be done. I have requested this as an enhancement request.....

Tim

[Christopher_Pai]

I was a bit suprised that InstallShields SQL Scripts pattern for MSI can't even handle a simple ExecuteScalar scenario where one column and one row is mappen back to a single property.

Fortunatly I have DTF and ADO.NET so it didn't take too much code to write it myself.

[timstspry]

Hi Christopher, I am unfamiliar with DTF? Could you give me any pointers on what you did and possibly how I can do the same?

Thanks!

Tim