You said, catch the subquery and use on filter?

My original SQL (example):

*select vend.nome,*
* ( select coalesce(sum(deve), 0)*
* from pedidosven ped*
* where ped.vendedor = vend.codigo*
* and ped.acfinanceiro = 'S'*
* ) DIVIDA*
* from vendedores vend*
*where vend.status = 'Ativa'*
* and vend.representante = 347*

The Query.Filter would look like this?

*Query.Filter := '(select coalesce(sum(deve), 0) from pedidosven ped where
ped.vendedor = vend.codigo and ped.acfinanceiro = 'S');*


2013/8/26 IBO Support List <supportlist@...>

> **
>
>
> Substitute the actual SQL that gives you that column in the place of the
> alias name.
>
> Alternatively, in the next release due soon, as soon as I pin down a couple
> bugs I am working on, you can assign that filter into the new FilterInMem
> property. What this does is it fetches in the records and then filters them
> in the client buffers. You might find this acceptable, in which case, you
> can include the alias name in the filter.
>
> Jason
>
>
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On
> Behalf
> Of Felipe Aron
> Sent: Monday, August 26, 2013 10:25 AM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] How to use Query.Filter with Alias column
>
> I have a SQL with one Alias column.
>
> When run the Filter (with this alias column) has one exception -- "Column
> unknown"
>
> How to use a Query.Filter in this case?
>
> --
> Analista-Programador
> #FollowMe: @felipearon <http://twitter.com/felipearon> (
> http://felipearon.net)
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> __________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> __________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>

--
Analista-Programador
#FollowMe: @felipearon <http://twitter.com/felipearon> (
http://felipearon.net)


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