Hi everyone!
I need a RETURNING clause to get the rowid after inserting but it doesn't seem to work.
I tried
if SQL.InsertIntoTable('INSERT INTO table ... VALUES ... RETURNING rowid;') then showmessage('inserted') else showmessage('not inserted');
but it gives me "not inserted" and
SQLCursor.GetRowCount returns 0. Removing the RETURNING clause results in "inserted" so the INSERT clause itself is correct, the problem is the RETURNING clause.
I also tried to do it with
ExecSQL but with the same result.
is there any way to use a RETURNING clause?