That behaviour could be fixed by converting VM to SM which
select/readnext leaves alone... Still pretty quick. I just did a test
using the code below on an 85000 att array and it took .086 seconds on a
low spec dev machine.
convert @vm to @sm in IN.TAB
select IN.TAB
loop while readnext IN.LINE do
CUST.NUM = IN.LINE<1,1,1>
CUST.DESC = IN.LINE<1,1,2>
repeat
Stuart Boydell
>-----Original Message-----
>My first test did not have @vm's and it looked like it worked
>but when I put in @vm's, anything after them is ignored.
>>READNEXT could be an option
**********************************************************************
This email message and any files transmitted with it are confidential and
intended solely for the use of addressed recipient(s). If you have received
this communication in error, please reply to this e-mail to notify the sender
of its incorrect delivery and then delete it and your reply. It is your
responsibility to check this email and any attachments for viruses and defects
before opening or sending them on. Spotless collects information about you to
provide and market our services. For information about use, disclosure and
access, see our privacy policy at http://www.spotless.com.au
Please consider our environment before printing this email.
**********************************************************************
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/