Shaishav,
I'm sure I sent it but unfortunately I can't find it either. It was very old and possibly gone with the wind (strange Bela's control is related with me).
Anyway I think offline views and/or XMLUpdateGram() would likely be your solution.
Cetin
>Dear Cetin,
>
>Tks yr reply.
>
>Tried searching articles, but could not find any documents from you other than treeview.
>
>Please advise me where to look for that article.
>
>Awaiting your reply,
>
>Regards
>Shaishav
>
>>>Hi Everyone,
>>>
>>>I've installed same application on two sites. One is in Singapore and other in Indonesia.
>>>
>>>Singapore and Indonesia maintains their own databases. Now we want to merge the information. In such a way that Indonesia can update their information locally and later upload to Singapore server, where the data will be merged to Singapore database.
>>>
>>>Can anyone guide me what are the best practices for this.
>>>
>>>Please note data can be modified/ammended at either site, however creation is always from Indonesia.
>>>
>>>How do I synchronize both databases so as, Indonesia can send records created/modified by them as well as can receive modifications done by Singapore to their data.
>>>
>>>And how does singapore can receive data, sychronize with Indonesia, modify and send back changes.
>>>
>>>A little confuse here, will appreciate help from you geniouses.
>>>
>>>TIA
>>
>>Shaishav,
>>I sent an article years ago that targeted fox2x too, unfortuantely I don't even remember the name of it, you might find it searching.
>>However with VFP check offline views (createoffline(), dropoffline(), use online..admin). You can't insert, pack,zap them but not a problem since owner side should do insert and both sides could do modification.
>>Also you could use VFP7's XMLupdategram() to log and send only insert,delete,update xmls.
>>You could also use VFP ActiveDoc and web but that should be slow.
>>Cetin