Devart Forums

can run the following:

UPDATE NextId SET id=LAST_INSERT_ID(id+1);
SELECT LAST_INSERT_ID()

using NavICat on the Novell version of MySQL
(4.0.18b). However, when I run it from
TMyQuery, I get an syntax error. I can also
run the query (on one line) from the command
prompt. any ideas?

Support of executing several queries for one time could be available only in MySQL 4.1.
You can use TMyScript to solve the problem.