TMyScript and LAST_INSERT_ID

ben · Post by **ben** » Wed 21 Dec 2005 14:48

I Have a TMyScript that adds some records and I want to know the last auto ID inserted.

I tried to execute a TMyQuery with SELECT LAST_INSERT_ID() but it returns 0.

any idea?

Ikar · Post by **Ikar** » Fri 23 Dec 2005 10:48

Try to connect MyQuery to MyScript and use MyQuery.AfterExecute event to get MyQuery.InsertId property value

ben · Post by **ben** » Sun 25 Dec 2005 09:33

any example how to connect myquery with tmyscript?

Ikar · Post by **Ikar** » Mon 26 Dec 2005 10:52

Just place MyScript and MyQuery components to form and set MyScript.DataSet to MyQuery.