Re: replication and LONG fields

Hi Joshua,
you <josh_d_at_magicnet.net> wrote:

>Stephane Lajeunesse wrote:
>>
>> Hi all,
>>
>> We are about to use replication (multi-master) on two databases. I've
>> read somewhere that you can't use row-level replication on LONG fields.
>> How would one go about using replication on LONG fields?
>>
>> Thanks,
>> Stephane Lajeunesse
>> slajeunesse_at_sympatico.ca
>Create your own replication using triggers.
I try to do this for a couple of tables where I have LONG-fields in, but I have the problem, that my trigger is not working with the LONG-Fields.
I did a test with a simple table, when I altering the table by adding a long field and change my trigger to save changes on that field, it's always NULL.
I'm using the :new.<column>-syntax for inserting the rows in my table. Are there any problems with that?? I didn't find anything in the manuals.
>
>My advice would be to only transfer the Long fields when you have to,i.e
>transfer on a schedule where it won't impact your network.
>
>Any problems, I've written a procedure to do this..
A hint, how you did that, would be very helpful.

Chris
>
>josh_d_at_magicnet.net (J&C Davis Consulting)
>http://www.magicnet.net/~josh_d
Received on Fri Apr 17 1998 - 02:11:51 CDT