Query Not Completing

Creating desktop or client-server database solutions?

Moderators: Klaus, FourthWorld, heatherlaine, robinmiller, kevinmiller

Post Reply
smith8867
Posts: 57
Joined: Tue Nov 18, 2014 5:36 pm

Query Not Completing

Post by smith8867 » Mon Apr 11, 2016 8:46 pm

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
Posts: 57
Joined: Tue Nov 18, 2014 5:36 pm

Re: Query Not Completing

Post by smith8867 » Mon Apr 11, 2016 9:34 pm

Nevermind, I got it working :)

Post Reply

Return to “Databases”