Subject | IBO 4'Replication |
---|---|
Author | c46@winton.com.tw |
Post date | 2001-06-22T06:32:11Z |
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, thanks
Regards
Gordon Li
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, thanks
Regards
Gordon Li