Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Add Feature in forms for sorting.
Message
De
11/05/2003 21:24:28
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
11/05/2003 21:06:34
Javed Yusuf
Analytic Systems
Lahore, Pakistan
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00786907
Message ID:
00787183
Vues:
11
>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:
* OptionGroup.Click()
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)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform