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.