Ricardo,

try to use the UDF-Library, which is included in the replication
module. Put BlobCompare.dll (Windows) or BlobCompare.so (Linux)
into the Interbase\UDF subdirectory (you are using IB6.x or
Firebird?) and declare the external function as shown below.
Commit your changes and let us know if it works.

Regards,
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 10:59 PM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Blob comparison?
>
>
> 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/
> >
> >
> >
>
>
>
>
> __________________________________________________________________
> _________
> 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/
>
>
>
>