Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid column losing display when RecordSource is huge
Message
From
24/08/1999 00:22:40
 
 
To
23/08/1999 16:39:00
Kam Lee
SUNY-Health Science Center
Brooklyn, New York, United States
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00256790
Message ID:
00256925
Views:
23
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform