Sync databases

[Jeff Barnes]

Hi,

I have an older application that was never intended for networking ...
Now I have customers that would like to have more than one pc running my app but have the data the same on all pc's

Can anyone please suggest some ideas as to how I could accomplish this?

[James Bott]

Jeff,

I'm afraid you will have to rewrite it to be multiuser.

I learned a long time ago to always write multiuser apps--they still work with one user and they are no more difficult to write if you have the needed classes.

Regards,
James

[José Luis Sánchez]

James,
Can you post or explain how work your classes to write multiuser apps.
Regards,
José Luis

[Jeff Barnes]

Hi James,

I hear you ... I too learned that lesson. Unfortunately this app was before that lesson

[James Bott]

José,

Can you post or explain how work your classes to write multiuser apps.

The main issue is database access--record locking. This can be handled using TDatabase or my enhanced TData class. Then you always open data files in shared mode and always lock records for updating. These classes contain all the code to allow you to do this with minimal programming effort. For example with my TData class and a small subclass, you can do:

oCustomer:= TCustomer():new()
oCustomer:seek( cCustNo )
oCustomer:phone:= "999-999-9999"
oCustomer:save()
oCustomer:end()

The above code is completely multiuser. It also has built-in automatic retrys if the record is busy during an attempted save.

Another useful class is a user class. This allows you to store and retrieve user security and preferences.

Regards,
James

[George]

Anyone has some experience using Tdata Class with ADS/ADT
I mean if we can use all Tdata power with Advantage Database Server ADT extension, instead of DBF.

Regards


George