Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Coding, syntax & commands
If you don't want to do the SEEK and COPY WHILE as Sergey suggests, it is better to not SET ORDER before doing the COPY FOR.
INDEX ON condition ...
SET ORDER TO
COPY TO ... FOR condition
>Thanks for your reply..I am actually doing what you are saying..here is the complete code:
>
>INDEX ON BINTOC(SIL_INV_FK) + BINTOC(SIL_INV_CFK) TAG SILMAIN
>SET ORDER TO SILMAIN
>COPY TO v_InventoryTemp FOR BINTOC(SIL_INV_FK) + BINTOC(SIL_INV_CFK) == BINTOC(tnINVPK) + BINTOC(tnINVCPK)
>
>where tnINVPK/CPK contain the correct values at runtime. COPY TO *is* giving me the correct records, but its performance seems very, very poor compared to that of the SELECT command.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only