Subject Re: [IBO] IBO 4'Replication
Author Jason Wharton
That is a part of the FreeUDFLib which you need to apply.
This was put in the last release so it hasn't made it to the help file just
yet.
I plan to have my own UDF is the reason since this one isn't ideal for the
circumstances.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com


----- Original Message -----
From: <c46@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, June 21, 2001 11:37 PM
Subject: [IBO] IBO 4'Replication


> Hi Jason :
>
> Today I tried to use IBO4's replication, I ran the demo program
> IB_RPL and followed the steps described at IB_RPL.hlp, but when I was
> at step 2 and tried to Load MetaData, I got the following error :
>
> 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>."
>
>
>
> CREATE TRIGGER RPL$<<IND_NME>>$Q_AU
> FOR <<SRC_TBL_NME>>
> AFTER UPDATE
> POSITION 0
> AS
> <<SRC_BLA_DEC_VAR>>BEGIN
> IF ( <<SET_EXP_NEW>><<SRC_ADD_EXP>> ) THEN
> BEGIN
> IF ( NOT ( <<SET_EXP_OLD>><<SRC_ADD_EXP>> )) THEN
> BEGIN
> INSERT INTO RPL$<<IND_NME>>$Q (
> RPL$Q_TYP, <<SRC_OLD_KEY_CLS>>
> , <<SRC_KEY_CLS>> )
> VALUES ( <<SET_EXP_NEW>>
> 'I', <<SRC_KEY_CLS_VAL>>
> , <<SRC_KEY_CLS_VAL>> );
> END
> ELSE
> IF ( <<SRC_UPD_EXP>> ) THEN
> BEGIN
> <<SRC_BLA_INIT_VAR>><<SRC_BLA_SET_VAL_AU>> INSERT INTO
> RPL$<<IND_NME>>$Q (
> RPL$Q_TYP, <<SRC_OLD_KEY_CLS>>
> , <<SRC_KEY_CLS>><<SRC_BLA_CLS_INS>> )
> VALUES (
> 'U', <<SET_EXP_OLD>><<SRC_KEY_CLS_VAL>>
> , <<SET_EXP_NEW>><<SRC_KEY_CLS_VAL>><<SRC_BLA_CLS_VAL>> );
> END
> END
> ELSE
> IF ( <<SET_EXP_OLD>><<SRC_ADD_EXP>> ) THEN
> INSERT INTO RPL$<<IND_NME>>$Q (
> RPL$Q_TYP, <<SRC_OLD_KEY_CLS>>
> , <<SRC_KEY_CLS>> )
> VALUES ( <<SET_EXP_OLD>>
> 'D', <<SRC_KEY_CLS_VAL>>
> , <<SRC_KEY_CLS_VAL>> );
> END
>
> I don't know what's the error means, is it my fault or sometning
> else? I want to know whether the replication feature can only be used
> under InterBase 6, I am running InterBase 5.6, and using
> IBO4_BETA_z5.zip patch thanks
>
> Regards
>
> Gordon Li
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>