SQLite insert data from variables: error unrecognized token

[chris0879]

this bis my code:

Code: Select all

on mouseUp
   
   databaseConnect
    
    local tFname
put "myname" into Nome
   put "myemail" into Mail
   
    put getDatabaseID() into tDatabaseID
    
    
    put "INSERT into contact_details    (nome, email)         VALUES (' " & Nome& " '," & Mail& "');" into tSQL
       
    

    
    revExecuteSQL tDatabaseID, tSQL
   
   put the result into tRes
   if tRes is not a number then
      answer error "There was a problem saving this record: " & tRes as sheet
   end if
   
   
   
   
end mouseUp

error display: unrecognized token.

where is the error?
Thanks!

[dunbarx]

Hi.

Which line threw the error?

Craig Newman

[chris0879]

I can not see where it blocks the code!
This is a screenshot of the error!
thanks!

[chris0879]

I solved:
after comma
VALUES (' " & Nome& " ',
omit
'
thanks anyway!

[Klaus]

Hi Chris,

in cases like this always check the resulting SQL, here is what your script will produce:
...
INSERT into contact_details    (nome, email)         VALUES (' myname ',myemail');
...
Lots of SPACES***, and even missing single quotes...
No wonder this will create an error.

***Will maybe not harm the funcitonality, but makes it very hard to read!


Best

Klaus