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
- :
- Re: No See SQL Scripts on Server Configuration
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 18, 2007
01:18 PM
No See SQL Scripts on Server Configuration
Hi,
I need to make a SQL Connection in my InstallShield setup and in the HLP his talking about to add a SQL Scripts in Server Configuration and I don't see it on this panel. I created a MSI Database install.
Somebody can help me.
Thanks
Eric RIendeau
eric.riendeau@medisolution.com
Senior Programs Developper
I need to make a SQL Connection in my InstallShield setup and in the HLP his talking about to add a SQL Scripts in Server Configuration and I don't see it on this panel. I created a MSI Database install.
Somebody can help me.
Thanks
Eric RIendeau
eric.riendeau@medisolution.com
Senior Programs Developper
(4) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 18, 2007
05:21 PM
The SQL Scripts view is currently avaiable for Basic MSI, InstallScript MSI and InstalScript projects.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 19, 2007
12:19 PM
Thanks to everybody
I found it and now I'm able to run a script sucessfully but is possible to see the result of this script. Like evaluate a field value returned by a select? Or you can only run a no result script?
I.E: Select name, first_name frm client and i want to see the name in a dialog.
Eric Riendeau
I found it and now I'm able to run a script sucessfully but is possible to see the result of this script. Like evaluate a field value returned by a select? Or you can only run a no result script?
I.E: Select name, first_name frm client and i want to see the name in a dialog.
Eric Riendeau
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 19, 2007
11:05 PM
Unfortunately, the built-in SQL feature currently does not have the ability to allow you handle the results from SQL queries. You need to write your own code to manage database connections and run SQL statements. There are some sample codes available in this community forum:
http://community.macrovision.com/showthread.php?t=165473
http://community.macrovision.com/showthread.php?t=152884
Hope that helps.
http://community.macrovision.com/showthread.php?t=165473
http://community.macrovision.com/showthread.php?t=152884
Hope that helps.
![](/skins/images/A5EADE085F77DE82FB3B14D6B307AE6A/responsive_peak/images/icon_anonymous_message.png)