Hi all

We have moved to Firebird 1.5 yesterday from interbase 5.6 and i
encouter similar problems as Jason S.has
I have a TIB_Query containing a sql like this:
select
pn_id,
pn_nam,
(select f_dectotime(sum(rud_totaaldec))
from rudpx
where (rud_per = j2w_pnpx.pn_id)
and (rud_soort = 'U')
and (rud_verlof = 1)
and f_striptime(rud_dat)>= :datum) as verlof
from j2w_pnpx
where (pn_id = :persoon)

If i don't do the select with the sum the parameter :persoon is
recognised as a varchar(4) which is correct.
If i include it the parameter :persoon is recognised as a Timestamp,
which i can't understand.

This is a major problem.
If i execute the sql in ibexpert on the firebird db it works fine, i
don't know why TIB_Query thinks :persoon is a Timestamp and i see no way
to force it to accept it as a varchar(4)
On Interbase 5.6 the parameters were recognised correctly.

D7ent with ibobjects 4.3.A on firebird 1.5

Any help will be most appreciated

Franky


_____

Hi Jason,

> Can anyone tell my why this code doesn't work? I am using IB_Query
> components.
>
> SELECT WORKINGDOCKET.DOCKETID AS WORKDOCKETDOCKETID
> , DATEOPENED

(...)

> WORKINGDOCKET.SOCIALSECURITY
> WHERE WORKINGDOCKET.DATEOPENED BETWEEN :DATE1 AND :DATE2

(...)

> Its definitely this line WHERE WORKINGDOCKET.DATEOPENED BETWEEN
> :DATE1 AND :DATE2
>
> that causes the trouble, and I assume its because the date1 and
> date2 parameters are not specifically defined as timestamps - but I
> cant find anywhere to do that. I know when I was using ADO the
> parameter type had to be specified as datetime for it to work.

If you assign the param values in code, do it like this:

MyQuery->ParamByName( "DATE1" )->AsDateTime = ...


Greetings,
Paul Vinkenoog


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




Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://rd.yahoo.com/SIG=1299n3a7e/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1084919371/A=2128215/R=0/SIG=10se96mf6/*http://
companion.yahoo.com>

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=259713669>

_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/IBObjects/

* To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com
<mailto:IBObjects-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .




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