Subject How to maintain coherence between 2 databases
Author henry FRANQUET
Hi,

I have a Firebird 1.5 database on laptop which is a subset of a
large database on a server (some tables, some fields and some
records).
On the laptop, a monouser application in Delphi 5 and IBObject
TIBOTable and TIBOQuery update the local database. From time to
time, say every week or every two weeks, I have to update, via a
modem (at least 33Kbs), the server database with all the
modifications made to the local one

What is the best strategy with IBObject?
1) having 2 local databases (one before modification and one after,
compare the 2 and create queries to update
2) use of a table of modification witch key is tableName, keyName,
keyValue
3) another solution

a) update via SSL and TCP-IP links
b) transfert a file for updating (not as easy to solve dual
updating on local and server database of the same data)

Is there some tricks in ibobject to identify if a field has changed

Thanks