grid problem

[engan]

hi, i have a problem with my grid, I try to populate my grid with select statement then I put another select statement in interactivechange of combobox to refresh the new data with different filter. What I got is my grid definition seems to be changed by visual foxpro ie. my column width is reset, my hilite row is reset as well.

on init event
SELECT col1,col2 from table1 into cursor mygrid.name
mygrid.recordsource = ALIAS()

on interactivechange
SELECT col1,col2 from table1 where col1.code = "AA" into cursor mygrid.name
mygrid.recordsource = ALIAS()
mygrid.refresh

the first select is ok, the second select resets my grid definition.

any ideas ?

 

[TomasDill]

Hi!

It is known as Grid Reconstruction Behaviour. There is also Automatic re-binding of column contol sources that seems you did not met yet because columns match the phisical structure of the result cursor. Take a look to the FAQ article about Grid reconstruction at the

http://www.universalthread.com.

I re-post it here too, so check it here.

Vlad Grynchyshyn
vgryn@softserve.lviv.ua

http://www.softservecom.com

The professional level of programmer could be determined by level of stupidity of his/her bugs

 

[chpicker]

Here's how I would do it:

on init event
SELECT col1,col2 from table1 into cursor mygrid.name
mygrid.recordsource = ALIAS()

on interactivechange 
[b]mygrid.recordsource=''[/b]
SELECT col1,col2 from table1 where col1.code = "AA" into cursor mygrid.name
mygrid.recordsource = ALIAS()
mygrid.refresh

 

[chpicker]

Heh...my guess about how to boldface a segment was wrong. The

[b]

and

[/b]

tags should be ignored, as I thought they were supposed to put that line in BOLDFACE. Unfortunately, it looks like the tags don't nest. (

 

[engan]

My grid works fine now, Thanks for your tips chpicker & Tomasdill.