Howdy all --
I have just recently learned of UPDATE-SQL and am now trying to use it. There's something I have missed, however, because the following executes really slow ... a minute or more to execute!
Update KitDetail Set ;
ReceivFlag = .T. ;
From c_TransferDetail ;
Where c_TransferDetail.Received ;
And c_TransferDetail.NonInvID = KitDetail.UniqueKey ;
And KitDetail.UniqueKey # 0
KitDetail is table indexed by UniqueKey.
c_TransferDetail is a cursor with maybe 20 to 50 records in it.\
Previously, I handled this with SET RELATION into KitDetail, and it completed essentially instantly.
OK, so what am I missing here?
Thanks so much in advance,
Jim Nelson
Newbury Park, CA