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
- :
- InstallAnywhere
- :
- InstallAnywhere Forum
- :
- Re: externalize the order of file processing?
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
‎Aug 30, 2010
07:06 AM
externalize the order of file processing?
i would like to be able to have a file specifying what sql files get executed in which order. i can code all that without using the IA apis but that seems to defeat the purpose of having the tool! i've used the database 'hosts' to execute sql files and that works nicely, but only for hard coded sql file names and we'd like the ability to easily edit the file list to execute without having to rebuild the installer.
thoughts appreciated!
thoughts appreciated!
(2) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Aug 30, 2010
08:08 AM
On this page: http://www.flexerasoftware.com/products/installanywhere/files-utilities.htm you can find the Database Action plugin: http://www.flexerasoftware.com/downloads/customcode/DataBaseCustomCode.zip
So all you need to do is to call the the plugin for the different .SQL files you need to run. However, I don't think you can ever find a solution that would let you change the execution order within the installer... unless you write custom code.
The custom code action connects to a database, reads SQL from a file, executes the queries, and closes the database.
So all you need to do is to call the the plugin for the different .SQL files you need to run. However, I don't think you can ever find a solution that would let you change the execution order within the installer... unless you write custom code.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Aug 31, 2010
06:37 AM
thanks Vlad. i guess i need to customize that custom code to get the external file containing the list of files, and then do the sql file execs.
i've also got to make it work with 2 types of db's and thus have to build the 'URL' for the connection, etc. sigh... the run sql script standard action for each db host seems a lot easier.
i've also got to make it work with 2 types of db's and thus have to build the 'URL' for the connection, etc. sigh... the run sql script standard action for each db host seems a lot easier.
![](/skins/images/CC38E504FC9E1309DC48ACFEB4925670/responsive_peak/images/icon_anonymous_message.png)