Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data integrity violation
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00607028
Message ID:
00607703
Views:
30
Hi,

...
CREATE TABLE KIT_PROJET (
PRO_NUMERO CHAR(7) PRIMARY KEY,
PRO_DESCRIPTION CHAR(40) ,
PRO_INS_CODE CHAR(4)
) ;

COMMIT;

CREATE TABLE KIT_COMMANDE_PROJET (
COP_OTP CHAR(5) NOT NULL,
COP_CEN_CODE NUMBER(10),
COP_UNI_CODE NUMBER(8) ,
COP_PRO_NUMERO CHAR(7) ,
COP_COM_CODE_P CHAR(16) ,
CONSTRAINT COP_PRIMARY_KEY PRIMARY KEY (COP_PRO_NUMERO,COP_COM_CODE_P),
CONSTRAINT COP_FOREIGN_KEY1 FOREIGN KEY (COP_PRO_NUMERO) REFERENCES KIT_PROJET (PRO_NUMERO)
) ;

COMMIT;
...

This is a part of my script. If I trigged a combo, I can modify KIT_PROJET.PRO_NUMERO even I shouldn't.

???
Thanks
Le travail est un moyen, pas une fin.

Louis Hudon
Hydro-Québec
Informatique en Équipement
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform