Re: VFP Advanced (was Fwd: RE: Fatal error issuing CALCULATE command)

/Side by Side/ The important thing to remember is that VFPA *is* VFP9. It's not a different product at all. So everything is going to work pretty much the exact same except those places where he explicitly inserted code fixes. 99.9% is the same code. Eric On Fri, Nov 22, 2019 at 12:43 PM MB

Re: Fatal error issuing CALCULATE command

mp;+ "AVG(Field1)" ? cCalcCmd Return Paul -Original Message- From: ProfoxTech On Behalf Of Alan Bourke Sent: 22 November 2019 12:55 To: profoxt...@leafe.com Subject: Re: Fatal error issuing CALCULATE command Sent by an external sender --

Re: VFP Advanced (was Fwd: RE: Fatal error issuing CALCULATE command)

On 11/22/2019 1:18 PM, Gene Wirchenko wrote: At 15:07 2019-11-21, "MB Software Solutions, LLC"   On 11/21/2019 4:34 PM, Eric Selje wrote:  > The Microsoft of 20 years ago probably would have complained, but they're a > different company now. Their take is basically "If you want to modify

Re: VFP Advanced (was Fwd: RE: Fatal error issuing CALCULATE command)

At 15:07 2019-11-21, "MB Software Solutions, LLC" On 11/21/2019 4:34 PM, Eric Selje wrote: > The Microsoft of 20 years ago probably would have complained, but they're a > different company now. Their take is basically "If you want to modify the > copy of VFP that you paid for, go for

RE: VFP Advanced (was Fwd: RE: Fatal error issuing CALCULATE command)

Dang it! Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy Pearson Sent: Thursday, November 21, 2019 7:24 PM To: profoxt...@leafe.com Subject: RE: VFP Advanced (was Fwd: RE: Fatal error issuing CALCULATE command) Hi Paul, You

RE: VFP Advanced (was Fwd: RE: Fatal error issuing CALCULATE command)

-Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Thursday, November 21, 2019 5:05 PM To: profoxt...@leafe.com Subject: Re: VFP Advanced (was Fwd: RE: Fatal error issuing CALCULATE command) On 11/21/2019 5:09 PM, Paul H. Tarver

Re: Fatal error issuing CALCULATE command

] + cInsertFields +[) VALUES > (0]+cInsertValues+')' > FOR X = 1 TO _rows > > NEXT > cCalcCmd = Left(cCalcCmd,Len(cCalcCmd)-1) + " To " + > Left(cVariables,Len(cVariables)-1) &&+ "AVG(Field1)" > ? cCalcCmd > > Return > > Paul > > -Orig

Re: VFP Advanced (was Fwd: RE: Fatal error issuing CALCULATE command)

>no. > > > >Paul H. Tarver > > > > > >-Original Message- > >From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of > >Eric > >Selje > >Sent: Thursday, November 21, 2019 3:35 PM > >To: profoxt...@leafe.com > >Subject: Re

RE: Fatal error issuing CALCULATE command

-Original Message- From: ProfoxTech On Behalf Of Alan Bourke Sent: 22 November 2019 13:49 To: profoxt...@leafe.com Subject: Re: Fatal error issuing CALCULATE command Sent by an external sender -- There definitely seems to be a limit of 32 as you say. Summing

Re: Fatal error issuing CALCULATE command

es+')' > FOR X = 1 TO _rows > > NEXT > cCalcCmd = Left(cCalcCmd,Len(cCalcCmd)-1) + " To " + > Left(cVariables,Len(cVariables)-1) &&+ "AVG(Field1)" > ? cCalcCmd > > Return > > Paul > > -Original Message- > From: ProfoxTe

RE: Fatal error issuing CALCULATE command

