Hi,
Whenever i try to run multiple update queries at the same time , i will encounter this error "Characters Found After End Of SQL Statement".

update Table1
set ColumnA="A"
Where ColumnB="B";

update Table1
set ColumnA="C"
Where ColumnB="D";


Do any one has idea on how to overcome this?
I find online and some suggest that make a macro and run the queries in the macro.
BUT
I find out that the queries that i can put into macro does not support multiple update queries at the same time.

Does anyone has idea on this?

TQ...

The error "Characters Found After End Of SQL Statement" refers to the colon at the end of your first update statement. When writing SQL there should only be one colon and it should alwys be the last character.