Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Referential integrity and grid in VFP 8
Message
From
04/03/2004 14:37:59
Jose Cosme Pita
Cubanacan Viajes
Havana, Cuba
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Referential integrity and grid in VFP 8
Miscellaneous
Thread ID:
00883216
Message ID:
00883216
Views:
42
Hello.

I have two tables involved in a referential integrity relationship:

Parent: REGOPC
Child: NOMIDI
Parent TAG: CODIDI
Child TAG: CODIDI

Rules:

UPDATE: CASCADE
DELETE: RESTRICT
INSERT: IGNORE

This relation is based in the field CODIDI (Tags CODIDI in both tables).

In a grid, I have as RECORDSOURCE the table REGOPC, and in one column of the grid, I have this expression:

"Iif (Seek(codidi,"NOMIDI","NOMIDI"),NOMIDI.nomidi,Space(20))"

Where:

codidi - Field of the table REGOPC corresponding
to the TAG CODIDI in both tables.

This expression recover the field description from the table NOMIDI.

When I navigate in the grid with right or left arrow, and hit the column corresponding to the expression above mentioned, the grid is positioned in the first row. If I try to move down with down arrow standing in this column, impossible, it stays there. I move to another column with left/right arrow, and after that, I can move up and down.

The problem is in the mentioned column.

Can anyone help me ?

Thanks in advance.

Pita.
Reply
Map
View

Click here to load this message in the networking platform