Yes, it is. DbForms always requires an sorted output. So always sorting after the key fields is added.
Henner > -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im > Auftrag von jitu > Gesendet: Montag, 16. August 2004 11:18 > An: [EMAIL PROTECTED] > Betreff: [dbforms] Re: Query does not generate "AS" in the > select statement > > > 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 > ------------------------------------------------------- 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
