Patrick wrote:
> Has anyone done a project like this?
Yes, but PCA isn't the issue -- the smarts were in the Delphi
code and the transfer was via FTP (our WebQueue system --
http://www.spis.co.nz/webcentr/webqueue.htm -- it could just
have easily have been PCA).
> Is pcAnyWhere limited to downloading the complete database files and
As far as I know (and as we use it), it most certainly is so
limited. When we want piecewise database replication, we've
always written the software to do it, and used Webqueue, email
or whatever system is appropriate to get the the changes up and
integrated (more smarts at the other end).
> How do you synchronise say three remote clients that all dial in at
> different times and might have all changed the same record since they
> last downloaded?
Very, very carefully. There is never a single policy for such
cases, and, at worst, you track changes and present them to a
OI (organic intelligence) system to resolve.
cheers,
peter
============================================
Peter Hyde, SPIS Ltd, Christchurch, New Zealand
* TurboNote: http://TurboPress.com/tbnote.htm
-- small, FREE and very handy
* Print-to-Web automation http://TurboPress.com
* Web design, automation and hosting specialists
Find all the above and MORE at http://www.spis.co.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
