The UPDATE-SQL command in VFP8 and earlier does not support JOINs.
>
>When trying to compile/rebuild a prg in VFP 8 it fails with the syntax error message refering to the following line of code:
>
>UPDATE a ;
>SET a.utext5 = b.ProNumber, ;
> a.utext6 = CAST(b.ScheduledShipDate as char(30)) ;
>FROM (lcArrivalFilePath) a JOIN Results b ;
> ON a.pieceid = b.ConfigCharEight
>
>It does work fine in 9.0 ...
>Thank you,
>Daniel
--sb--