RE: Dods: Cascade delete problem

This is a multi-part message in MIME format.

------=_NextPart_000_00CB_01C3C480.034B9990
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi !

Just set the foreign key to null prior to deletion...

But this only works if you use "AutoSave"=true and "AutoWrite"=true in the
conf.

Alfred

-----Original Message-----
From: Wavyx [mailto:[email protected]]
Sent: Mittwoch, 17. Dezember 2003 01:13
To: [email protected]
Subject: Dods: Cascade delete problem

Hi,

I read some old post but I still cannot get out my problem:
I have 2 tables:
Table A:   IDA,  IDB, field1, field2,...
Table B:   IDB,  IDA, field1, field2,...

and i use referenceobject:  TableA. IDB --> TableB.IDB   and  TableA.IDB
--> TableB. IDA

If I try to delete a row from table B for example, DODS delete also the
table A rows that have references to the old IDB.
How can I disable this behavior?

I looked in the dods conf property doc but I can't find a solution.

Any idea or help?

Thanks

Eric



_______________________________________________
Dods mailing list
[email protected]
http://www.enhydra.org/mailman/listinfo.cgi/dods

------=_NextPart_000_00CB_01C3C480.034B9990
Content-Type: application/x-pkcs7-signature;
	name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
	filename="smime.p7s"

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIII2jCCAmIw
ggHLoAMCAQICAwsPZTANBgkqhkiG9w0BAQQFADBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhh
d3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVt
YWlsIElzc3VpbmcgQ0EwHhcNMDMxMTAyMTcyODQyWhcNMDQxMTAxMTcyODQyWjBZMQ0wCwYDVQQE
EwRNYWRsMQ8wDQYDVQQqEwZBbGZyZWQxFDASBgNVBAMTC0FsZnJlZCBNYWRsMSEwHwYJKoZIhvcN
AQkBFhJBLk1hZGxAdG9nZXRoZXIuYXQwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAMSUz0lI
gbjM8T5YPR5N2zkqHZCEQnP6hHG2LfUAVkssM+ArKJWrxPrfpNJrggv1SWBII3qeHOaZZbHeHLTc
Ji3xxEduLuM9dUcxEOgYc+4Q3mw4O2IVJN343rHuzEtFktOJWMpoSZihy8OHhsaukhOMFGDo/2Lp
D0nLRQS5v4OlAgMBAAGjLzAtMB0GA1UdEQQWMBSBEkEuTWFkbEB0b2dldGhlci5hdDAMBgNVHRMB
Af8EAjAAMA0GCSqGSIb3DQEBBAUAA4GBAKnq3350qe6y9F+qnEhU8wwmW7sFvYgbVJubU/lrdm/D
0SsUci6e7b3aOr0T60Ubl9J4BPAmfy0pBBBKfrKHvHzuUJCiNItLXe2xf3sFCakK9qUmH8897o9Q
fseb+Gll7EOkWyh6cvq5+7J9q9dwLOQ5omDQXicZvXTSmsORjUdiMIIDLTCCApagAwIBAgIBADAN
BgkqhkiG9w0BAQQFADCB0TELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTESMBAG
A1UEBxMJQ2FwZSBUb3duMRowGAYDVQQKExFUaGF3dGUgQ29uc3VsdGluZzEoMCYGA1UECxMfQ2Vy
dGlmaWNhdGlvbiBTZXJ2aWNlcyBEaXZpc2lvbjEkMCIGA1UEAxMbVGhhd3RlIFBlcnNvbmFsIEZy
ZWVtYWlsIENBMSswKQYJKoZIhvcNAQkBFhxwZXJzb25hbC1mcmVlbWFpbEB0aGF3dGUuY29tMB4X
DTk2MDEwMTAwMDAwMFoXDTIwMTIzMTIzNTk1OVowgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxX
ZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRp
bmcxKDAmBgNVBAsTH0NlcnRpZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1Ro
YXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1h
aWxAdGhhd3RlLmNvbTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEA1GnX1LCUZFtx6UfYDFG2
6nKRsIRefS0Nj3sS34UldSh0OkIsYyeflXtL734Zhx2G6qPduc6WZBrCFG5ErHzmj+hND3EfQDim
AKOHePb5lIZererAXnbr2RSjXW56fAylS1V/Bhkpf56aJtVquzgkCGqYx7Hao5iR/Xnb5VrEHLkC
AwEAAaMTMBEwDwYDVR0TAQH/BAUwAwEB/zANBgkqhkiG9w0BAQQFAAOBgQDH7JJ+Tvj1lqVnYiqk
8E0RYNBvjWBYYawmu1I1XAjPMPuoSpaKH2JCI4wXD/S6ZJwXrEcp352YXtJsYHFcoqzceePnbgBH
H7UNKOgCneSa/RP0ptl8sfjcXyMmCZGAc9AUG95DqYMl8uacLxXK/qarigd1iwzdUYRr5PjRznei
gTCCAz8wggKooAMCAQICAQ0wDQYJKoZIhvcNAQEFBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQI
EwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1
bHRpbmcxKDAmBgNVBAsTH0NlcnRpZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMT
G1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJl
ZW1haWxAdGhhd3RlLmNvbTAeFw0wMzA3MTcwMDAwMDBaFw0xMzA3MTYyMzU5NTlaMGIxCzAJBgNV
BAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNU
aGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQTCBnzANBgkqhkiG9w0BAQEFAAOBjQAw
gYkCgYEAxKY8VXNV+065yplaHmjAdQRwnd/p/6Me7L3N9VvyGna9fww6YfK/Uc4B1OVQCjDXAmNa
LIkVcI7dyfArhVqqP3FWy688Cwfn8R+RNiQqE88r1fOCdz0Dviv+uxg+B79AgAJk16emu59l0cUq
VIUPSAR/p7bRPGEEQB5kGXJgt/sCAwEAAaOBlDCBkTASBgNVHRMBAf8ECDAGAQH/AgEAMEMGA1Ud
HwQ8MDowOKA2oDSGMmh0dHA6Ly9jcmwudGhhd3RlLmNvbS9UaGF3dGVQZXJzb25hbEZyZWVtYWls
Q0EuY3JsMAsGA1UdDwQEAwIBBjApBgNVHREEIjAgpB4wHDEaMBgGA1UEAxMRUHJpdmF0ZUxhYmVs
Mi0xMzgwDQYJKoZIhvcNAQEFBQADgYEASIzRUIPqCy7MDaNmrGcPf6+svsIXoUOWlJ1/TCG4+DYf
qi2fNi/A9BxQIJNwPP2t4WFiw9k6GX6EsZkbAMUaC4J0niVQlGLH2ydxVyWN3amcOY6MIE9lX5Xa
9/eH1sYITq726jTlEBpbNU1341YheILcIRk13iSx0x1G/11fZU8xggMcMIIDGAIBATBpMGIxCzAJ
BgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQD
EyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQQIDCw9lMAkGBSsOAwIaBQCgggIJ
MBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTAzMTIxNzA4MjczOFow
IwYJKoZIhvcNAQkEMRYEFLXtJP1nRcyLZqaPytvGtK6mOQ8DMEsGCyqGSIb3DQEJEAIBMTwwOgQd
AAAAABAAAABl0O1KfMEdQqwLcgoO8M66AQAAAACAAQAwFjAUgRJBLk1hZGxAdG9nZXRoZXIuYXQw
ZwYJKoZIhvcNAQkPMVowWDAKBggqhkiG9w0DBzAHBgUrDgMCGjAOBggqhkiG9w0DAgICAIAwDQYI
KoZIhvcNAwICAUAwBwYFKw4DAgcwDQYIKoZIhvcNAwICASgwCgYIKoZIhvcNAgUweAYJKwYBBAGC
NxAEMWswaTBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkg
THRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECAwsPZTB6
BgsqhkiG9w0BCRACCzFroGkwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0
aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5n
IENBAgMLD2UwDQYJKoZIhvcNAQEBBQAEgYA70Rpg0Srzv1MV5qFTgpIGi36m/ZpHIsNr8hyVP3Ky
14Xcp82k4Q1ic2vmINRsO2C8KsmMRPD5E2yMHgAahZ/0Mbt7u1DRriLx2F1BCX6iPriwFcMsBGKv
RXpnxOFpAZYEYFf5Gio40gS6QKgz8dYRdhA/ynCh44kyQy2lD0QxVgAAAAAAAA==

------=_NextPart_000_00CB_01C3C480.034B9990--