Subject RE: [IBO] Ibo replication
Author Daniel Jimenez
Hi Jason,

Following the Tutorial, I have created a DB called Source, with a single
table

RECREATE TABLE MEMBERS
(
ID NUMERIC( 18, 0) NOT NULL,
NAME VARCHAR( 50) NOT NULL COLLATE NONE,
CONSTRAINT PK_MEMBERS PRIMARY KEY (ID)
);

I have also created another Db called Destination, which has no tables
defined.

Now as per the tutorial I have added the latest Windows version of Gregory
Deatz' FreeUDFLib library to the server and to declare the User-Defined
Function (UDF) F_BLOBBINCMP on the SOURCE DB.

DECLARE EXTERNAL FUNCTION F_BLOBBINCMP
BLOB, BLOB
RETURNS INTEGER BY VALUE
ENTRY_POINT 'BlobBinCmp' MODULE_NAME 'freeudflib.dll';


So far no problems. Step 2 - "Configuring and loading Indexes for
Replication" works fine until you get to the point where you click the "Load
Metadata" button. At this point I get the following error Message:

ISC ERROR CODE:335544569

ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -104
Token unknown - line 26, char 11
)

STATEMENT:
TIB_DSQL: "IBO_DefaultSession.dmRPL_Scripts.scSRCLoadMeta.<TIB_DSQL>."

If you select the SQL tab in the Error dialog window, you get :

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

Help would be much appreciated, as I am not sure what is the problem(s)

Thanks

Daniel






[Non-text portions of this message have been removed]