Executing multiple statements in Query Window

[DonS100]

Hello, how would you execute multiple queries at one in the Query Window. When I run the two lines below I get the following message. syntax error (missing operator) in query expression 'staffcode = 'gmz' update staffcode set lastname = 'Test' where staffcode = 'gmz''

update staffcode set lastname = 'Test' where staffcode = 'gmz'
update staffcode set lastname = 'Test' where staffcode = 'gmz'

Thanks

Don

 

[PHV]

Why would you execute twice the same update query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[BNPMike]

You don't need a fresh query for each line you're updating if it is a common sequence.

If you are trying to do several different types of update then create individual queries and run them as a batch eg with a macro.