Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Ftp
Message
From
05/12/2016 14:38:22
 
 
To
05/12/2016 14:30:05
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Re: Ftp
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01644478
Message ID:
01644479
Views:
48
>Hi
>
>I used to download dbf file (2 MB free table) from FTP of one office to other office.
>I copy always the all file and then taking only the new lines if any.
>
>The two offices work with my vfp programs and the ftp copy procces is also by my vfp program.
>
>Till now the offices worked in diffrent hours and every thing work fine.
>Now we start to work in same hours.
>
>My question is about case that user will insert data and in the middle other user will dwonload the file via FTP.
>I dont care to get the current new entry in this dowonload, I can take it in the next download,
>My question is if would be whether any file damage or program crashing by one of the offices.

You could test by:

- Initiating an FTP download, and while that is running try to obtain an RLOCK() or FLOCK() on the file, and

- Getting an FLOCK() on the file, and try to start the FTP download

If you want to prevent any chance of contention, you could copy the production file to another folder, then download that via FTP.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform