I needed to know the Master PKey of an Insert to associate all following detail records - before adding them...
Sub ABMGenSQLInsert(SQL As SQL, Query As String, Args As List) As Int
Dim res As Int
If UsePool Then
res = SQLSelectSingleResult(SQL, "SELECT LAST_INSERT_ID()")
res = SQLSelectSingleResult(SQL, "SELECT last_insert_rowid()")
Log("SQL Insert: "&LastException.Message)
res = -99999999
This module is GOLD! Once I figured out what it was doing...