Page 1 of 1
sign function return error!
Posted: Tue 06 May 2008 09:54
by xalion
SQL:
select b.*,case
when b.xx0 then 'xx2'
when b.xx=0 then 'xx3'
end "xxxx" ,sign(xx) as sj
from gzb b
the return value of sj is: 0,1 ,-256.
-256 shoud be -1.
please fix it!
Posted: Wed 07 May 2008 03:53
by xalion
in Ibdac 2.5 beta ,it works ok!
Posted: Wed 07 May 2008 07:47
by Plash
Please specify whether SIGN is your own function. If so, please provide the code of this function.
Also specify the exact version of your Firebird or InterBase server, and the exact version of IBDAC (with the build number) where the problem occurs.
Posted: Wed 07 May 2008 07:57
by xalion
database server:Firebird 2.1
Ibdac version: 2.20.2.15
delphi 2007
sign function is firebird builder-in funtion.
Posted: Thu 08 May 2008 07:29
by Plash
We could not reproduce the problem. Please send to ibdac*crlab*com a complete small sample that demonstrates the problem, including the script for creating database objects.
Posted: Mon 12 May 2008 09:07
by xalion
I send the sample project and database to you.
Do you check it?
Posted: Mon 12 May 2008 13:07
by Plash
We have received your sample project. Could you please create another sample project without using national characters in the SQL property ?
Posted: Tue 13 May 2008 07:07
by xalion
I resend it to you as your requird!
Posted: Tue 13 May 2008 08:59
by Plash
We have reproduced the problem. Next IBDAC build will be based on IBDAC 2.50 beta. So the problem will be fixed there.