SQlite: Count affected rows

dige · **Posted:** Wed Nov 06, 2019 2:43 pm

If you need to know whether an DatabaseUpdate() has caused a change, you can query this as follows:

Code:

Procedure.i Sqlite3_CountChanges (DBID)
  Protected SQL.S = "SELECT changes()", Result.l = -1
  
  If DatabaseQuery(DBID, SQL)
    If NextDatabaseRow(DBID)
      Result = GetDatabaseLong(DBID, 0)
    EndIf
    FinishDatabaseQuery(DBID)
  Else
    Debug DatabaseError()
  EndIf
  
  ProcedureReturn Result
EndProcedure

Kiffi · **Posted:** Wed Nov 06, 2019 3:43 pm

Nice!

Thanks & Greetings ... Peter

PureBasic Forum

SQlite: Count affected rows

Who is online