Local variables in browse

[olu]

Please am stuck on trying to use a local variable as a default sort and also do a search on it with the locators. When i click on the header to sort on it noting happens and when i try and do a search nothing happens

[kevin plummer]

All this stuff is driven from the View.

What is your loc variable based on? You can sometimes link it to a field in the view to make it work just depends what the loc variable is based on.

[Bruce]

Hi Olu,

You can't sort on a calculated field, because the sort order is determined by the sort of the View. If you want to sort on a calculated column, according to some sort order in an original field, then set the sort order (to actual table fields) on the SORT tab for the browse column.

Much the same with the locator. You can only locate on what is in the database, because it's the database that does the searching. You can specify Locate fields as well on the columns SORT tab.

Cheers
Bruce