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