Thomas,

Before I had declared any udf it accused this problem, so I have declared:

DECLARE EXTERNAL FUNCTION F_BLOBBINCMP
BLOB, BLOB
RETURNS INTEGER BY VALUE
ENTRY_POINT 'BlobBinCmp' MODULE_NAME 'freeudflib.dll';

The error asks for this function in

> > Function unknown
> > F_BLOBBINCMP

Should I declare this other function you mentioned?
I have placed the dll at ...\Interbase\udf directory.

Thanks for your reply.

Ricardo


""Thomas Steinmaurer"" <ts@...> escreveu na mensagem
news:FGEFIGLMFAKKKHHOJFHNKEMLDGAA.ts@......

> Ricardo,
>
> how does the declaration of the user-defined function look like?
> In which directory have you placed the UDF-Library "BlobCompare.dll"?
>
> Out of the replication help file, the declaration looks like.
>
> /* Returns 1 if two blobs are equal, 0 if not */
> DECLARE EXTERNAL FUNCTION FN_BLOBS_EQUAL
> BLOB, BLOB
> RETURNS INTEGER BY VALUE
> ENTRY_POINT 'fn_blobs_equal'
> MODULE_NAME 'BlobCompare';
>
>
> HTH,
> Thomas Steinmaurer
> IB LogManager 2.0 - The Logging Tool for Interbase/Firebird
> http://www.iblogmanager.com
>
> > -----Original Message-----
> > From: news@... [mailto:news@...]On Behalf Of
> > Ricardo Costa (Agenda Digital Ltda)
> > Sent: Friday, April 19, 2002 6:05 PM
> > To: IBObjects@yahoogroups.com
> > Subject: [IBO] Blob comparison?
> >
> >
> > Hi,
> >
> > I'm testing IBO4s replication module.
> > When I try to load a metadata this error happens:
> >
> > "ISC ERROR CODE:335544569
> >
> > ISC ERROR MESSAGE:
> > Dynamic SQL Error
> > SQL error code = -804
> > Function unknown
> > F_BLOBBINCMP
> >
> > STATEMENT:
> > TIB_DSQL: "DefaultSession.dmRPL_Scripts.scSRCLoadMeta.<TIB_DSQL>."
> >
> > Sql Message:
> >
> > "SQL ERROR CODE:-804
> >
> > SQL ERROR MESSAGE:
> > An error was found in the application program input parameters for the

SQL

> > statement."
> >
> > Sql:
> >
> >
> > "CREATE TRIGGER RPL$<<IND_NME>>$Q_AU
> > FOR <<SRC_TBL_NME>>
> > AFTER UPDATE
> > AS
> > DECLARE VARIABLE Q_TYP CHAR( 1 );
> > <<SRC_TRG_DEC_VAR>>
> > <<SRC_BLA_DEC_VAR>>BEGIN
> > Q_TYP = 'U';
> > IF ( <<SET_EXP_NEW>><<SRC_ADD_EXP>> ) THEN
> > BEGIN
> > IF ( NOT ( <<SET_EXP_OLD>><<SRC_ADD_EXP>> )) THEN
> > BEGIN
> > <<CUSTOM_SRC_Q_INS_TRG>>
> > END
> > ELSE
> > IF ( <<SRC_UPD_EXP>> ) THEN
> > BEGIN
> > <<SRC_BLA_INIT_VAR>><<SRC_BLA_SET_VAL_AU>>
> > <<CUSTOM_SRC_Q_UPD_TRG>>
> > END
> > END
> > ELSE
> > IF ( <<SET_EXP_OLD>><<SRC_ADD_EXP>> ) THEN
> > BEGIN
> > <<CUSTOM_SRC_Q_DEL_TRG>>
> > END
> > END "
> >
> >
> > I have installed this function on both database.
> > Anyone knows what am I doing wrong here?
> >
> > Thanks for any help.
> >
> > Ricardo
> >
> >
> >
> >
> > __________________________________________________________________
> > _________
> > 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 !
> >
> >
> > Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/

> >
> >
> >
> >
>
>
>
>

___________________________________________________________________________

> 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 !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>