> 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

Perhaps you could get a SQL Trace on it?

Jason Wharton
CPS - Computer Programming Solutions
Mesa Arizona
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --