David,

Sounds like you are talking about batch updates? And that you want the functionality built into your app?

In that case, Mabry's Internet controls are very nice. I wrote a transfer system a couple of years ago without too much trouble where the Mabry RAS control would dial in to the remote machine, and then I used the Mabry FTP control to transfer files.

A couple of notes on this approach. I used a variety of safeties to ensure that data was successfully transferred. Each record to be sent had an "acknowledged" flag in it, which was by default false. Every time a transfer was batched up, I would pull all records not yet acknowledged. This meant almost all records were transferred at least twice, but it was pretty much monkey-proof. At the receiving end, the app would examine each record that it had not previously processed, then post only the new ones. Each time it received a record, it wrote the record's surrogate key to an acknowledgement file, which was picked up by the remote machine.

Another trick is to use file extensions to denote file types. Files going from remote to back office should have one extension, such as "IN", and should be named sequentially, such as "00001.IN", "00002.IN", etc., which is another way to be sure no transfer ever overwrites another. Acknowledgement files would be named "00001.ack", "00002.ack", etc.

Hope this helps.


>In my project I have to connect two computer via modem .
>Computer No.1 have to send data to no.2 via modem 2,3 times a day (both will have vfp6.0 prgs).
>What is best approach to do that.
>Is it via dial-up server and offline remote views.
>Anybody have experience doing this ?
>
>Thanks in advance
>
>Davor Milutinovic
>davorm@eunet.yu