Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Compute many operations
Message
From
09/09/2004 19:10:11
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00939290
Message ID:
00940883
Views:
22
hi
i'll try as under
i get message variable"rn" is not found
 select table2 && Note, that we need to open table2 only once, not in the scan 
     append from dbf("crsRand")
       select crsRand
scan
   goto rn in Table1 && move record pointer to rn record in table1
   delete in Table1
endscan

    *delete from table1 where recno() in (select rn from crsRand)
    *use in crsRand && we do not need our crsRand anymore
thanks
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform