Ric,
You have to quote the text fields:
myresult = SQLEXEC(1,'Insert INTO phone (phon_phoneid, phon_personid, phon_type) VALUES (' + STR(ln_last + 1) + ', '+ STR(ln_1) + [, ']+ lc_bus + [')] )
And I assume you did not nave that excess , in your field list.
>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?