Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I find position change on change of order
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01524052
Message ID:
01524053
Views:
63
There's no such thing in VFP as a record position in an index. What do you need it for?


>I have a table, with two indexes. (In a cdx file)
>
>I need to know the new place in the table when the order changes.
>ie if it is the second record in the table in sort order #1, what is it
>in order #2.
>
>Let say that in order 1 it is the 2nd record, but in order #2 it would
>be the fifth record.
>How do I find out when I switch order, what position it's in?
>
>Can't use recno(), what other functions is there.
>Mike
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform