Query Not Completing

[smith8867]

I have this update code:

Code: Select all

   put paymentDate into SQLarray[1]
   put paymentID into SQLarray[2]
   put "UPDATE payments SET date=:1, completed=1 WHERE paymentID=:2" into dbSQL
   //
   revExecuteSQL connectionID, dbSQL, "SQLarray"
   //
   get executeSQL("COMMIT")

   if the result is an integer then
      answer "Record Updated"
   else
      answer "There was a problem adding the record to the database:" & cr & the result
      exit to top
   end if

LiveCode runs it, however it doesnt actually update anything in the database.

I can't seem to find the problem.
Any help would be much appreciated.

[smith8867]

Nevermind, I got it working