Query Not Completing
Posted: Mon Apr 11, 2016 8:46 pm
I have this update code:
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.
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
I can't seem to find the problem.
Any help would be much appreciated.
