I have an application which is nearly complete except for one critical part -- saving data to the MySQL database. I have had great success in opening, reading, and closing the database. After scouring this forum, and trying many different iterations, I would now like to ask for help.
The line of code below works perfectly fine, but is not helpful:
Code: Select all
revExecuteSQL dbID, "INSERT INTO k1 VALUES(NULL, 'task', '0002', '222,333', 'Get a life dude')"
Code: Select all
# Update Database Records
repeat with x =1 to lastPostIt
put empty into dbRecord
put "INSERT INTO " & dbTable & " VALUES(:1,:2,:3,:4,:5)" into dbSQL
put dbArray[x,1] into dbRecord[1]
put dbArray[x,2] into dbRecord[2]
put dbArray[x,3] into dbRecord[3]
put dbArray[x,4] into dbRecord[4]
put dbArray[x,5] into dbRecord[5]
revExecuteSQL dbID, dbSQL, "dbRecord"
end repeat
(1) "lastPostIt" is a global variable indicating how many objects there are (one record per object).
(2) dbTable is a global variable.
(3) dbArray is global and its contents are based on what was read from the db -- the contents are valid (tested).
Any help would be greatly appreciated. I am not sure if it matters, but I am using Rev Studio 3.5.0 (Build 860) and MySQL 5.0.67-community (on the iRev server.
Thanks much,
Ed