ProFox November 2016

profox@leafe.com

55 participants
67 discussions

Report listeners and MSXML4
by Paul Newton 24 Nov '16

24 Nov '16

Hi all ReportListeners.H contains (amongst many others) the following DEFINEs #DEFINE OUTPUTXML_DOMFREETHREADED_DOCUMENTOBJECT "Msxml2.FreeThreadedDOMDocument.4.0" #DEFINE OUTPUTXML_XSLT_PROCESSOROBJECT "Msxml2.XSLTemplate.4.0" These are used/referenced in the following classes/methods In the HTMLListener class FillRunCollector In the XMLListener class FillRunCollector GetRunNodeContents BeforeReport ApplyXLST LoadProcessorObject GetVFPRDLContents AdjustXLSTParameter MSXML4 is no longer supported and, apparently, has a security vulnerability. I have removed it from my system but I need to know if any of these methods will ever be invoked from/by our application. So far I have been unable to find under what circumstances one or more of these methods might be invoked. Any ideas? Sample code? BTW, having removed MSXML4, CreateObject("Msxml2.FreeThreadedDOMDocument.4.0") and CreateObject("Msxml2.XSLTemplate.4.0") both give a "Class not registered" error which I expected. I did wonder whether it would be safe to remove the .4.0 from the DEFINEs. Doing so _does_ allow me to create the objects without error. Many thanks Paul Newton

2 3

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

24 Nov '16

At 09:01 2016-11-23, Ted Roche <tedroche(a)gmail.com> wrote: >No, the short answer is you set up 152 parameters on the LPARAMETERS >line and throw the error of your choice if you don't like PCOUNT(). Well, no, because if someone passes 153 or more parameters, VFP throws "Allowed DO nesting or expression evaluation limit reached." It is turtles all the way down, and the last ones snap. [snip] Sincerely, Gene Wirchenko

2 1

Weird font behavior on project tabs, table designer, etc.
by Fletcher Johnson 23 Nov '16

23 Nov '16

Hi all, Recently installed VFP 9, SP2 on a new laptop. When I run VFP and open a project, the text for the project tabs (all, data, document.) are quite large. This is also true of the tabs and column data (both titles - name, type, width. and data - field name, character, .) For the life of me, I can't figure out where it found the font. I checked options, the registry entry, etc. but can't find anything that seems out of place. It sort of looks like the "expanded" font on old Epson printers. The VFP menu is fine as is the data in the properties windows (although the tabs are screwed up). The command window and text going to the screen all appears as expected. The problem is that VFP doesn't account for the size of this weird font and many labels now overwrite each other or are hidden by the respective data entry textbox, etc. Any idea what is farkled up and how to fix it? Thanks, Fletcher Fletcher Johnson <mailto:FletcherSJohnson@Yahoo.com> FletcherSJohnson(a)Yahoo.com <http://linkedin.com/in/FletcherJohnson> LinkedIn.com/in/FletcherJohnson <http://beknown.com/FletcherJohnson> beknown.com/FletcherJohnson twitter.com/fletcherJ <https://www.strava.com/athletes/fletcherjohnson> strava.com/athletes/fletcherjohnson 408-946-0960 - work 408-781-2345 - cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 7

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

23 Nov '16

At 04:07 2016-11-23, Ted Roche <tedroche(a)gmail.com> wrote: >On Wed, Nov 23, 2016 at 4:39 AM, Paul Newton ><Paul.Newton(a)pegasus.co.uk> wrote: > > Microsoft Visual FoxPro 9 SP2 Help file, VFPX Edition v1.06 states > > > > PARAMETERS ParameterList > > Specifies one or more variable or array names to assign data to. > Use commas to separate multiple parameters in ParameterList. > Generally, you can pass a maximum of 26 parameters; however, in > some circumstances, you can pass 27 parameters. > >Yeah, I'm pretty sure they cribbed that from the Hacker's Guide :) I >remember testing that. That was the limit for VFP6/7, but VFP9 appears >to have a much higher limit. 152 by my testing, but this is irrelevant. What practically everyone has missed is this is *NOT*, repeat *NOT*, about how to pass a lot of parameters. Using a parameters object is irrelevant. Take a look at the title of the thread: Dealing with Extraneous Parameters If a caller passes too many parameters to a procedure, how do you handle the situation in the procedure? The short answer appears to be that you can not. Sincerely, Gene Wirchenko

2 1

RE: Dealing with Extraneous Parameters
by Gene Wirchenko 23 Nov '16

23 Nov '16

At 00:34 2016-11-23, Dave Crozier <DaveC(a)Flexipol.co.uk> wrote: >Gene, >Am I missing something here or couldn't you pass a Parameter Object >in which all your parameters become properties? This would allow you >a limitless number of parameters and also be interface independent. Yes, you are missing something. What I wanted -- I have given up on it -- was to be able to check that the number of parameters passed was correct. The case that I ran into trouble with is when too many parameters are passed. Suppose a procedure takes three parameters and four are passed. It would be nice to be able to detect this in the procedure, but instead an error is thrown. This happens before anything in the procedure is executed. Yes, you could put that detection in the caller, but then, why not just call correctly? Plus this does not work if the procedure is standalone which is what I wanted. [snip] Sincerely, Gene Wirchenko

1 0

RE: Dealing with Extraneous Parameters
by Gene Wirchenko 23 Nov '16

23 Nov '16

At 12:34 2016-11-22, "Michael Glassman" <MHGlassman(a)PioneerDrama.com> wrote: >Have you thought about passing your parameters in a single array, Gene? >That way you can test to see if you have received the correct number of >parameters using alen() and empty(). It was a *standalone* program. The idea was to invoke it easily, such as in one line. It took only one parameter. I just wanted to detect if too many parameters were passed to it. As far as I can see, VFP does not allow this sort of checking in a general way. The number of parameters is limited, but it seems it is way more than 26. On my system, it is 152. Yes, each parameter got its correct value. [snip] Sincerely, Gene Wirchenko

3 3

Do you rebuild your indexes every night or do you leave them alone.
by Michael Madigan 23 Nov '16

23 Nov '16

I've been rebuilding indexes every night, does it really make a difference? How many people rebuild each night and how many leave it alone?

18 42

[NF] Qarbon Viewletbuilder, TechSmith Camtasia, others?, ...for presentation demos
by Brant E. Layton 23 Nov '16

23 Nov '16

Hi All, I've been doing a lot of remote training using GoToMeeting. You can record sessions there, and then the recording converts to an MP4. If you don't need to see your face, but just your screen, that might work, too. You could create an Index or Table of Contents showing subjects and time markers... I think you need a paid account to make the recordings, but it is very inexpensive. Just a thought.|| || |Brant Layton| |480.964.1316| --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 1

Dealing with Extraneous Parameters
by Gene Wirchenko 23 Nov '16

23 Nov '16

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? Sincerely, Gene Wirchenko

4 3

[NF] SQL Server for Linux
by Paul Hill 22 Nov '16

22 Nov '16

Hi All, Just tried this on a Ubuntu VM. Got it up and running with no problems. Our main C# app ran without changes. The database restore option failed (path/rights problem I think) but an import from our old version (DBFs) worked fine (this is quite a hefty process). Not sure what the licensing etc will be. It will be interesting if they release an SQL Express version. SQL Server vNext CTP1 on Ubuntu 16.04.: https://docs.microsoft.com/en-gb/sql/linux/sql-server-linux-setup-ubuntu -- Paul

5 7

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox November 2016