Hi
I'm trying to insert a new record into the ControlEvent. The query goes like:
"INSERT INTO `ControlEvent` (`Dialog_`,`Control_`,`Event`,`Argument`,`Condition`,`Ordering`) VALUES ('EulaForm','NextButton','NewDialog','[EulaForm_Inst_NextArgs]','EulaForm_Inst_NextArgs<>"" AND Installed',2)"
The problem comes in the condition value (EulaForm_Inst_NextArgs<>"" AND Installed). The value entered to the MSI table is: EulaForm_Inst_NextArgs<> AND Installed (without the empty string ""), which is a conditional string error.
How can I escape this and insert the empty string("")? been trying all kind of variations with no success.
Thanks in advance!
This is a ready-only archive of the InstallSite Forum. You cannot post any new content here. / Dies ist ein Archiv des InstallSite Forums. Hier können keine neuen Beiträge veröffentlicht werden.
INSERT query on WiRunSQL.vbs
Started by
eelisdotnet
, Jun 05 2006 13:43
2 replies to this topic
Posted 06 June 2006 - 08:08
One possible escape format is like CHAR(72) but you'd have to look up the correct ASCII code yourself. However in your case there's an easier workaround because an empty string is "false". So the following two are equivalent:
SomeString=""
Not SomeString
and thus your condition
EulaForm_Inst_NextArgs<>"" AND Installed
could be changed to simply
EulaForm_Inst_NextArgs AND Installed
SomeString=""
Not SomeString
and thus your condition
EulaForm_Inst_NextArgs<>"" AND Installed
could be changed to simply
EulaForm_Inst_NextArgs AND Installed
Stefan Krüger
InstallSite.org twitter facebook
Posted 06 June 2006 - 09:11
Thanks Stefan!
I just managed to run it correctly using the Database.OpenView(insert query..) and View.Execute. seems to work just fine.
Cheers!
I just managed to run it correctly using the Database.OpenView(insert query..) and View.Execute. seems to work just fine.
Cheers!