Revolving around the core of technology
Hello,
I downloaded WinSQL to test before I purchased and was trying to run the following script which did not run. I received the error (Unexpected extra token: UPDATE). Does WinSQL allow for multiple lines of scripts to be ran such as the one below? I’m using this with FlexQuarters QODBC (QuickBooks). If there is another way to do this statement with your software it would be much appreciated?
UPDATE ItemInventory set CustomFieldVol2CatalogPageNo = '55' where Name = 'G03617-CHAMPAGNE';
UPDATE ItemInventory set CustomFieldVol2CatalogPageNo = '55' where Name = 'G03617-CLEAR';
Thanks,
Armando
Hello Armando,
You need to separate the queries by a Query Terminator, which is set to ?go? by default. Check http://web.synametrics.com/QueryTerminator.htm for details. Let us know if you have further questions.