I have a Browse with one drop down list. For one of the selections in the list I use one sort order (call it sort 1), for all the rest I use another (call it sort 2). Both sort orders match keys in the table perfectly.
Sort 2 works fine. Sort 1 displays the last n records (where n is the number of rows in the Browse). The Previous and First buttons are active, the Next and Last are not. When I click either the First or Previous button the screen clears and returns to the drop down list. Her are the prop:order and prop:filter statements:
ThisView{prop:order} = +UPPER(ITM:ProductCode),+UPPER(ITM:FinishSortField),+UPPER(ITM:GradeSequence),+ITM:SizeSortSequence,+ITM:ImasterID'
ThisView{prop:filter} = 'UPPER(ITM:ProductCode) => <39>F<39> AND UPPER(ITM:ProductCode) <= <39>Fz<39>'
I'm puzzled?? Any ideas?
Thank you,
Rich Bowman