Hi everyone...

This works where ln_last and ln_1 are numeric values in variables.

myresult = SQLEXEC(1,'Insert INTO phone (phon_phoneid, phon_personid) VALUES (' + STR(ln_last + 1) + ;
', '+ STR(ln_1) + ')')


Then I try and add a character variable into a character field and get a syntax error:

myresult = SQLEXEC(1,'Insert INTO phone (phon_phoneid, phon_personid, , phon_type) VALUES (' + STR(ln_last + 1) + ;
', '+ STR(ln_1) + ', '+ lc_bus + ')')

This doesn't work.


Do you know how to format this correctly to get the variable value going through?

Thanks

Ric