Last Inserted ID

This is the place to post technical queries about SQL Yoga

Moderators: FourthWorld, heatherlaine, Klaus, robinmiller, trevordevore

Last Inserted ID

Postby nrprioleau » Mon Oct 10, 2016 11:01 am

Please can I have the right syntax to use for retrieving the last inserted id after creating a record?

I have this which returns 0

Code: Select all
command mlteSales_CreateSales pRecordA
   local tSqlQuery, tSqlParamsA, tRowid
   --
   sqlquery_create "sales", pRecordA
   put the result into theError
   put it into theAffectedRows
   -- now get the brand new id
  dbconn_lastInsertedID
   return tRowid
end mlteSales_CreateSales
nrprioleau
 
Posts: 24
Joined: Mon May 09, 2016 10:53 am

Re: Last Inserted ID

Postby AxWald » Tue Oct 11, 2016 6:36 pm

Hi,

"lastInsertedID" might not be what you want, read the documentation about. It'a a highly situational function ...

To get the last value of a auto-increment ID, usually:
Code: Select all
SELECT MAX(ID) FROM `MyTable`;

does the job - as long as the last insert didn't re-use a "ID hole" from a previously deleted record. But since such can only occur due to "manual" overrides of the auto-increment, you should know about ;-)

Assuming SQLYogas "lastInsertedID" does what the equally named MySQL function does, and that you can translate my SQL to SQLYoga, hope I could help ;-)

Have fun!
Livecode programming until the cat hits the fan ...
AxWald
 
Posts: 271
Joined: Thu Mar 06, 2014 2:57 pm

Re: Last Inserted ID

Postby trevordevore » Thu Mar 02, 2017 4:14 pm

@nrprioleau - in your function tRowId is never set to anything. dbconn_lastInsertedID puts the id into the it variable. You would want to return it rather than tRowId. Or put it into tRowId and then return tRowId.
Trevor DeVore
ScreenSteps
www.screensteps.com
LiveCode Resources for Developers: http://livecode.bluemangolearning.com
trevordevore
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
 
Posts: 799
Joined: Sat Apr 08, 2006 3:06 pm
Location: Overland Park, Kansas


Return to SQL Yoga

Who is online

Users browsing this forum: No registered users and 2 guests