Openbase, EOF and Miss-aligend primary keys
Openbase, EOF and Miss-aligend primary keys
- Subject: Openbase, EOF and Miss-aligend primary keys
- From: Owen McKerrow <email@hidden>
- Date: Tue, 8 Mar 2005 16:06:59 +1100
(sorry to those who are on the Openbase Dev list and receive this as a
double posting ).
Hi List,
Im having an issue of miss aligned Primary keys.
That is I have table Member (_row id is the primary key), table Member
name ( one to many from Member ) and Address (one to one from member
where EOModler is propagating the primary key from Member) .
I create a new Member, Address and Member Name. I set the relationships
between each of them and fill in the details. When I save however
something strange happens, all the data is saved but the memberID that
is used in Address and Member name is wrong.
eg. Member : _rowID = 2
Address : memberID = 3
Member Name : memberId = 3
So all my Members have even primary keys ( 2,4,6,8) and all the other
tables apparently reference the Member who's ID is 1 higher than it
really is, so there all odd (3,5,7,9).
Which means when I pull the info back my members don't have an address
or a name as the primary keys don't match.
WO 5.2.3
OpenBase 8.0.4 (bld 20 )
Any ideas about that one ?
Owen McKerrow
WebMaster, emlab
http://emlab.uow.edu.au
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - -
"As of tomorrow, employees will only be able to access the building
using individual security cards. Pictures will be taken next Wednesday
employees will receive their cards in two weeks."
- "Dilbert Quotes" Winner, Fred Dales, Microsoft Corp
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden