Hello, I have two questions regarding the foreign key handling in dbforms:
Precondition: I generated a dbforms-config.xml using the devgui-Application. The db makes massiv use of foreign key relation ship and I want to create forms (jsp's) which reflect this as good as possible (using drop-down-boxes or links): First question: -------------------- I tried to implement a read-only form (jsp) which display the content of a table. The foreign key relationsship of some column should be visualized by an html-link. The user could click on the link and the detail content of the row in the foreign table of this column should be displayed in a new 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"/>. Any idea how to solve this problem? Second question: ------------------------- I am using the XSL-Stylesheets to generate jsp`s for each table (this is a great feature!). It works well except one feature regarding the foreign key support: As in the user manual described there should exist some xsl-code which can create automaticlly a drop-down-box for each foreign key relationship defined in the dbforms-config.xml. But in the normal distribution package no one of the xsl-files includes any code to handle foreign keys . Has anyone a xsl-template (sample) which enable me to create such drop-down-boxes automaticly using the devgui-generation process? Any help is welcome! Thanx in advance... Gunter -- NEU : GMX Internet.FreeDSL Ab sofort DSL-Tarif ohne Grundgeb�hr: http://www.gmx.net/dsl ------------------------------------------------------- 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_id=3149&alloc_id=8166&op=click _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
