Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
While a process is runing
Message
 
 
To
21/09/2001 09:44:37
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00555646
Message ID:
00559227
Views:
43
>I make the changes on my codes.
>This work OK.
>However; the root of the problem is not the query update.
>The problem is that my query has six fields and I just show the user four fields.
>When I carry out it again the query; the grid properties are lost, example, the columns width, all the fields appear, the font type, and everything the others.
>In fact, How I could make the query update without losing the grid properties?

To prevent "reconstruction" of the grid set RecordSource of the grid to the empty string "" before query and set back after it
Thisfor.mygrid.RecordSource = ""
... your query here
Thisfor.mygrid.RecordSource = < mycursor >

Take also look at faq#8019 for another approch. You can also change RecordSourceType to 3 - Query or 4 SQL and call grid Refresh() when timer fires.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform