Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Requerying a grid control
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01074269
Message ID:
01077926
Views:
31
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform