>>I was not sure if VFP6 accepts:
>>UPDATE ...;
>>FROM ....;
>>INNER JOIN ....
>
>update it can to be slow a lot,
>join is not required here
>
>UPDATE WOMaster SET WOPrinted = .T. WHERE WONumber IN (SELECT WONumber FROM workorders)
>
You may also write it using EXISTS, could be quicker.
If it's not broken, fix it until it is.
My Blog