From: Vlad H. <hv...@us...> - 2006-01-31 21:21:35
|
> I have been trying to cope with a set of problems that showed up when > I switched over to the 2.0b1. One of them is reproducible from the > isql.exe command line tool, and I hope this will be enough data to > reproduce the problem. > > UDFs: > > fbudf.dll and ib_udf.dll from the distribution and FreeAdhocUDF.dll. I don't know what is FreeAdhocUDF.dll > Incidentally, the 2.0b1 ib_udf.sql has two errors when you load it. What errors ? > The problem also shows up with the old FreeAdhocUDF.dll, and both > versions work with 1.5.2. > Query: > > SELECT (("Calcs"."int0")) AS "int0 (dim)", > "Calcs"."key" AS "key", > "Calcs"."str2" AS "str2", > ((CASE WHEN ("Calcs"."int0") >= 0 THEN SRIGHT > ("Calcs"."str2",F_TRUNCATE(("Calcs"."int0"))) ELSE NULL END)) AS > "z_right_str_num3" > FROM "Calcs" What is SRIGHT and F_TRUNCATE ? > generates an error: > > Statement failed, SQLCODE = -902 > Error reading data from the connection. Look at firebird.log for details. It seems that FreeAdhocUDF.dll have a bugs in it (most probably it is written not using cdecl calling conventions) > Any ideas? Your subject line references ODBC while i can't found any reference on it in the message text. What do you mean ? Regards, Vlad |