making selection in BROWSE window

[Ashr]

I m using the command browse.......... , I would like to give the user the option to select from which record to display , for example if the is a name FIELD in the browse & the file is sorted by this name , the BROWSE window is open from A to Z , the user would like to see from the latter F , how can I make this in a BROWSE window.

Thank's

 

[Stella740pl]

You can make a form with all the selections available to make, and after the user is done with them and presses the button, you set the order, filters, etc, to your table and display your BROWSE. You would probably have to analyze yourself what order and other conditions are currently set to your table, I don't think you can do it all within standadrd BROWSE.

You can also use BROWSE's built in filter/scope (FOR) and other clauses. There are plenty of them, look up your Help. You can FREEZE all fields but one to allow changes only to that one, to prohibit any changes alltogether, and many other things.

For example,

SET ORDER TO field1
BROWSE FILEDS id, field1, field2 FOR UPPER(LEFT(field1,1))>="F"

 

[TheRambler]

Hi,

If you are looking for an incremental search routine, you might want to download brow_x.zip, jkey26.zip or suprseek.zip from Neil's FoxFiles. I can't recommend any of them because I didn't try them. Good luck.

 

[Vishnia]

The best way is using filter - SET FILTER TO <expr>
before BROWSE command,
and after BROWSE command - SET FILTER TO to remove the filter.