Tomas,

I don't have this dll. Maybe it is because I�m under trustware license?
Where can I get it (If I can)?

Thanks

Ricardo


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

> 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/

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

___________________________________________________________________________

> 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/
>
>
>