Try quote reserved words in querys - i.e.

SELECT mytable."SUM" from mytable;

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf Of Carlos Martins
Sent: Wednesday, September 19, 2012 3:43 AM
To: ibobjects@yahoogroups.com
Subject: Re: [IBO] IboQuery add fields problem



Thanks for your anser, but im trying to migrate from bde to ibo and from firebird 1.5 to firebird 2.5. im my code i have lots of querys with reserved word (sum , count, max min, and so on),. I know that i can solve my problem with the keyword AS, but i was trying an earsier way to do it. is it possible ?. Thanks Carlos

------------------------------

On Tue, Sep 18, 2012 12:02 PM PDT Helen Borrie wrote:

>At 02:38 AM 19/09/2012, jcfmgmr wrote:
>>Hello
>>
>>When i try to add fields from a iboquery (with this sql: select sum(faccod) from tab_fac ) at design time, on the avaible fields box
>>shows the field '"SUM"' ( SUM with double quotes).
>>When i try to use this field i get the message .. field '"SUM"' not found.
>>Note:
>>I only get this error when i connect to a firebird server 2.5 ( Dialect 3; CharSEt WIN1252), If i connect to a firebird server 1.5 ( Dialect 1; CharSEt NONE), evrything works just fine.
>>
>>Could anybody help ??
>
>Various things have happened with "lazy" SQL in Firebird since v.1.5 to disambiguate behaviour. The names of calculated fields specified without identifiers are a case in point. AFAIU, IBO is trying to do the right thing by double-quoting a field that is a reserved word.
>
>Try it with the proper syntax of
>
>select sum(faccod) AS TOTAL from tab_fac
>
>(The keyword AS is optional, the fieldname can be any valid identifier.)
>
>Helen
>



[Non-text portions of this message have been removed]