2 messages in com.mysql.lists.win32Delphi and mySQL AUTOINCREMENT
FromSent OnAttachments
ian_...@tiscali.co.uk22 Jul 2004 07:15 
Petr Vileta22 Jul 2004 18:00 
Subject:Delphi and mySQL AUTOINCREMENT
From:ian_...@tiscali.co.uk (ian_@tiscali.co.uk)
Date:07/22/2004 07:15:10 AM
List:com.mysql.lists.win32

I am using Delphi 5 and 7. When I post a new record into a table which is keyed on an autoincrement field I do not get a result set back telling me the number the server has allocated to the record.

I am using a TQuery component to execute the SQL statement. Are there any way to retrieve the result set back on posting? I have checked all associated properties, methods and events etc... but nothing seems to work.

TIA

__________________________________________________ Broadband from an unbeatable £15.99!

http://www.tiscali.co.uk/products/broadband/home.html?code=SM-NL-11AM