Does DoSQL support the "SELECT LAST_INSERT_ID()" statement?
No, DoSQL does not support the "SELECT LAST_INSERT_ID()" but it
supports ROWID which returns the internal recordid.
You can use the following statement to get the last recordid:
let (
theSQL = "SELECT MAX(rowid) from myTable";
mFMb_DoSQL( theSQL )
)
-
AutoSender
- What are the limitations of the AutoSender demo version ?
- How exactly does AutoSender function ? Is it a FileMaker plug- in ?
- Is it possible to use AutoSender with Instant Web Publishing solutions ?
- Which items are installed and where (Mac OS X)?
- Which items are installed and where (Windows)?
- View all (15 more)
-
Clip Manager 4.x for Mac
- Is Clip Manager 4.x compatible with FileMaker Pro 12?
- I get a message "Oops, we messed up! Clip Manager must quit." What should I do now?
- Table Occurrence Selector doesn't show any table occurrences.
- When coping a layout to Clip Manager, will the sections of the layout also transfer?
- Is the demo version of Clip Manager limited in functionality ?
- View all (3 more)
-
Clip Manager Express for Windows
-
DoSQL
- Can DoSQL be used in a runtime solution
- What types of SQL statements can be used with DoSQL ?
- Is it possible to use 'CREATE TABLE' with DOSQL in the database that a script is called?
- Can DoSQL be used as a FileMaker Server plug-in ?
- Does DoSQL support the "SELECT LAST_INSERT_ID()" statement?
- View all (4 more)
-
DoScript
-
eID & SIS plug-in
-
PrinterSwitch
- What are the limitations of the PrinterSwitch demo version?
- What is installed by the PrinterSwitch installer and where?
- Can I use FileMaker Server’s AutoUpdate feature with PrinterSwitch?
- I am trying to create a PDF with PrinterSwitch, but when printing nothing seems to happen (MacOS X)
- I used PrinterSwitch to select a printer, but when in the Print dialog the 'Save as PDF' and 'Preview' buttons do not function (MacOS X)
- View all (11 more)