No, not really. Sounds that you need the debugger to see what'S going on in the linkTag. I you can build an example based on bookstore which has the same error i can have a look.
Cheers, Henner > -----Ursprüngliche Nachricht----- > Von: Matella, Gunter [mailto:[EMAIL PROTECTED] > Gesendet: Montag, 24. Mai 2004 15:27 > An: Henner Kollmann > Cc: [EMAIL PROTECTED] > Betreff: [dangerous]: AW: [dbforms] Foreign key handling in > dbforms_2.3_20040329 > > > Thank you for the feedback! > > 1: Hope, that the _ in our table names will not lead to any > real problem. It is not realy easy to change all existing > tablenames ;-) > > 2: > I did it all. Here my definition in db-config.xml: > > Part of Parent table: > --- > <table name="CA_REPORTINFO" > defaultVisibleFields="OBJID" > > <field name="OBJID" fieldType="number" > size="22" isKey="true"/> > <field name="TITLE" fieldType="varchar2" size="250"/> > ... > <field name="BAGINFOOBJID" isForeignKey="true" > fieldType="number" size="10" isKey="true"> > <foreign-key name="CA_RI_RBI_OBJID" > foreignTable="CA_STOREBAGINFO" > displayType="select" > foreign="OBJID" > visibleFields="title"/> > </field> > ... > --- > > Part of Child table: > --- > <table name="CA_STOREBAGINFO" > defaultVisibleFields="OBJID" > > <field name="OBJID" fieldType="number" > size="22" isKey="true"/> > <field name="TITLE" fieldType="varchar2" size="250"/> > .... > --- > > My code in the jsp for the DESIGNINFOOBJID-column in the parent form: > ---- > <td> > <a > href="<db:linkURL > > href="/pages/ca_designinfo_single_readonly.jsp" > tableName="CA_REPORTSTATICDESIGNINFO" > childField="OBJID" > parentField="DESIGNINFOOBJID" > singleRow="true"> > <db:position fieldName="OBJID" > value="<%=(String) > currentRow_CA_REPORTSTATICINFO.get("DESIGNINFOOBJID")%>"/> > </db:linkURL>" > > > > <db:dataLabel fieldName="DESIGNINFOOBJID"> > <db:tableData name="designinfo" > foreignTable="CA_REPORTSTATICDESIGNINFO" > visibleFields="TITLE" storeField="OBJID"/> </db:dataLabel> > > </a> > </td> > > ---- > > The select to resolve the foreignkey relationship works, but > the link (href=..) does not. The same error message as I > described in the first mail appears. > > > Any further ideas? > > > Greetings, > > > Gunter > > > -----Ursprüngliche Nachricht----- > Von: Henner Kollmann [mailto:[EMAIL PROTECTED] > Gesendet: Montag, 24. Mai 2004 13:20 > An: 'Gunter Matella' > Cc: [EMAIL PROTECTED] > Betreff: AW: [dbforms] Foreign key handling in dbforms_2.3_20040329 > > > > jsp. Unfortunatly this does not work. I got a error: "Make > sure that > > field DESIGNINFOOBJID is a KEY of the table CA_REPORTSTATICINFO! > > Otherwise you can not use it as PARENT/CHILD LINK argument!" > > > > But: The field DESIGNINFOOBJID IS already declared in > > dbform-config.xml as <field name="DESIGNINFOOBJID" > fieldType="number" > > size="22" isKey="true"/>. > > > > 1. Please avoid _ in your table names, this could conflict > with names uses internally in dbforms. > We generate names with underlines and parse them... > 2. is the field DESIGNINFOOBJID defined with isKey="true" in > both tables? Parent and child? > That's necessary to find the right value. > Attention: Only set isKey="true" in the parent table, no > changes in your database schema! > > Cheers, > Henner > > > ------------------------------------------------------- This SF.Net email is sponsored by: Oracle 10g Get certified on the hottest thing ever to hit the market... Oracle 10g. Take an Oracle 10g class now, and we'll give you the exam FREE. http://ads.osdn.com/?ad_id149&alloc_id66&op=click _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
