Hi all, Someone please correct me on this if I am wrong - A Party is a person or a group. - A Party group is a logical grouping of Party's ? - A Party/Group can have roles defined as PartyRoles ?
So in my case a single person is a Party and a Patient can be represented as a Party group ? so where does party role fit into the mix? Thnx Regards Edward -----Original Message----- From: BJ Freeman [mailto:[EMAIL PROTECTED] Sent: Monday, December 17, 2007 5:56 PM To: [email protected] Subject: Re: Deleting a table I have not seen much code using the party role, though that is a good way. Adrian Crum sent the following on 12/17/2007 8:23 AM: > Maybe a Patient party role would be more appropriate. > > > BJ Freeman wrote: > >> like any relational database, if you have tables that are realated and >> they have data in them then that data may be lost. >> >> as a side note: look at using a party as person and create a Patient >> Party group. saves doing redundant work >> >> >> Edward Banfa sent the following on 12/17/2007 3:50 AM: >> >>> Hi Jacques, >>> >>> Ummm, what are the implications of deleting a table in ofbiz apart >>> from loss >>> of data contained in that table? Coz I just deleted a table using the >>> SQL >>> processor (am actually just learning Ofbiz, am not yet working on a >>> building >>> a production app). I had previously defined an entity called Patient and >>> after a I deleted the table and I restarted ofbiz, I cant see my >>> entity in >>> the Entity Data Maintenance page of webtools. Issuing the following >>> SQL "SELECT * FROM PATIENT" from the SQL processor page throws an >>> exception, the >>> trace in console.log says: ERROR 42X05: Table/View 'PATIENT' does not >>> exist. >>> >>> Am I missing something here? >>> >>> All help appreciated, thx >>> >>> Regards >>> >>> Edward >>> >>> Below are my entitymodel.xml and entitygroup.xml files repectively >>> >>> -------------------------------------------------------- >>> >>> <?xml version="1.0" encoding="UTF-8"?> >>> <entitymodel xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; >>> >>> xsi:noNamespaceSchemaLocation="http://www.ofbiz.org/dtds/entitymodel.xsd";> >>> >>> <!-- ========================================================= --> >>> <!-- ======================== Defaults ======================= --> >>> <!-- ========================================================= --> >>> <title>Entities for a Hello world component</title> >>> <description>None</description> >>> <copyright>Copyright (c) Hello World, Inc.</copyright> >>> <author>Edward Banfa</author> >>> <version>0.1</version> >>> >>> <entity entity-name="Patient" package-name="org.helloworld.emedic" >>> title="Entity to represent mentally sick people in government"> >>> <field name="patientId" type="id-ne"/> >>> <field name="firstName" type="id"/> >>> <field name="lastName" type="id"/> >>> <field name="appointment" type="id"/> >>> <prim-key field="patientId"/> </entity> >>> </entitymodel> >>> ------------------------------------------------------------------------- >>> >>> >>> ------------------------------------------------------------------------- >>> >>> >>> <?xml version="1.0" encoding="UTF-8"?> >>> >>> <entitygroup xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; >>> >>> xsi:noNamespaceSchemaLocation="http://www.ofbiz.org/dtds/entitygroup.xsd";> >>> >>> >>> >>> <entity-group group="org.ofbiz" entity="Patient"/> >>> >>> </entitygroup> >>> >>> -------------------------------------------------------------------------- >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> -----Original Message----- >>> From: Jacques Le Roux [mailto:[EMAIL PROTECTED] Sent: >>> Monday, December 17, 2007 11:56 AM >>> To: [email protected] >>> Subject: Re: Deleting a table >>> >>> http://docs.ofbiz.org/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo >>> >>> >>> Look for Derby, not sure there is exactly an answer but you should >>> find your >>> way from there. Beware that it's not recommended to >>> delete tables in OFBiz... >>> >>> Jacques >>> >>> De : "Edward Banfa" <[EMAIL PROTECTED]> >>> >>>> Hi all. >>>> >>>> >>>> >>>> I would like to know how to delete a table in the Derby database that >>> >>> comes >>> >>>> with Ofbiz. >>>> >>>> >>>> >>>> Actually I have a problem with a an entity that I created, I want to >>>> alter >>>> the columns on the entity and hence in the underlying table that >>> >>> represents >>> >>>> the data for the entity. Do I have to drop the existing table or is >>>> there >>> >>> a >>> >>>> way I can have ofbiz pickup any changes in the >>>> >>>> entity definition and update the db schema ? >>>> >>>> >>>> >>>> Thank u for ur help in advance >>>> >>>> >>>> >>>> Regards >>>> >>>> >>>> >>>> Edward >>>> >>>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >> >> > > > >
