Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Requerying a grid control
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01074269
Message ID:
01077926
Vues:
29
Unless you're resetting your Column properties every time you'll have different column widths every time you requery. Check out this http://fox.wikis.com/wc.dll?Wiki~GridSafeSelect~VFP. You create a readwrite cursor for your grid, run your query into a different cursor, then zap your grid cursor and append the results of your query. This way you don't lose your column settings. More info on why this occurs from http://weblogs.foxite.com/andykramek/archive/2005/03/19/174.aspx Andy Kramek's blog.

Regards,

E.R. Gilmore

>Many thanks, ended up with:-
>
>
>thisform.paGEFRAME1.page3.grdProductTrans.RecordSource=""
>SELECT * from producttrans INTO CURSOR producttranstmp
>thisform.paGEFRAME1.page3.grdProductTrans.RecordSource=" select * from producttrans INTO CURSOR producttranstmp where bookinno=productfile.partno"
>
>
>Cheers
>Robin
Regards,

E.R. Gilmore
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform