Hi all,

This problem is weird, i hope someone here can shed a light on it.

Using Delphi 7, Ib 5.6 and ibobjects 4.2.Ib
When i execute this sql in a TIB_QUERY i get a error connection lost to
database.
When i do the same query in delphi 4 with ibo i don't have a problem.
When i execute this sql in ibexpert or ib_sql it works fine.
It also works fine with the ib tool IB_SQL.exe.


And in D7 i can execute it with a standard TIBQUERY , just not with a
TIB_QUERY.
sql:

select f_dectotime(sum(rud_totaaldec)) prestaties from rudpx where
(rud_soort = 'U') and (rud_per = :pn_id)
and (f_striptime(rud_dat) >= :datum) and (f_striptime(rud_dat) <= :tot)

There are udf's defined in the database(own udf's) that are used here.
Any hints are very welcome.. thanks




[Non-text portions of this message have been removed]