Have you confirmed that the SQL is being performed in the appropriate
order (i.e., child records are being deleted before parent ones)?
Something I've found useful to confirm this situation is to enable the
SQLSpy service. Our project has a menu item that contains this code:
// Activate or deactivate the SQL Spy.
// Note that this activates the debug service and never turns it off.
// If you use the debug service disabled, don't choose this menu item.
if (not IsValid(gnv_app.inv_debug)) then
gnv_app.of_SetDebug(TRUE)
end if
if (IsValid(gnv_app.inv_debug.inv_SQLSpy)) then
if (gnv_app.inv_debug.inv_SQLSpy.of_IsOpen()) then
gnv_app.inv_debug.inv_SQLSpy.of_OpenSQLSpy(FALSE)
gnv_app.inv_debug.of_SetSQLSpy(FALSE)
return
end if
end if
gnv_app.inv_debug.of_SetSQLSpy(TRUE)
gnv_app.inv_debug.inv_SQLSpy.of_OpenSQLSpy(TRUE)
--dang
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Sunday, June 25, 2000 22:40
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]
