>Sir this Download for sorting in Grid. I need for form. Please tell me if some thing for Forms.
>
>Thank you,
Usually, if the user sees several records at a time, it will be in a grid. This is usually the most complicated part (expected behavior, in the simplest case: if the user clicks, or double-clicks, on a grid column, sort by that column).
If the user doesn't see any records, it is really much simpler. Let's suppoes you need the user to select between sorting on Field1, Field2, or Field3. One way to do this is to have one index on each of these fields:
index on Field1 tag Field1
index on Field2 tag Field2
index on Field3 tag Field3
This, you will need to do only once - not every time you start your form.
Now, you just have to put an OptionGroup with the three options. Either in the Click() Event of each option, or in the Click() Event (or InteractiveChange()) of the OptionGroup (with DO CASE in the OptionGroup), you can change the order:
do case
case This.Value = 1
set order to "Field1"
case This.Value = 2
set order to "Field2"
case This.Value = 3
set order to "Field3"
endcase
Is this what you need?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)