Can anyone help with the following problem please:
A have a server set up with a database that is doing transactional replication to another server with queued updates at the subscriber.
When an application writes a record into a table on the subscriber, the record is successfully written, and is fed back to the publication/distribution server also, which is what I'd expect. However, an exception is raised with the following message causing the program to halt (I'm using Delphi and the ADO). I could intercept this and ignore it but I'd like to understand what the problem is:
Message: Updatable subscriptions: The text/ntext/image values inserted at Subscriber will be NULL
There are only 2 memo/text fields in the record and they DO contain data. All other fields are string or number apart from the special field at the end of the table created by the replication process.