I'm using the code
AConnection.ExecSQL( 'Insert into CSZ ( Zip, City, State ) values ( :Z, :C, :S )',
[txtZipcode.Text, txtCity.Text, FieldValues['St']] );
to insert a record into the table CSZ. It has an Auto_Increment primary key. How can
I use the MySQL function
Last_Insert_ID()
to return the value of that last primary key inserted????
Thanks,
Jim Sawyer
Connect with Us