Subject | RE: [IBO] How to use Query.Filter with Alias column |
---|---|
Author | IBO Support List |
Post date | 2013-08-26T16:30:56Z |
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
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