Subject IBO 4'Replication
Author c46@winton.com.tw
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