This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Retrieve value of some sql query in InsallShield 2009 in some variable
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
![](/skins/images/8CE4FAD0DE6F3A6F9D0567434D2D2DAE/responsive_peak/images/icon_anonymous_message.png)
Not applicable
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
May 27, 2009
05:39 AM
Retrieve value of some sql query in InsallShield 2009 in some variable
I want to run the following query to find version of MySQL
SELECT @@VERSION;
GO
This displays the version of MySQL when running from MySQL command prompt.
I am able to run sql scripts from InstallShield 2009.
This script is also running successfully but I need to capture its return value in some variable in the script. Please suggest some way to do it. Thanks
SELECT @@VERSION;
GO
This displays the version of MySQL when running from MySQL command prompt.
I am able to run sql scripts from InstallShield 2009.
This script is also running successfully but I need to capture its return value in some variable in the script. Please suggest some way to do it. Thanks
(1) Reply
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Jun 07, 2009
12:08 AM
ajohri wrote:
I want to run the following query to find version of MySQL
SELECT @@VERSION;
GO
This displays the version of MySQL when running from MySQL command prompt.
I am able to run sql scripts from InstallShield 2009.
This script is also running successfully but I need to capture its return value in some variable in the script. Please suggest some way to do it. Thanks
You would think that this would be easy to do. However, I have asked for the same functionality as it does not exist in IS2009. Maybe it will in IS2010! About the only way I can think to do this would be to write a Managed Code assembly and execute it as a Custom Action. In the Managed Code assembly, you would have to do all the grunt work of connecting to the SQL Server, executing the query, and getting the result value into a variable that could be passed back to InstallShield.
Sorry, I know this is a lot of work but as I previously stated, this functionality does not exist in the current release of InstallShield.
Tim
![](/skins/images/8CE4FAD0DE6F3A6F9D0567434D2D2DAE/responsive_peak/images/icon_anonymous_message.png)