Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Populating a grid
Message
 
À
20/12/1999 15:14:21
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00306374
Message ID:
00306577
Vues:
22
* For faster than filter, add a tag (index) to your file
use MyVehicleDBF
index on vehicle_nu + substr(dtoc(entry_date),7,4) tag vehicle_entdate
* Then seek to set top of stack?
seek(thisform.mycombobox1.value+thisform.mytextbox1.value,[MyVehicleDBF],[vehicle_entdat])
* Then set filter (Rushmore is now on your filter's side)
set filter to vehicle_nu=thisform.mycombobox1.value and ;
substr(dtoc(entry_date),7,4) = thisform.mytextbox1.value and ;
substr(dtoc(entry_date),1,2) <= thisform.mytextbox2.value
* No go top needed

>If someone else on the network is entering a record at the same time,
>that record also appears in the pageframe one grid, although it does
>not meet the filtered criteria (vehicle_nu).
Use AGAIN, and create a seperate alias for the filter grid. Since the
APPENDS will be to the original alias, they shouldn't show in your grid (i think!)

Others in this thread have suggested pulling the needed records into a cursor. That might be a good idea. But using VFPs very fast indexing to set the first record in the stack will really speed it up.

Terry
Imagination is more important than knowledge
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform