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: 264
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
Outcome | ScreenSteps
www.outcomeapp.io | www.screensteps.com
LiveCode Resources for Developers: http://livecode.bluemangolearning.com
trevordevore
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
 
Posts: 796
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 1 guest