[SOLVED] [LAMW] RETURNING clause with SQLite.InsertIntoTable
lazarus / 43-Android

----------------------------------------------------------------------
r.lukasiak · 2021-12-02 23:41

Hi everyone!

I need a RETURNING clause to get the rowid after inserting but it
doesn't seem to work.
I tried
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i 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?

----------------------------------------------------------------------
jmpessoa · 2021-12-03 18:08

Quoteis there any way to use a RETURNING clause?

No.

----------------------------------------------------------------------
r.lukasiak · 2021-12-03 20:52

ok, I understand. And is there any way it will work any time in the
future or it's just, for some reason, impossible?
I was combing this forum and I found out that I can use mORmot, I will
give it a try meanwhile.

----------------------------------------------------------------------
jmpessoa · 2021-12-04 01:22

Quoteimpossible?

No. but "RETURNING"  not is [yet] a SQL standard and will fail in many
old android devices....

----------------------------------------------------------------------
r.lukasiak · 2021-12-05 03:59

ok, I understand. Thanks a lot!