>Hi all,
>
>I have a grid control in which I have a column having the current
>control as a combo box. The coulmn has the ControlSource :alias1.desc and the current combo box has the ControlSource:alias2.code.
>I populate the rowsource of the combo box using RowSourceType:SQL, by SELECTing desc,code from alias1. Bound column of the combo box is 2.
>
>The above code works perfectly well locally with the moderate size of tables. However the grid dos not seem to work well losing the display of the desc in the column when i tries to add a record to alias2.
>This happens when i run the program against huge files over the network.
>
>Any idea? I hope I am make the question clear. If not, let me know.
>Thanks.
>
>Kam.
Hi, Kam. To handle Grid in changing Recordsource, download bwtable in File Section!
oGrd.ColumnCount = -1 && Remove all column controls
oGrd.Recordsource = "NextAlias"
oGrd.INIT
When you re-assign the Grd recordsource, all columns are removed and re-added.
If you have put coding on those header, textbox, columns,
you lose all coding of them.
What you need to maintain is to remove the non-needed control and replace with a defined class, bwtable has show how it solve the Grid IME problem in Execute!
Grid IME problem is a known bug of VFP 5.0a, you need download SP3 to solve it
or Upgrade to VFP 6.0!
But you need to take care another bug C000005 on VFP 6, anyway, VFP 6 sure need SP3 to fix this bug again!
Pay more attention here and you will know more known bugs! ~_~
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.