>Hi All,
>
>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

In addition, CAST function was added in VFP9 too.

For VFP8 it looks like you may want to use traditional scan / endscan approach, e.g.

select Results
scan
   if seek(ConfigCharEight, m.lcArrivalFilePath, 'PieceID')
        replace uText5 with Results.ProNumber, ;
       utext6 with transform(Results.ScheduledShipDate) in (m.lcArrivalFilePath)
  endif
endscan