Code: Select all
local tSQL
local tTmp
on mouseUp
global gConID
if gConID = "" then
answer information "No Database Connected"
exit mouseUp
end if
put "CREATE TABLE places (placeID integer primary key, company text, address text)" into tSQL
answer tSQL
put revExecuteSQL gConID tSQL, tTmp *****error line*****
handleRevDBerror tTmp
if the result is not empty then
answer warning the result
exit mouseUp
end if
answer information "No of Tables Added: " & tTmp
end mouseUp
button "Create Places Table":execution error at line 11 (Handler: can't find handler) near "gConID", char 8
That sounds to me like it can't find the rev function ExecuteSQL, but how could that be? Thanks in advance for any help.