Welcome to the SQLitening support forums!
Started by cj, December 04, 2011, 07:31:46 PM
QuoteHopefully, slGetChangeCount indicates that the last insert was successful?Just tested count and equals 1 if multiple records inserted within a transaction.
QuoteTo reuse a deleted rowid should a list of deleted rowid's be kept?
Function MyslGetInsertID( sInsertSQL AS STRING) AS QUADLOCAL qResult AS QUADslEXE "BEGIN EXCLUSIVE;" + sInsertSQLqResult = slGetInsertID()slEXE "Commit;"FUNCTION = qResultEND FUNCTION
Quote from: cj on June 28, 2016, 01:36:56 PM...On second thought, another user could have inserted 9999 and you would think you inserted it (perhaps with different column values.) ...
Quote...Transactions can be started manually using the BEGIN command. Such transactions usually persist until the next COMMIT or ROLLBACK command. ...