Hi,

At July 4, 2003, 21:40, Alan McDonald wrote:

> I have an IBOQuery which worked fine in IB but not FB as follows:

> <ABBREVIATED>
> select tablea.field1, tablea.field2,
> (select sum(table2.field1) from table2 where table2.field3=:PARAM1) as total
> from tablea where tablea.field5=:PARAM2

> Now this query was linked to a datasource and the param1 field was available
> as well as the param2 field.

> In IB6.02 this query works fine but in FB1.5RC3 it does not. The PARAM2 gets
> linked but the PARAM1 does not. In fact I have more than one subselect in
> this query (all of which use the param1) and even manually assigning
> parambyname in this context does not take, even when I name the params
> uniquely. It silently returns no records at all.

> Don't know if this is IBO of FB.. ?

> I know about the argument that the param1 and subselect (especially when
> used in more than one subselect) is a different cursor but I would rather
> not hear "This was a bug in IB which has been fixed in FB"
> I rather like this feature and used to use it a lot. Now I must build these
> queries as fixed SQL statements.

> thoughts?

Ask the question on the Firebird-Support group or Firebird-Devel(since
it's related to changes made in FB 1.5).

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)