Ni Norm,
is workorders included in the exe?
Debug your exe. (Run exe from environment) and see if WOMaster changes
set step on
select workorders
SCAN
IF SEEK(workorders.WONumber,WOMaster','WONumber') THEN
select WOMaster
replace WOPrinted with .t.
ENDIF
ENDSCAN
BTW
SCAN ENDSCAN does not need !EOF(), it stop on EOF() anyway, ENDSCAN will reset work area to that of SCAN
Agnes
>I'm trying to update records that have been printed (the cursor "workorders" contains the work orders that have been printed). The records in the main table need to have a flag set so that they do not print again. The following code works perfectly when I'm debugging, however when running as an EXE nothing is updated, and it looks like the scan is not processing anything.
>
>
> select workorders
> go top
> scan while !eof()
> select WOMaster
> seek workorders.WONumber order tag WONumber
> if found()
> replace WOMaster.WOPrinted with .t.
> endif
> select workorders
> endscan
>
>
>Any observations or suggestions would be appreciated!
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]