ProFox November 2016

profox@leafe.com

55 participants
67 discussions

Re: Dealing with Extraneous Parameters
by Gene Wirchenko 22 Nov '16

22 Nov '16

At 11:56 2016-11-22, Ted Roche <tedroche(a)gmail.com> wrote: >VFP, unlike some languages, is intolerant of excess parameters. To catch this: > >1. Use error handling in the CALLING program, not the CALLED program >with the Parameters statement, or > >2. Write a very tolerant program that accepts all of the parameters >you can throw at it (varies by version) and throws an error after >testing them with PCOUNT(). > >(At one point, I know the number of parameters was 26, since that's >the number of red playing cards in a standard deck. But I think that >limit was raised in the most recent version, as your testing >indicates.) Point 1: this will not work for me since it is a *standalone* program. As to point 2, the parameter limit is rather high. On my system, it was 152! Above 40, I kept getting spurious "Source is out of date" messages and had to explicitly compile my test programs. This odd behaviour was consistent. I also had one case where VFP insisted on holding onto the program, and I could not delete it, even after clear program. VFP is not perfect, but this one is embarrassing. [snipped previous] Sincerely, Gene Wirchenko

1 0

Re: Dealing with Extraneous Parameters
by Gene Wirchenko 22 Nov '16

22 Nov '16

At 10:34 2016-11-22, Gene Wirchenko <genew(a)telus.net> wrote: >Hello: > > I am using VFP 9, but this may apply to many versions. > > I am testing a new printing subsystem. This will require > testing each report with a valid configuration and an invalid > configuration. I wrote a short, standalone program that tweaks the > configuration either way. It is run with ><vfp> > do tmpprint with <number> ></vfp> > > I also wanted to check the parameters. If I do not specify a > parameter, that is an error and one easily caught with pcount(). > > However, if there are more parameters than expected, an error > 94 (Must specify additional parameters.) is thrown on the > lparameters statement. How do I catch this error considering that > nothing gets executed before the lparameters statement is looked at? > > It gets odder. Supposedly lparameters takes up to 26 > parameters. I am now up to 40, and they all get assigned their > specified values. Specifying a 41st parameter in the invocation > throws an error 94. Where does it end? Addendum: In this case, I could break the program up into two programs: one the sets the valid configuration and one that sets an invalid configuration. Neither would require parameters. However, if a parameter is specified to a program without a [l]parameters statement, an error 1234 (No PARAMETER statement is found.) is thrown. (I note the typo in the error message: "PARAMETER" should be "PARAMETERS".) Sincerely, Gene Wirchenko

3 2

RE: Setting >1 Page Orientation in PDFs
by Gene Wirchenko 22 Nov '16

22 Nov '16

At 01:56 2016-11-22, Dave Crozier <DaveC(a)Flexipol.co.uk> wrote: >Gene, >Now I see what you mean... the dynamic size change! Must admit I >have never tried to do this but I'll give it a go and report back Even if you end up telling me that you could not make it go, that would be appreciated. Note that I do reports using set printer on and not .frx. (I use .frx only to set the orientation.) [snipped previous] Sincerely, Gene Wirchenko

1 0

cursor adapter class
by rafael copquin 22 Nov '16

22 Nov '16

Hi folks! The UniversalThread just published my article describing a class that builds a complex cursor adapter that works with SQL Server databases. It is an enhancement to a previous one published in April 2006. That one could only work with a single table in the select statement and then only with DBF's The one published now can contain a complex select statement, involving two or more tables and pulling records from a SQL Server database. You can modify it slightly to make it work with DBF's, as explained in the notes at the end of the article. Here's the link https://www.universalthread.com/ShowHeaderArticleOneItem.aspx?ID=40122 Regards Rafael Copquin

1 0

RE: Setting >1 Page Orientation in PDFs
by Gene Wirchenko 22 Nov '16

22 Nov '16

At 09:21 2016-11-21, Dave Crozier <DaveC(a)Flexipol.co.uk> wrote: >Gene, >You use Fineprint PDF as a standard printer and set your orientation >in the same way you would a printer. That is my problem. I have something that works with a hardcopy printer, but it does not work with the Adobe PDF or Bullzip PDF Printer PDF generators. I would like to know what others do to change the orientation of the PDF output in the middle of a print job. >Another simple solution is to configure two Fineprint printers, one >portrait and one Landscape by setting the preferences on each >printer then simply print to the one you need for the specific job. That is not the issue. I can set the orientation of the printer / PDF pages at the beginning of a print job to portrait or landscape as I wish. What I can not do is change it in the middle of a PDF print job as in: portrait page portrait page portrait page landscape page landscape page portrait page portrait page portrait page >Hope this explains the simplicity of using it. Nope. It seems to me that it should not be so difficult, but I am unable to see where I have gone wrong (or even whether I have and it is a bug in both drivers). [snipped previous] Sincerely, Gene Wirchenko

2 1

RE: Setting >1 Page Orientation in PDFs
by Gene Wirchenko 21 Nov '16

21 Nov '16

At 00:28 2016-11-21, Dave Crozier <DaveC(a)Flexipol.co.uk> wrote: >With Fineprint you simply use the "Fineprint PDF printer" and send >whatever you want to it. You can reformat documents, consolidate >them, watermark them etc etc. > >So, in short as to your question "how do you do it" - the answer is >simple.... you don't need to do anything at all. That is not an answer at all. What you describe in your first paragraph is doing something which belies your second paragraph. You do have to do something. I would like to know what that something is. What do you do to specify that you want a page to be in the other orientation and all within one print job? I think I have a way that should work, but it does not. I do not know if it is my error or the driver's. I need some details. > have used it for many years. [snipped previous] Sincerely, Gene Wirchenko

2 1

[NF] EXTERNAL SSD hard drives
by mbsoftwaresolutions＠mbsoftwaresolutions.com 21 Nov '16

21 Nov '16

Greetings fellow Profoxers! I see some external SSD drives on this page: http://www.newegg.com/External-SSDs/SubCategory/ID-2022?Tid=11694 My laptop is a maybe 4 years old and is running out of local disk space. I've got another laptop I can migrate to but I was thinking of just extending and still using this one yet (because I love it) and using an external HD would take care of my space issues...at least for now...and give me another area to send backups. My question: I know SSD drives are 20x faster reportedly, but would that still apply if it's an EXTERNAL drive? I understand that using the USB 3.0 port is better than the older USB 2.x ports and earlier for transfer rates. tia, --Mike

17 36

RE: Setting >1 Page Orientation in PDFs
by Gene Wirchenko 21 Nov '16

21 Nov '16

At 00:48 2016-11-17, Dave Crozier <DaveC(a)Flexipol.co.uk> wrote: >Fineprint PDF writer does it all automatically plus much, much more >and is not expensive. How do you do it with Fineprint, please? I have code that I think ought to work. It does set the orientation correctly for the first time the orientation is set in a print job. It does not work for subsequent orientation settings in a print job. It fails the same way with two different PDF generators. It is quite possible that I am doing something wrong. (No one has replied with a correct way of how to do it, but that does not guarantee I am correct. (I wish.)) I would rather not get mixed up with yet another PDF generator without a reasonable assurance that it will work. (Besides, the company I am working for already uses Bullzip in other areas.) And maybe seeing your code will give me an idea. [snipped previous] Sincerely, Gene Wirchenko

2 1

Re: define class xx twice
by Gene Wirchenko 18 Nov '16

18 Nov '16

At 15:31 2016-11-18, "Fernando D. Bozzo" <fdbozzo(a)gmail.com> wrote: [snip] >"do someproc in locationx" or "NewObject" does not use nothing "in memory", >because they load from the indicated resource directly, hence, does not >apply, You do not know that. You are guessing. It may be a perfectly reasonable guess, but it is still just a guess. How VFP decides to cache code is nothing I have seen documented. I have occasionally gotten into trouble with this to the point where I have simply closed VFP and restarted it, because I could not get the cache dropped. This includes using clear program. A bug in VFP? Maybe. A bug in my code? Quite possibly. But I have been unable to clear the cache short of closing VFP. [snip] Sincerely, Gene Wirchenko

1 0

Re: define class xx twice
by Gene Wirchenko 18 Nov '16

18 Nov '16

At 00:57 2016-11-18, "Fernando D. Bozzo" <fdbozzo(a)gmail.com> wrote: >Yes, this is the same behaviour as for procedures, the last defined or >loaded overwrites the previous. Maybe. It is undefined behaviour so you can not count on it being one way or the other. >This is because there can't be more than one procedure/class with the same >name on memoty at the same time. A questionable assumption. What about do someproc in locationa do someproc in locationb Since it is not defined exactly what VFP stores in memory codewise, it is not impossible that both could be. >In the case of classes you can use NewObject to select from which library >instantiate a class definition, but for multiple objects this is more >slower than createobject. Having been bit by a duplicate method name some months back, I think there really should be a compiler error message for duplicates. [snipped previous] Sincerely, Gene Wirchenko

2 1

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox November 2016