Hi David,
I have not worked much with views, I've been using 2.6 for way to long and am now trying to keep my head above water in the Oop world! I will look into it, thanks for the pointer.
>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?
____________________________________________
Norm Peterson
It's a dog eat dog world out there,
and I'm wear'n milk bone underware!