Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Logical record numbers ?
Message
From
25/05/1999 06:34:31
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00222325
Message ID:
00222375
Views:
21
Hi Shane ---

This works best if your index order is based on a unique index:

USE customer ORDER lastname
COPY TO ARRAY aLogOrder FIELDS lastname
SELECT customer
SEEK "Smith"
nLogicalRecord=ASCAN(aLogOrder,customer.lastname)


>Does anyone know how to get the logical record number when you have an index order set. For instance, a customer table is indexed on last name. The 1rst record in the customer table might be the 10th record displayed when the index order is set to last name. I am looking for a quick function that would work like the go command ( ex. gological(10) ).
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Reply
Map
View

Click here to load this message in the networking platform