I don't see a column name for your id attribute in the plist file. Perhaps that is throwing EOF off.
F On 2013-Mar-03, at 08:49 PM, David Avendasora <[email protected]> wrote: > Hey all, > > I have one entity (out of about 40) that refuses to insert data into my > FrontBase database. It generates the SQL but is leaving out the PK. > > Here's the SQL: > > INSERT INTO "KC_TYPE_MASTER"("DISPLAY_NAME_OVERRIDE", > "TYPE_KC_TYPE_ELEMENT_ID", "KC_TYPE_ENTITY_PROPERTY_ID") VALUES (NULL, > 1000000, 4) > > The PK column (ID) is simply missing from the statement. For all other > tables, the PK is just one of the values being inserted and everything works > just fine. > > I'm not even seeing the normal SQL call to get the PK value from the DB > (i.e., VALUES (SELECT UNIQUE FROM "KC_TYPE_MASTER")) > > So something is going wrong with EOF prior to generating the SQL for the > insert, but what? > > The Entity has a non-class, single-attribute PK. It is not part of an > inheritance structure, it's just a (very) simple table. > > Below is the .plist from the .eomodeld for this entity. > > Any ideas? > > Dave > > > { > attributes = ( > { > allowsNull = Y; > columnName = "DISPLAY_NAME_OVERRIDE"; > name = displayNameOverride; > prototypeName = varchar100; > }, > {allowsNull = N; name = id; prototypeName = id; }, > { > allowsNull = N; > columnName = "KC_TYPE_ENTITY_PROPERTY_ID"; > name = kcTypeEntityPropertyId; > prototypeName = id; > }, > { > allowsNull = N; > columnName = "TYPE_KC_TYPE_ELEMENT_ID"; > name = typeKCTypeElementID; > prototypeName = id; > } > ); > attributesUsedForLocking = (displayNameOverride, id, > kcTypeEntityPropertyId, typeKCTypeElementID); > className = "com.kaiten.core.eo.type.KCTypeMaster"; > classProperties = (displayNameOverride, typeEntityProperty, types, > typeTypeElement); > externalName = "KC_TYPE_MASTER"; > fetchSpecificationDictionary = {}; > name = KCTypeMaster; > primaryKeyAttributes = (id); > relationships = ( > { > destination = KCTypeEntityProperty; > isMandatory = Y; > isToMany = N; > joinSemantic = EOInnerJoin; > joins = ({destinationAttribute = id; sourceAttribute = > kcTypeEntityPropertyId; }); > name = typeEntityProperty; > userInfo = {fetchFor = {Many = ""; }; qualifier = ""; }; > }, > { > destination = KCType; > isToMany = Y; > joinSemantic = EOInnerJoin; > joins = ({destinationAttribute = kcTypeMasterID; sourceAttribute > = id; }); > name = types; > }, > { > destination = KCTypeElement; > isMandatory = Y; > isToMany = N; > joinSemantic = EOInnerJoin; > joins = ({destinationAttribute = id; sourceAttribute = > typeKCTypeElementID; }); > name = typeTypeElement; > userInfo = {fetchFor = {Many = ""; }; qualifier = ""; }; > } > ); > } > > > ————————————————————————————— > WebObjects - so easy that even Dave Avendasora can do it!™ > ————————————————————————————— > David Avendasora > Senior Software Abuser > Kaiten, Inc. > > > > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/listfez%40dakri.com > > This email sent to [email protected]
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
