Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Determine relative record position
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00149770
Message ID:
00149814
Views:
22
>Assuming that lnStart and lnEnd contain the RecNo() of the first and last record of the range respectively.
>
>GOTO lnStart
>
>DO WHILE NOT EOF() AND (RecNo() <> lnEnd)
>   DELETE
>   SKIP
>ENDDO
>
>
>HTH
>
>>I'm selecting two records in a table so I can copy or delete all the records between each of the selected record. My problem comes when the table is indexed. Is there a way to do this? I'm having a problem determining if the second record is before or after the first record. I'm using 5.0a. TIA


The problem is knowing if lnStart or lnEnd comes first when you have an index active. Cetin Basoz gave me a routine. Thanks for the help...
Previous
Reply
Map
View

Click here to load this message in the networking platform