SQL CustomActions are written using the standard "schedule"/"execute" mechanism. The "schedule" CustomActions read the tables in immediate mode and marshals the data to the "execute" CustomActions that do the work in deferred mode. So you need to make sure you add the tables before the SQL CustomActions run.
-----Original Message----- From: Nic Barden [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2008 18:04 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
