Thanks Dave!!!

Sometimes the extra eyes make it go....

:-)

Ric

>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?