We’re moving our forums to a new platform.

You can still browse and search existing topics, but you can no longer create new topics or post replies.

For questions, technical issues, or feature requests, please don’t hesitate to contact our support team at support@advancedinstaller.com.

Thank you for your understanding!

tgillitzer
Posts: 36
Joined: Tue Dec 13, 2011 12:12 am

SQL Script as Custom Action

I'd like additional flexibility with running SQL Scripts in my installers. In genera, the features around the built in SQL Scripts functionality is good, I just need more flexibility around when they are run, add non-SQL commands in between them, etc.

I have generally avoided calling EXE's with custom actions because of dealing with dialogs, etc.

It looks to me like the SQL Scripts are effectively a custom action that Advanced Installer has baked into the Advanced Installer application. Am I allowed (supported) to use this directly through a normal custom action?
Eusebiu
Posts: 4971
Joined: Wed Nov 14, 2012 2:04 pm

Re: SQL Script as Custom Action

Hi,

Can you please explain more in detail about what you want to achieve so we can know if there is any workaround for this?

Best regards,
Eusebiu
Eusebiu Aria - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
tgillitzer
Posts: 36
Joined: Tue Dec 13, 2011 12:12 am

Re: SQL Script as Custom Action

A few things I can think of include:
doing something in the installer (install a file, run a different custom action, etc) between running two separate scripts
this probably can't be done with your DLL, but running a SQL script select a value out of a database to populate a property to display in a dialog

Some of our applications have some pretty intense database upgrade logic and to use AI/MSI's to maintain them, we need to be able to do some of the same things.

If it is supported to use the AI SQL DLL, we'll give that a try.

Thanks
Eusebiu
Posts: 4971
Joined: Wed Nov 14, 2012 2:04 pm

Re: SQL Script as Custom Action

Hi,
doing something in the installer (install a file, run a different custom action, etc) between running two separate scripts
I'm afraid we don't have this feature. You can create your own custom action with this functionality.
but running a SQL script select a value out of a database to populate a property to display in a dialog
This feature is already on our TODO list an will be available very soon.

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

Re: SQL Script as Custom Action

Hi,

This improvement has been added in version 10.1 of Advanced Installer. For more details you can take a look on the SQL Query article.

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

Return to “Building Installers”