Synametrics Technologies

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,