Hi,
if u have a foreign key ( referential integrity ) bet. 2 tables u have to
drop the foreign key or else u will get referential error coz. u have to
delete the detail records ( detail table ) before the master records
master table ) unlike in sql anywhere there is an option in foreign key
dialog box if u want a cascaded delete, delete constraint in parent
table....
it's either delete first the detail records or drop the foreign key and
create a trigger on the master table to perform a cascaded delete.
Is there any open position in your company ?
John D. Cruz
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
[EMAIL PROTECTED]
Sent: Monday, June 26, 2000 10:40 AM
To: [EMAIL PROTECTED]
Subject: PFCSIG Referential Error in Linkage Environment
Hi All,
Does anyone of you knows a workaround in deleting data from two tables with
referential (Primary Key and Foreign Key) working in a linkage environment
? Because everytime I tried to delete a row a Referential Error appeared.
Thanks,
Denz
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS,
ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
