PDA

View Full Version : Another SQL Querie



NYASMark
06-11-2004, 08:22 AM
Is there a way of running an sql script to retreive a count, and pass the result through to another sql script?

johnludlow
06-11-2004, 08:59 AM
You can use text replacements to pass values to SQL scripts. But as far as I know there is no way to get a result out of an SQL script.

For this you could execute the count statement from a VBScript custom action.

NYASMark
06-11-2004, 10:12 AM
Is it possible to use more than one property in the replace field?

johnludlow
06-11-2004, 10:14 AM
Haven't tried it myself but I don't see why not.

miryamgb
06-11-2004, 10:30 AM
If you encounter unexpected and unexplained rollback during run time when using text replacement there is a hot fix from InstallShield.

http://community.installshield.com/showthread.php?s=&threadid=134733

Miryam

NYASMark
06-11-2004, 10:34 AM
Thanx alot guys.