In an application I'm working on, I have a page that shows fields from multiple tables. So, I have the following:
dbforms-config.xml: <table name="ACCOUNT_CUSTOMER"> <field name="ACCOUNT.ACC_ID" fieldType="int" size="6" isKey="true"/> <field name="ACCOUNT.ACC_CODE" fieldType="varchar" size="20"/> <field name="ACCOUNT.ACC_DESCRIPTION" fieldType="varchar" size="255"/> <field name="CUSTOMER.CUST_ID" fieldType="int" size="6" isKey="true"/> <field name="CUSTOMER.CUST_AFM" fieldType="varchar" size="10"/> <field name="CUSTOMER.CUST_NAME" fieldType="varchar" size="90"/> </table> account_list.jsp: (renaming it to: /db/account.list) <db:dbform autoUpdate="false" followUp="/db/account.list" maxRows="25" whereClause="WHERE ACCOUNT.CUST_ID=CUSTOMER.CUST_ID" tableName="ACCOUNT_CUSTOMER" tableList="ACCOUNT, CUSTOMER"> Everything seems to work correctly. Except of the navigation buttons, aka navFirstButton, prev, next and last. The log, shows the following: When accessing the page for the first time, it creates the following sql query: SELECT ACCOUNT.ACC_ID, ACCOUNT.ACC_CODE, ACCOUNT.ACC_DESCRIPTION, CUSTOMER.CUST_ID, CUSTOMER.CUST_AFM, CUSTOMER.CUST_NAME FROM ACCOUNT, CUSTOMER WHERE ACCOUNT.CUST_ID=CUSTOMER.CUST_ID and it works just fine. But, when using the navButtons, I get the following sql query: SELECT ACCOUNT.ACC_ID, ACCOUNT.ACC_CODE, ACCOUNT.ACC_DESCRIPTION, CUSTOMER.CUST_ID, CUSTOMER.CUST_AFM, CUSTOMER.CUST_NAME FROM ACCOUNT_CUSTOMER WHERE ( (ACCOUNT.ACC_ID> ? ) OR (CUSTOMER.CUST_ID> ? AND ACCOUNT.ACC_ID>= ? ) ) Of course, there is not any table with the name ACCOUNT_CUSTOMER, so I get the following error: java.sql.SQLException: General error: Table 'isol.account_customer' doesn't exist Any suggestions? --- Stratos Nikolaidis Thessaloniki, Greece ------------------------------------------------------------- http://www.mail.gr/ - Get Your Private Free Email Address! http://www.ringtone.gr/ - Ringtones & Logos for your mobile! ------------------------------------------------------- This sf.net email is sponsored by: Dice - The leading online job board for high-tech professionals. Search and apply for tech jobs today! http://seeker.dice.com/seeker.epl?rel_code=31 _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
