|Subject||RE: [firebird-support] Re: IBOQuery and datasource mechanics|
ah ha! - maybe I need to read more about this - thanks
> -----Original Message-----
> From: fabiano_bonin [mailto:fabiano@...]
> Sent: Saturday, 5 July 2003 10:04 PM
> To: firstname.lastname@example.org
> Subject: [firebird-support] Re: IBOQuery and datasource mechanics
> Did you try to change 'OldParameterOrdering', in firebird.conf?
> --- In email@example.com, "Alan McDonald" <alan@m...>
> > 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
> > 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
> > parambyname in this context does not take, even when I name the
> > 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
> > 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?
> > thanks
> > Alan
> To unsubscribe from this group, send an email to:
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/