Hi Cetin,

Could you please guide me where can I look for more information on offline views and XMLUpdateGram().

I am using VFP6.

Regards
Shaishav

>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