A company I consult for took over a complex VFP program still used in the Shutter manufacturing industry. One report in particular has me stumped: the report contains several very small two-letter captions (eg TP). When the report is called, those captions somehow turn into images or drawings...
that is good advice Chris, I may give it a go and see how 'close' it comes to compiling. I know the current owners of the program are not that keen on devoting much man-power to keeping it going, the whole point was to obtain the client base and develop a new version of the program. Not...
those were very informative, and it does explain why the previous programmer (I inherited her program) structured it the way she did. With about 50 clients, all with different Report needs, not including the reports makes sense since modifications and bug fixes only require the single report be...
I've always created a new .exe file whenever I make even the slighest change in any file (prg, frm, rpt), since it only takes a few seconds to re-compile everything. But I realize that if I change a .prg which is called via a DO command, I dont have to create a new .exe (could just send out the...
I finally have something to contribute here. The pre-check routine ran slow (13 minutes) and the next attempt wasnt much better. So I tried the sys(2000) statement in place of Adir, and indeed that does read in the directory very fast( 1 second, although Adir was not bad at 5-10 seconds). But...
this thread certainly grew a lot :) I have not needed to test any of the methods supplied as of yet (thanks to all for their contributions) since running the little 'pre-check' routine (which takes about 9 minutes) followed by an immediate 2nd run of it (which takes as little as 30 seconds)...
now I have to wait for it to perform slowly so that I can try these suggestions. I forgot to mention an important point: I have a 10-line routine that cycles thru and simply opens each table. The first time thru it is always slow, taking upwards of 9 minutes. But often the 2nd time I run it, it...
thanks for that offer, hopefully not needed with these suggestions - but I will take you up on that if needed. I run the .prg in the Command Window. I could turn it into an .exe of its own, I have several minor variations of this .prg so if creating an .exe did solve the poor performance I...
thanks for replying. I do use Adir(). The sys(2000) is something I will try the next time it goes 'slow' (I kind of mimicked that in the past by doing a Dir and importing all 90,000 filenames into a different table, and then using that table to get each .dbf - did not help the issue). The...
I have about 90,000 dbf files in a single folder. They contain from 0 to 100 records, but generally 5-20. I have a .prg file that cycles thru all the tables and does some processing based on contents. The problem/puzzle is that sometimes this .prg file can go thru all 90,000 in about 1 minute...
Thanks, I knew there had to be a solution but would have taken a lot of time finding it. I've seen the DODEFAULT() in some other code, now I know exactly what it means.
This one has always perplexed me - it seems if I put something in the Click method then the Next button loses it's functionality (ie advance to next record). Is that true? How then does one note if the Next button has been clicked? I need to know that, yet if I set a variable in the Click...
I like Olaf's solution of using RD to connect (multiple) users, which gets around this apparent Oplock issue. And certainly it should be easy to automatically open the Foxpro program upon connection. The final issue would be making sure the user is forced off the RD connection (and therefore...
thank you Olaf. Your reply seems to imply that one user will still experience good response times if he/she was 1st in using a DBF. But what they are describing to me is that as soon as a 2nd person opens the program and begins to interact with the tables, both users experience a slow down...
Hopefully Olaf or the other experts can offer their opinion on this. Quick background: I took over an unfinished VFP 9 program and did some fairly minor modifications. The program apparently could (in the past) work well with several users at once. Now when a 2nd user opens the program both...
I had not noticed that I inadvertently Included a couple of (large) free tables in the project - I certainly don't recall intentionally doing so. I recall Olaf mentioned the symbol for Include in a prior email but that didn't occur to me. Once removed, the .exe is back to the proper size - and...
I will investigate those possibilities. Thanks as always for your input. Fortunately even if I cannot figure it out the program runs fine and does not seem to take any longer to load.
I took over a VPF 9 project, the original program was about 95% complete and had some errors. The .exe file size was about 3.3 megs. I've added a few things to the program, fixed the errors ... and somewhere along the line the new compiled .exe became 15 megs. I can't recall when this...
these are good things for me to save if I want to convince the owner he needs to go further than what we are currently envisioning :). Blocking via simple methods to snoop for files (no installation of programs) is a start, and a registry change can forbid users from seeing hidden folders...
If I can read correctly, the file is in a directory called x:\hidden\data\...
Does the hidden directory have the hidden attribute set?
VFP will respect that."
the HIDDEN directory is of course hidden, the DATA folder is not (originally was set as hidden mistakenly, but now unchecked). A...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.