Subject RE: [IBO] Blob comparison?
Author Thomas Steinmaurer
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 IBO┬┤s 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/
>
>
>
>