SQL script execution,custom action using progress bar control [Archive]Hi. I have modified the code given in the thread. This piece of code works when there is no custom code in the for loop to increment the progress bar. But when I insert my code that actually executes a set of scripts, the progress bar is not incremented. Sample code: Const INSTALLMESSAGE_ACTIONSTART = & H8. Const INSTALLMESSAGE_ACTIONDATA = & H9. Const INSTALLMESSAGE_PROGRESS = & HA0.
Installshield Sql Script File
Const ERROR_INSTALL_FAILURE = 1. Const ERROR_SUCCESS = 0.
Function Add. Progress. Info()Set rec = Installer. Create. Record(3)rec. String. Data(1) = "call. Add. Progress. Info"rec.
String. Data(2) = "Incrementing the progress bar.."rec. String. Data(3) = "Incrementing tick [1] of [2]"Message INSTALLMESSAGE_ACTIONSTART, recrec.
Installshield Sql Script Sample
Integer. Data(1) = 1rec. Integer. Data(2) = 1rec.
Hi My requirement is to execute a set a sql scripts to create db/tables/insert data etc and use an msi for this. I have created a set of custom action vbscripts for this. Since the execution of these scripts take a lot of time, i need a vb script custom action script that increments ticks related to my custom action to the progress bar control of the windows installer. Can someone help me with this? Open topic with navigation. Conditionally Launching a SQL Script in an InstallScript Installation. InstallShield 2015. Project: This information applies to InstallScript projects. To launch one of those tools and open your script from within InstallShield, right-click the script file in the SQL Scripts view and then click Open Script in Microsoft SQL Server Management Studio. InstallShield searches your system for the following tools in order and launches the first one that it finds: 1. Microsoft SQL Server 2008 Management Studio (any edition, including Express; ssms.exe) 2. Attaching SQL database Hi all. I use the SQL Server view of InstallShield and have it script the database. during install it creates the db and runs the script. It should work on MSDE just as well as it works with SQL Server. 07-18-2004, 06:57 PM #5. ssharrock Guest Originally posted by PilotBob.
Integer. Data(3) = 0. Message INSTALLMESSAGE_PROGRESS, rec. Set progrec = Installer.
Create. Record(3)progrec. Integer. Data(1) = 2progrec. Integer. Data(2) = 5. Integer. Data(3) = 0rec. Integer. Data(2) = 5.
Do While i < 5. Integer. Data(1) = i' action data appears only if a text control subscribes to it. Message INSTALLMESSAGE_ACTIONDATA, rec. Message INSTALLMESSAGE_PROGRESS, progrec[ My code to execute scripts ]i = i + 5. Loop. Function Add.
Total. Ticks()Set rec = Installer. Create. Record(3)rec. Integer. Data(1) = 3rec. Integer. Data(2) = 5.
Integer. Data(3) = 0. Message INSTALLMESSAGE_PROGRESS, rec. Set rec = Nothing' return success to MSIAdd. Total. Ticks = 0. End Function. The above code does not work when I have my custom code to execute scripts placed in the While loop. I have configured the custom actions appropriately as mentioned in the thread earlier.
What could be the problem?
Help and assistance in setup development with Windows Installer and InstallShield. Free script code downloads, merge modules, tips and tricks, discussion boards, tools and services. Hi Peoples, I am currently having trouble with executing an SQL Script through my Installer Application. If i run the script through SQL Server it executes fine.