PureBasic Forums - English

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:

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

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

Nice!

Thanks & Greetings ... Peter

PureBasic Forums - English

SQlite: Count affected rows

SQlite: Count affected rows

Re: SQlite: Count affected rows