Josh,
yep, right again! Thanks for all the help!
Laurisa
-----------------
>Laurisa,
>
>I think you've run into VFP's 255 byte limit on a single string. This is easily solved by just concatanating smaller strings together. Try this:
>
>vtest3=sqlexec(vtest,;
> "insert into pmwrkord (pmwrkord_code,spbldinf_code,spbldrom_code,;
> pmshop_code,pmpricd_code,pmactv_code,pmbldsys_code,pmfacprj_code,"+;
> "its_current_date,status,wo_type,description) ;
> values (9200014,'ALKICC','101','SSS','2','EVEN',;
> 'SERV','WP31401',?dtoday,'O','D','A Test')")
Note that the first string ends at the end of the third line and is concatenated to the string that starts on the fourth line with a ".
>
>>Sure...
>>
>>vtest3=sqlexec(vtest,;
>> "insert into pmwrkord (pmwrkord_code,spbldinf_code,spbldrom_code,;
>> pmshop_code,pmpricd_code,pmactv_code,pmbldsys_code,pmfacprj_code,;
>> its_current_date,status,wo_type,description) ;
>> values (9200014,'ALKICC','101','SSS','2','EVEN',;
>> 'SERV','WP31401',?dtoday,'O','D','A Test')")
>>