Standard-UDF doesn't work

Michael Jarmer

Delphi Developer

Sat, 20 Nov 2004 23:47:34 GMT

Standard-UDF doesn't work

i declared the function substr with:

DECLARE EXTERNAL FUNCTION substr
CSTRING(80), SMALLINT, SMALLINT
RETURNS CSTRING(80) FREE_IT
ENTRY_POINT "IB_UDF_substr" MODULE_NAME "ib_udf";

like it explained in the helpfile, but after i called the function
i get the error:

invalid request BLR at offset 63
-function substr is not defined
-module name or entrpoint could not be found

the ib_udf.dll file is in the directory ....\bin
and in ...\lib

Interbase Server Version 5.5
the interbase sql-server runs on windows2000 server.

I tried the same on a local database, and it doesn't work

can anybody help me?

Many thanks!

Félix Gonzále

Delphi Developer

Sun, 21 Nov 2004 22:34:49 GMT

Re:Standard-UDF doesn't work

I dont remember in 5.5 but in ib 6.0 mast be in /udf

"Michael Jarmer" <michael.jar...@e-tech.at> escribi en el mensaje
news:3cfcde81$1_1@dnews...

Quote

> i declared the function substr with:

> DECLARE EXTERNAL FUNCTION substr
> CSTRING(80), SMALLINT, SMALLINT
> RETURNS CSTRING(80) FREE_IT
> ENTRY_POINT "IB_UDF_substr" MODULE_NAME "ib_udf";

> like it explained in the helpfile, but after i called the function
> i get the error:

> invalid request BLR at offset 63
> -function substr is not defined
> -module name or entrpoint could not be found

> the ib_udf.dll file is in the directory ....\bin
> and in ...\lib

> Interbase Server Version 5.5
> the interbase sql-server runs on windows2000 server.

> I tried the same on a local database, and it doesn't work

> can anybody help me?

> Many thanks!

Craig Stuntz [TeamB

Delphi Developer

Mon, 22 Nov 2004 00:15:08 GMT

Re:Standard-UDF doesn't work

In article <3cfe2159_2@dnews>, felix.gonzal...@gvgest.es says...

Quote

> I dont remember in 5.5 but in ib 6.0 mast be in /udf

In 5.5 they go in bin. But you shouldn't use 5.5 on Windows,
because it has serious bugs which can corrupt your DB. Get the update
to 5.61 from Borland.

-Craig

--
Craig Stuntz (TeamB) Vertex Systems Corp. Columbus, OH
Delphi/InterBase WebLog: http://delphi.weblogs.com
InterBase PLANalyzer (Free IB optimization tool):
http://delphi.weblogs.com/IBPLANalyzer

Other Threads

1. ISQL-StoredPros-UDF-IBAPI doesn't work?

2. udf that returns cstring doesn't works

3. Can't get Interbase supplied udf's to work on WinNT

4. WORKING DIRECTORY: Doesn't work

5. Post doesn't work with Indy, works with ICS

6. why filecopy(string,'test.txt',err) doesn't work

7. working with UDF's...

8. How to work with Blob in UDF's

9. TQuery's locate method doesn't work properly

10. UDF, Is it really possible to write UDF's DLL's with delphi (and make 'em work too?)