Hi Tracy
Thanks for no 2 I had forgotten about that, use in on textbox's but it didn't occur to me to use it with an edit box. I will try it later. But shouldn't it be LEN(ALLTRIM(EDITBOX.VALUE)) or does an edit box always give the length of the text anyway. Can you elaborate more on No 1. I would not know where to start creating a C# service. The FTP is hosted on an SBS 2003 server. So we could install a web server on it. What worries me about that is security, surely any one could find the file and download it. We had come round to the idea of zipping the files. And my partner is working on a script to zip up the data once per day at a specific time. But, are you saying that Craig's FLL would Zip it on the fly and then pull it down. Incidentally I had tried to use that before I stumbled on Dave's offering, I couldn't get it to work. Thanks for your prompt answer. Peter -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Tracy Pearson Sent: 15 September 2012 13:46 To: [email protected] Subject: Re: FTP Peter Hart <[email protected]> wrote: >Hi gang > > > >I have a couple of problems, > >Ist for David Crosier's attention mostly. > > > >I am trying to get the FTP program working that is on Ed's download >page. > > > >I have a need to update the data on each of the clients home worker >machines > >The data sits on an SBS server at head office. And the home workers >machines are automatically backed up to the server using SyncBackSE. > >One home worker cannot get a static IP so I wish to use your program to >download and update her application. > >I have put your code into a form and also tried to run it as your prog. >There are over 100 tables and indexes to download. > >Either way I run it its stops at approximately the 60th file and then >gives a failure error. > >If I start the count at say 5 (For I - 5 To ALEN(.. It still fails on >the same file. The file is called grp.dbf and the previous file is >grp.cdx. > >The cdx file is quite a bit larger than the dbf, so I don't think it's >the size of the file. > >Also will I have a problem with the fact that the head office router >has a firewall rule to allow only certain IP's to FTP in. > >The Scotland satellite cannot have a static IP. Will the program still >work and if not can anybody think of a way round this. > > > >Any help would be appreciated > > > >2nd For anyone with any ideas. > > > >I want to use an edit box on the application update data form. To show >a log of the files it copies down and whether each was successful or >not. > >That is working but. When the log reaches the bottom of the edit box >the edit box doesn't automatically scroll. Is there any way I can get >it to do that. > > > >T.I.A. > > > >Peter Hart > >Peter Hart Computers. > Hi Peter, 1) a) Why not zip the data? b) Using Craig Boyds connection FLL, you can send a request and be able to download the data as a zip file. You can either have this on a Web server or in a C# service which hosts a Web API. This will avoid the non-static ip addresses. 2) After you add the new line, to get the edit box to scroll, set the SELSTART property to the LEN(EDITBOX.VALUE). -- Tracy Sent from my Android phone with K-9 Mail. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/fc1b7e90-b9c7-4d49-b812-327bfcf24729@ email.android.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
