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:37:23
 
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00364968
Message ID:
00364974
Views:
35
>>>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"

That works! Thanks!
____________________________________________

Norm Peterson

It's a dog eat dog world out there,
and I'm wear'n milk bone underware!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform