Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid Headings when SQL - Select into Cursor 'refreshes'
Message
From
02/05/2000 00:10:44
 
 
To
02/05/2000 00:02:41
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00364968
Message ID:
00364971
Views:
30
>>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?
>
>Well, I don't know if there is a better way, but I manually set the WIDTH and HEADER for each column in the grid. It works for now!

Have you tried setting the RecordSource to an empty string ("") before you reset the cursor.

thisform.oGrid.RecordSource = ""
*re query you cursor
thisform.oGrid.RecordSource = "cursoralias"
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform