Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid Headings when SQL - Select into Cursor 'refreshes'
Message
 
 
To
01/05/2000 23:39:37
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00364968
Message ID:
00365456
Views:
20
Norm,

You should look at using a parameterized view instead of a plain cursor. To update it you just Requery( "TheView" ) and this does not cause the grid to self destruct and rebuild itself like your SELECT is forcing.

>

I am using a SQL - Select into a cursor which is used as the datasource for my grid. I use the following line after the select and it updates fine the first time through.
>

THISFORM.ComboBox1.RowSource = THISFORM.ComboBox1.RowSource
>

However, when the select is executed the second, or third, or.... time the headings and colum widths are reset to match the cursor. How do I maintain my original settings?

df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform