Code: Select all
on MouseUp
global gConID
put field "FName" into tFName
put "INSERT INTO apps (appName) " into tSQL
put "VALUES (" & tFName & ");" after tSQL
revExecuteSQL gConID, tSQL
if the result is not 1 then
answer warning the result
exit to top
end if
end mouseUp
however I get this error "Microsoft ODBC SQL SERVER driver invalid column name" and what ever is the input from the field
here are my table and the table names
TABLE "apps" (
"appID" INT NOT NULL,
"appName" VARCHAR(50) NOT NULL,
"appRegCode" VARCHAR(50) NULL DEFAULT NULL,
"appUserID" VARCHAR(50) NULL DEFAULT NULL,
PRIMARY KEY ("appID")
)
I try to understand what I am doing wrong
Thank you
J