Nic, Is it just values to do with actually locating the database that you are trying to deal with. If so, my suggestion would be to make the actual script files neutral (ie do not mention the database or server name) and use the wix SQLDatabase entry locate/create the database. Then there would be no need for modifying the scripts.
If there other needs to update the scripts then I suggest you ues SqlStrings and put properties in the strings, as these get expanded for you. Michael -----Original Message----- From: Nic Barden [mailto:[EMAIL PROTECTED] Sent: Thursday, 9 October 2008 11:04 AM To: wix-users@lists.sourceforge.net Subject: [WiX-users] Intercepting the SQL CA Hi, I'm trying to perform token replacement on SQL script files (such as database name, server name etc) via a custom CA before the SQL CA executes them. I have successfully created the custom CA. However, I am unsure how to "intercept" the SQL CA to provide it the "new" files/scripts to execute. I am not fussed whether they are executed as SqlScripts or SqlStrings. I have tried adding the modified files to both the SqlScript and SqlString tables as temporary rows, however, they do not get picked up by the SQL CA. Is the SQL CA not seeing the temp rows that I am adding because it runs deferred, and cannot see temporary rows that I have added? Or do deferred CAs also have access to the temp rows that I am adding? Has anyone else got any ideas of how I can achieve the goal of having the SQL CA execute my modified files? Thanks! ------------------------------------------------------------------------ - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
