Dear Cetin,

Pardon me for my ignorance?

I've just bought VFP7 and not able to go through its features. Based on your suggestions I went through Creating offline views part in VFP6 programmer's guide.

And also checking XMLUpdateGram() function. I have following questions besides this;

1. I have application developed in VFP6 and implemented in all 18 locations, Can I compile my application in VFP7, after adding XMLUpdateGram() function. And will it be able to share data with VFP6 complied application??

2. I am using a Leased Line for internet connection, and my Indonesia office uses a dial-up connection. How can I write a procedure which will automatically and periodically synchronize, Indonesia data with Singapore,so that both sides will have access to complete information??

I am desparately looking for a solution on these grounds.

Currently we are using FTP or Email to transfer data, and manually running programs to update local database.

Awaiting your reply.

Cheers
Shaishav
>XMLUpdateGram() is new to VFP7. For offline views, check creating views section in help, creatoffline(), dropoffline(), use .. online
>Cetin
>
>>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