Hi,
i have see a strange behaviour with a TIB_Query with param and FireBird
1.5 only when the param are used in a stantment like this:

SELECT TB.FIELD1,
TB.FIELD2,
(select TB2.FIELD1 from TB2 where TB2.FIELD3 = :Param1),
TB.FIELD3
From TB
Where TB.FIELD4 = :Param1

But if i remove the "(select TB2.FIELD1 from TB2 where TB2.FIELD3 =
:Param1)," all works fine.

Regards,
Enrico Raviglione.



-----Messaggio originale-----
Da: lgautonxx [mailto:lgauton@...]
Inviato: venerdì 5 settembre 2003 9.50
A: 'IBObjects@yahoogroups.com'
Oggetto: [IBO] IBO and Firebird 1.5


I'm experiencing a particular problem using IBO and Firebird 1.5, my
system is Delphi 7 with IBO 4.2I

using a TIB_Query and populating an sql query using statments like

ibquery.params[0].asdatetime := StartDate;

running the query produces empty result sets.

If the dates are hard coded then all works fine.

Also, everything works fine when the same query population is used
against Firebird 1.0


Does anyone have any ideas?



________________________________________________________________________
___
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 !


Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/