I have a syncronization table with fields to capture the modified table's name, the type of modification (N= new record, D= deleted record, M=modified record), a datetime field and a Syncronized field (logical)
Every time an update occurs in any table, the operation is recorded in the syncronization table. This means that anywhere you update,delete or add a new record, in any screen of your system, you should insert a record in the sync table. For instance, you add a new customer to customers.dbf . Therefore you add a new record in the sync table, as follows: replace table with 'customer', type with 'N',dt with datetime(),recnbr with (the customer table new pk) The same if you delete a record or modify one. Then you go to your office, you select all records from the sync table not marked as syncronized and update the server tables as per the information you get from that table. So first take all the deleted records and delete them in the server, then take all updates and all the additions and do the same (update or modify the server table record). You have to be careful with the relations between parent and child tables in respect of the primary and foreign keys, but it depends on how you designed your system. It is a laborious procedure, but it works very well for me. Rafael Copquin El 07/05/2012 10:28 a.m., Jeff Johnson escribió: > Excuse me if this was recently discussed because I thought it was, but > couldn't find it. I want to synchronize several VFP9 dbf files. A user > uses her laptop and then when she returns to the office want's to > synchronize the dbf's with the server. A full two way synchronization. > > I have looked at DBFSync but it requires selecting each dbf and each > field to synchronize. I suppose once you set it up, that would be okay. > > Does anyone use synchronization effectively in their applications? > > TIA > _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
