Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with GRID and SET RELATIONs
Message
From
03/06/1998 11:38:57
 
 
To
03/06/1998 11:25:35
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00104393
Message ID:
00104397
Views:
22
>I have found a strange problem with GRIDs and SET RELATIONs.
>
>Suppose I have a table with fields KEY_A and KEY_B, which are foreign keys in TABLE_A and TABLE_B respectively. I want to set up a grid showing KEY_A, TABLE_A.NAME_A, KEY_B, TABLE_B.NAME_B, and be able to add new records with a command button.
>
>I set all this up in the data environment of the screen, but when I add records, I get strange behaviors: either a RECORD OUT OF RANGE error message shows up, or wrong NAME_A o NAME_B values appear.
>
>If I set up a grid with only ONE relation, the grid works fine, but when I try to work with two or more related tables, I cannot get it to work.
>
>Does someone know what this is all about? Is there a patch, a fix or a workaround for the problem?
>
>Thanks!

The generic rule is following: it's very easy to build simple temp relartionship and use it for grid, but the more complicated your interface will become the more troubles you will get. You definitely should remove temp relationships and use parameterized views or read/write cursor as grid recordsource.
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform