Devart Forums

Posted: **Wed 02 Mar 2005 00:51**

Hello, is it possible to know the auto incremental ID before doing the insert? Just to display in the user interface what is the next ID.

Thanks

Posted: **Wed 02 Mar 2005 09:03**

Not, MySQL doesn't provide such functionality.

Posted: **Wed 02 Mar 2005 23:39**

Well, it supports:

show table status like 'tablename' and read the "Auto_increment" field.

Posted: **Thu 03 Mar 2005 12:34**

In the interval between this query and Post execution it might be an insertion of records from another client

Posted: **Thu 03 Mar 2005 19:25**

yes thats why you are doing a LOCK TABLE before. Anyway my application is single user.

Posted: **Fri 04 Mar 2005 10:58**

Your solution most likely will work.

Know the autoincremental ID before insert