-Original Message- From: ProfoxTech On Behalf Of Alan Bourke Sent: 22 November 2019 12:55 To: profoxt...@leafe.com Subject: Re: Fatal error issuing CALCULATE command Sent by an external sender -- Paul Do you mean you are doing this? calculate sum(field1 + field2

Re: Fatal error issuing CALCULATE command

Paul Do you mean you are doing this? calculate sum(field1 + field2 + ... + field32) to lnTotal -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

RE: Fatal error issuing CALCULATE command

Eric I copied and ran your code and sure enough it errors but with a nesting error Paul -Original Message- From: ProfoxTech On Behalf Of Eric Selje Sent: 21 November 2019 17:59 To: profoxt...@leafe.com Subject: Re: Fatal error issuing CALCULATE command Sent by an external sender

RE: Fatal error issuing CALCULATE command

21, 2019 11:29 AM To: profoxt...@leafe.com Subject: RE: Fatal error issuing CALCULATE command Hi Eric I think that's because the limit is 32 (not 31 as I stated). Try using For x = 1 To 33 and I think you will get the problem. Please let us know Thanks Paul Newton -Original Message- F

RE: VFP Advanced (was Fwd: RE: Fatal error issuing CALCULATE command)

seem to indicate the answer is >no. > >Paul H. Tarver > > >-Original Message- >From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of >Eric >Selje >Sent: Thursday, November 21, 2019 3:35 PM >To: profoxt...@leafe.com >Subject: Re: V

Re: VFP Advanced (was Fwd: RE: Fatal error issuing CALCULATE command)

On 11/21/2019 4:34 PM, Eric Selje wrote: The Microsoft of 20 years ago probably would have complained, but they're a different company now. Their take is basically "If you want to modify the copy of VFP that you paid for, go for it." Yeah, the ballmer days (thankfully) are long gone.  That

Re: VFP Advanced (was Fwd: RE: Fatal error issuing CALCULATE command)

On 11/21/2019 5:09 PM, Paul H. Tarver wrote: This is going to seem like a stupid question I'm sure but is there a way to run VFPA (either 32 or 64 bit) in parallel with VFP9? I'd like to test, but I don't want to mess up my existing development environment. Some of the readme files seem to

RE: VFP Advanced (was Fwd: RE: Fatal error issuing CALCULATE command)

-Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Eric Selje Sent: Thursday, November 21, 2019 3:35 PM To: profoxt...@leafe.com Subject: Re: VFP Advanced (was Fwd: RE: Fatal error issuing CALCULATE command) The Microsoft of 20 years ago probably would have

Re: Fatal error issuing CALCULATE command

One of the features of VFP Advanced (fix 95 ) is that it doubles the length of commands from 8k to 16k. On Thu, Nov 21, 2019 at 2:01 PM Gene Wirchenko wrote: > At 08:17 2019-11-21, Eric Selje wrote: > > [snip] > > Sorry for hijacking

Re: VFP Advanced (was Fwd: RE: Fatal error issuing CALCULATE command)

The Microsoft of 20 years ago probably would have complained, but they're a different company now. Their take is basically "If you want to modify the copy of VFP that you paid for, go for it." VERSION() either returns 10, or not. Almost all of the changes he implemented can be turned off with

Re: VFP Advanced (was Fwd: RE: Fatal error issuing CALCULATE command)

On 11/21/2019 2:54 PM, Eric Selje wrote: VFP 10 (or VFP Advanced) is a copy of your licensed copy of VFP9, with some binary patches to fix bugs and add features. There's *also* a 64-bit version. Yes, I use it every day, along with 1000's of others. My opinion is that there's no reason every VFP

Re: VFP Advanced (was Fwd: RE: Fatal error issuing CALCULATE command)

On 11/21/2019 2:54 PM, Eric Selje wrote: VFP 10 (or VFP Advanced) is a copy of your licensed copy of VFP9, with some binary patches to fix bugs and add features. There's *also* a 64-bit version. Yes, I use it every day, along with 1000's of others. My opinion is that there's no reason every VFP

Re: Fatal error issuing CALCULATE command

At 08:17 2019-11-21, Eric Selje wrote: [snip] Sorry for hijacking your post, Eric, but the original post did not make it to me. On Thu, Nov 21, 2019 at 9:50 AM Paul Newton wrote: > Hi all > > I think I have come across a possibly undocumented limitation to the > maximum number of

Re: VFP Advanced (was Fwd: RE: Fatal error issuing CALCULATE command)

VFP 10 (or VFP Advanced) is a copy of your licensed copy of VFP9, with some binary patches to fix bugs and add features. There's *also* a 64-bit version. Yes, I use it every day, along with 1000's of others. My opinion is that there's no reason every VFP developer should not. Eric On Thu, Nov

VFP Advanced (was Fwd: RE: Fatal error issuing CALCULATE command)

Forwarded Message Subject: RE: Fatal error issuing CALCULATE command Date: Thu, 21 Nov 2019 13:04:20 -0500 From: Tracy Pearson Reply-To: ProFox Email List To: profox@leafe.com Eric, Now, is that in VFP 9 SP 2, or VFP Advanced

Re: VFP Advanced (was Fwd: RE: Fatal error issuing CALCULATE command)

On 11/21/2019 2:42 PM, MB Software Solutions, LLC wrote: Is Anybody using "VFP Advanced" here?  IIRC, that's the Chinese VFP 10 version for 64-bit...correct? (Anybody other than Eric, I mean.) ___ Post Messages to: ProFox@leafe.com Subscription

Re: Fatal error issuing CALCULATE command

2, or VFP Advanced? > > Tracu > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Eric > Selje > Sent: Thursday, November 21, 2019 12:59 PM > To: profoxt...@leafe.com > Subject: Re: Fatal error issuing CALCULATE command

RE: Fatal error issuing CALCULATE command

Eric, Now, is that in VFP 9 SP 2, or VFP Advanced? Tracu -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Eric Selje Sent: Thursday, November 21, 2019 12:59 PM To: profoxt...@leafe.com Subject: Re: Fatal error issuing CALCULATE command This tweak

Re: Fatal error issuing CALCULATE command

ds are you SUMming? > > Tracy > > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul > Newton > Sent: Thursday, November 21, 2019 11:29 AM > To: profoxt...@leafe.com > Subject: RE: Fatal error issuing CALCULATE command >

RE: Fatal error issuing CALCULATE command

To: profoxt...@leafe.com Subject: Re: Fatal error issuing CALCULATE command Sent by an external sender -- Interesting. I whipped up this test and cannot replicate the problem: CREATE CURSOR crsTest (id i) cCmd = [CALCULATE ] FOR x = 1 TO 32 cField = "Field"+T

RE: Fatal error issuing CALCULATE command

Subject: Re: Fatal error issuing CALCULATE command Sent by an external sender -- Interesting. I whipped up this test and cannot replicate the problem: CREATE CURSOR crsTest (id i) cCmd = [CALCULATE ] FOR x = 1 TO 32 cField = "Field"+TRANSFORM(x) A

Re: Fatal error issuing CALCULATE command

Interesting. I whipped up this test and cannot replicate the problem: CREATE CURSOR crsTest (id i) cCmd = [CALCULATE ] FOR x = 1 TO 32 cField = "Field"+TRANSFORM(x) ALTER table crsTest ADD COLUMN (cField) I cCmd = cCmd + "SUM("+cField+")," NEXT cCmd = cCmd + "AVG(Field1)" On Thu, Nov