Hi! I downloaded the SQLite3 Plugin from mindquake.com.br (great plugin!) and when I try to use "GetLastInsertRowID" I always get a "nil value" error. Is this action broken?
(when I click on the Help link in the wizard popup in the code editor the help link for this action is broken and opens multiple tabs for each folder)
I tried to call it directly after inserting values and a few lines below after the error check but its always a nil value. But why? The data was inserted.
Its a nil value when I try it when the db is still open and when I close the dp and reopen it for this command.
(when I click on the Help link in the wizard popup in the code editor the help link for this action is broken and opens multiple tabs for each folder)
I tried to call it directly after inserting values and a few lines below after the error check but its always a nil value. But why? The data was inserted.

Its a nil value when I try it when the db is still open and when I close the dp and reopen it for this command.
Code:
OpenDB(); SQLite3.Query(db, "insert into Anzeigen values(NULL,"..nKategorie..",'"..strTitel.."','"..strName.."','"..strTelefon.."','"..strBeschreibung.."','"..strBildname.."','"..strPreis.."',"..nPreisArt..",'"..strDate.."',0,NULL,14,'"..strPasswort.."')"); nRowID = SQLite3.GetLastInsertRowID(db); nLastError = Application.GetLastError(); if nLastError ~= 0 then strErrMsg = SQLite3.GetLastErrorString(); Dialog.Message("Notice", "Error: " .. SQLite3.GetErrorString(nLastError).."\n\n"..strErrMsg, MB_OK, MB_ICONINFORMATION, MB_DEFBUTTON1); end -- Anzeigen ID vom letzten Eintrag auslesen und mit Passwort anzeigen (für Nachrichtensystem) CloseDB();
Comment