I ran a check, and it removed the dependency from webtools entity reference, eg. searching for ORDER_HDR_OFAC gives no results, but when I try to update an OrderHeader it still breaks saying INSERT on table 'ORDER_HEADER' caused a violation of foreign key constraint 'ORDER_HDR_OFAC' for key (10061) Do you have any suggestions ?
On Mon, Apr 12, 2010 at 8:03 AM, Jacques Le Roux <[email protected]> wrote: > Look for "Check/Update Database" in Webtools > > Jacques > > From: "Patrick" <[email protected]> >> >> When I place an order I want to remove the facility dependency, so I >> commented out the following: and did a restart, but when I place an >> order it still requires the dependency so I guess it didn't update. >> Is there a special command to verify and update the DB from a modified >> entitymodel.xml file ? Thanks >> >> <entity entity-name="OrderHeader" >> package-name="org.ofbiz.order.order" >> never-cache="true" >> title="Order Header Entity"> >> >> <!-- commented this out >> <relation type="one" fk-name="ORDER_HDR_OFAC" title="Origin" >> rel-entity-name="FacilityAndContactMechAndAddress1"> >> <key-map field-name="originFacilityId" rel-field-name="facilityId"/> >> </relation> >> --> >> > >
