This is the place to post technical queries about SQL Yoga
Moderators: Klaus, FourthWorld, heatherlaine, robinmiller, trevordevore
- Posts: 27
- Joined: Mon May 09, 2016 10:53 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
- Posts: 426
- Joined: Thu Mar 06, 2014 2:57 pm
"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:
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 ;-)
Livecode programming until the cat hits the fan ...
- VIP Livecode Opensource Backer
- Posts: 986
- Joined: Sat Apr 08, 2006 3:06 pm
- Location: Overland Park, Kansas
@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.
ScreenSteps - https://www.screensteps.com
LiveCode Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode
LiveCode Builder Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode-builder