Re: Database won't accept null foreign key
Re: Database won't accept null foreign key
- Subject: Re: Database won't accept null foreign key
- From: Bob Stuart <email@hidden>
- Date: Mon, 6 Oct 2003 20:49:42 -0400
Albert,
Another somewhat twisted approach is to create a row whose
primary key is Zero and instead of setting the relationship to null
set it to this dummy record. That will get WO to push Zero into the
DB. After that you might do something to detect the relationship is
pointing to the Zero record and do special processing for it.
If you don't do this you will either have to check for the
foriegn key being Zero and not traverse the relationship or you will
have EOF creating dummy records with the zero key after a failed DB
hit.
At 3:38 PM -0500 10/6/03, Albert Jagnow wrote:
I am working with a database that for whatever reason won't allow a
foreign key to be null if the relationship does not exist. I am unable
to make any changes to the database setup. In this database table A may
have an optional one-one relationship with table B. If there is not
relationship or I delete a relationship, WO wants to set the foreign key
in table A for table B to null. The database won't allow the foreign
key column of table A to be null it wants it to be 0. Is there an easy
trick to get WO to generate 0 instead of null for that key if the
relationship does not exist?
--Albert
This e-mail (including any attachments) is covered by the Electronic
Communications Privacy Act, 18 USC. 2510-2521. It is confidential and
may be legally privileged. If you are not the intended recipient, you
are hereby notified that any retention, dissemination, distribution, or
copying of this communication is strictly prohibited. Please reply to
the sender that you have received the message in error, and then delete
it. Thank you.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
--
Bob Stuart
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.