Another observation: the generated "select" statement is appending an "ORDER BY" clause which has not been specified in the query. This seems to come from the table definition of the "from" table. Is this a requirement of DbForms ?
regards, Jitu On Mon, 2004-08-16 at 08:10, jitu wrote: > Hi, > > For a query using expression, the "select" statement does not include > the keyword "AS" when renaming output columns an this keyword is > required by postgresql. Is there a way of getting over this problem ? > > Query: > > <query name="q_accbal_per" from="accbal_per"> > <search name="accid" fieldType="char" size="16" /> > <field name="sum_ledg_amt" expression="sum(ledg_amt)" > fieldType="numeric" size="16"/> > <field name="sum_tot_dr" expression="sum(tot_dr)" > fieldType="numeric" size="16"/> > <field name="sum_tot_cr" expression="sum(tot_cr)" > fieldType="numeric" size="16"/> > </query> > > The resulting select statement: > > INFO org.dbforms.config.Query - doSelect:SELECT sum(ledg_amt) > sum_ledg_amt, sum(tot_dr) sum_tot_dr, sum(tot_cr) sum_tot_cr FROM > accbal_per WHERE ( ( ( accid = ? ) ) ) ORDER BY accid > > The Syntax error due to missing "AS": > postgresql.util.PSQLException: ERROR: syntax error at or near > "sum_ledg_amt" > > > Regards, > Jitu ------------------------------------------------------- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
