goset
Posts: 8
Joined: Thu Sep 01, 2011 2:22 pm

sql Client/Server

I have scripts to run on my install. I find that the scripts are being ran even on the client. Is there a way to make them only run on the server install?
Eusebiu
Posts: 4959
Joined: Wed Nov 14, 2012 2:04 pm

Re: sql Client/Server

Hi,

In order to achieve this you can go in the SQL Scripts page, select your scripts and in the "Condition" field use the following condition: InstallMode = "Server"

Best regards,
Eusebiu
Eusebiu Aria - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
goset
Posts: 8
Joined: Thu Sep 01, 2011 2:22 pm

Re: sql Client/Server

I would like to say this works but it does not. I have attached a screen shot attached. But the scripts still do not run.
Attachments
Untitled.png
Untitled.png (9.08 KiB) Viewed 4751 times
Eusebiu
Posts: 4959
Joined: Wed Nov 14, 2012 2:04 pm

Re: sql Client/Server

Hi,

I'm not sure why you encounter this behavior. Can you please send us the .AIP (project file) and a verbose log of the installation to support at advancedinstaller dot com so we can investigate them?

Best regards,
Eusebiu
Eusebiu Aria - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
Eusebiu
Posts: 4959
Joined: Wed Nov 14, 2012 2:04 pm

Re: sql Client/Server

Hi,

Indeed, this seems to be an Advanced Installer issue because the [InstallMode] property is a private property and its new value is not passed from the UI Sequence to the Install Execute Sequence.Thank you for bringing it to our attention.

As a workaround, you can go in the Install Parameters page and create one public property (i.e. INSTALLTYPE). Then go on the "ClientServerDlg" dialog from the Dialogs page, select each installation type buttons (Client, Server, Complete) and create a new "Set installer property value" published event for each of them where you can set the [INSTALLTYPE] property created earlier to the [InstallMode] property's value like in the example below:
  • Property: INSTALLTYPE
    Argument: [InstallMode]
Then you can use this property in the "Script Condition" field of your SQL scripts (i.e. INSTALLTYPE = "Server").

Let us know if this helped.

Best regards,
Eusebiu
Eusebiu Aria - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
goset
Posts: 8
Joined: Thu Sep 01, 2011 2:22 pm

Re: sql Client/Server

This work around did not work. I am starting to lose faith in this product. This is a very important reason I wanted to use this software and I have been trying off and on for over a year now to get this function to work. There really need to be a fix for it soon or something. I just did update thinking maybe that would help.
Eusebiu
Posts: 4959
Joined: Wed Nov 14, 2012 2:04 pm

Re: sql Client/Server

Hi,

I'm not sure why the above workaround didn't work for you because I tested it and everything worked as expected. Can you please tell me what is the problem that you encounter? Otherwise, can you please send me the AIP file so I can see if it is correctly configured?

Best regards,
Eusebiu
Eusebiu Aria - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

Return to “Building Installers”