On 2012.09.21 10:12 PM, HECTOR RIOS wrote:
Hi,
I´m trying to save some sql parsing in a Delphi application by using
temporary result sets. Is there such thing in Firebird?
For example: some user makes a query with some filters and then wants
to make another query over results from previous
On 9/21/12 3:12 PM, HECTOR RIOS wrote:
I´m trying to save some sql parsing in a Delphi application by using
temporary result sets. Is there such thing in Firebird?
For example: some user makes a query with some filters and then wants to make
another query over results from previous query.
@yahoogroups.com
Sent: Saturday, September 22, 2012 3:48 AM
Subject: Re: [firebird-support] How to make queries to a temporary result set
On 2012.09.21 10:12 PM, HECTOR RIOS wrote:
Hi,
I´m trying to save some sql parsing in a Delphi application by using
temporary result sets
filters to this temporary.
Regards,
Hector Rios
From: Fabiano mailto:fabianoaspro%40gmail.com
To: mailto:firebird-support%40yahoogroups.com
Sent: Friday, September 21, 2012 1:26 PM
Subject: RES: [firebird-support] How to make queries to a temporary
result
: Saturday, September 22, 2012 12:06 AM
Subject: Re: RES: [firebird-support] How to make queries to a temporary result
set
I am not 100% sure about this, but I think Firebird supports temporary
tables. You might try with that...
On Sep 22, 2012 1:41 AM, HECTOR RIOS mailto:scadcam2004
On Sep 22, 2012, at 6:22 PM, HECTOR RIOS scadcam2...@yahoo.com wrote:
Hi,
Seems like temporary result set does not exist or at least nobody seems heard
about it.
Firebird makes an effortvto follow the SQL standard, which is not necessarily
intuitive. Undermthe standard, temporary tables
Hi,
I´m trying to save some sql parsing in a Delphi application by using temporary
result sets. Is there such thing in Firebird?
For example: some user makes a query with some filters and then wants to make
another query over results from previous query.
It would be easy if added the filters
Maybe:
Select * from
(
select * from table where field1 = 1
) as FILTER
Where FILTER.field2 = 2
Fabiano.
[Non-text portions of this message have been removed]
: [firebird-support] How to make queries to a temporary result set
Maybe:
Select * from
(
select * from table where field1 = 1
) as FILTER
Where FILTER.field2 = 2
Fabiano.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been