Bonjour Jean

I am perfectly aware of the seek command and seek function. But this is not what I need.

My client has a table with more than 3 million records and wants to skip through the records in company name order and show at the end of the page a label saying:

Page nnnn of 3456789

nnnn being the position of the record from the top. If another form is used to find a particular company name, then upon that form closing the record pointer will be placed on the selected record, showing all its fields, and at the bottom the above label, which, for the sake of this example could be:

Page 234567 of 3456789

Thank you for your reply anyways

Rafael Copquin



El 24/03/2015 a las 2:46, Jean MAURICE escribió:
Rafael,
I didn't understand what "showing the position as a page" is, but if you create an index and you SEEK the company, you can BROWSE the result and you will see a 'page' !

Note : there are the command SEEK and a function SEEK(); I prefer the second one perhaps in the BROWSE, the 'right record' wil be displayed not in the middle of the browse window, you can then put some SKIP -5, SKIP 5 to àcure this issue.

HTH
The Foxil


[excessive quoting removed by server]

_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to