I'm having a little trouble with the syntax of defining the tSQLStatement. I'm getting a db error regarding the WHERE part of the statement. What am I doing wrong?
Code: Select all
on mouseUp
put fld "theID" into tID
put specialFolderPath("documents") & "/MyTestDB.sqlite" into tDatabaseFile
put revOpenDatabase("sqlite",tDatabaseFile) into sDatabaseID
if tID is not empty then
put "SELECT MyInfo(MyName,MyType, WHERE theID = tID)" into tSQLStatement
revExecuteSQL sDatabaseID,tSQLStatement
end if
answer the result
end mouseUp