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

2019-11-22 Thread Eric Selje 
/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 Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> 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 the > copy of VFP that you paid for, go for it."
> >
> >>  Yeah, the ballmer days (thankfully) are long gone.  That guy sucked.
> >
> >  What did he suck?  Donkey balls?
> >   https://donkeyballstore.com/
> >
> >
>
> I'd be all for sending him a huge pile of dung: https://poopsenders.com/
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/CAAwxvU=Or3cN6Q32KF-mhwU1VUZiK3_3aSTX3Y=gkjgxwqz...@mail.gmail.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.

Re: Fatal error issuing CALCULATE command

2019-11-22 Thread Frank Cazabon 

That's interesting, I wonder if this is documented in the Hacker's Guide.

I have to admit that in my 28 years of using VFP I've never used CALCULATE.

Frank.

Frank Cazabon

On 22/11/2019 12:24 PM, Eric Selje wrote:

Yes, Paul, that now makes my system crash with Fatal Error too in VFP9 and
VFPA.

On Fri, Nov 22, 2019 at 6:59 AM Paul Newton 
wrote:


No Alan - the following code (adapted from Eric) demonstrates exactly what
I am doing:

#DEFINE _fields 35
#DEFINE _rows 100
=RAND(-1)
CREATE CURSOR crsTest (id i)
cCalcCmd = [CALCULATE ]
cInsertFields = []
cInsertValues = []
cVariables = []
FOR x = 1 TO _fields
cField = "Field"+TRANSFORM(x)
ALTER table crsTest ADD COLUMN (cField) I
cCalcCmd = cCalcCmd + "SUM("+cField+"),"
cInsertFields = cInsertFields + ","+cField
cInsertValues = cInsertValues + ","+TRANS(INT(RAND()*100))
cVariables = cVariables + "lc"+cField+","
NEXT
cInsertCmd = [INSERT INTO crsTest (ID ] + 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

-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 + ...  + field32) to lnTotal



--
   Alan Bourke
   alanpbourke (at) fastmail (dot) fm


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/e3860082-6f47-86c8-0cbc-c268f1637...@gmail.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.

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

2019-11-22 Thread MB Software Solutions, LLC 

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 the > copy of VFP that you paid for, go for it."



 Yeah, the ballmer days (thankfully) are long gone.  That guy sucked.


 What did he suck?  Donkey balls?
  https://donkeyballstore.com/




I'd be all for sending him a huge pile of dung: https://poopsenders.com/


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/63c48211-330d-3f9c-faac-322d0e0ea...@mbsoftwaresolutions.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.

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

2019-11-22 Thread Gene Wirchenko 

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 it."



 Yeah, the ballmer days (thankfully) are long gone.  That guy sucked.


 What did he suck?  Donkey balls?
  https://donkeyballstore.com/

Sincerely,

Gene Wirchenko


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: https://leafe.com/archives/byMID/
** 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.

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

2019-11-22 Thread Paul H. Tarver 
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 missed Eric's SWFox presentation. 
You can have VFP 9 SP 2, VFP Advanced, and VFP Advanced 64bit running on the
same machine. Eric didn't say you needed to change anything. Here did have
both VFP 9 and Advanced running at the same time.

Tracy


On November 21, 2019 5:09:27 PM EST, "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 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: 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 settings for maximum backwards
>compatibility.
>
>On Thu, Nov 21, 2019 at 2:07 PM MB Software Solutions, LLC <
>mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
>
>> 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 developer should not.
>> >
>> > Eric
>>
>>
>> I was surprised that M$ didn't send out a "cease and desist" or some
>> such action for it.  Morally and ethically, there's nothing wrong
>with
>> it from what I can tell, but you recall the HUGE STINK they put up
>when
>> Whil Hentzen was going to show VFP running on WINE.  I can't see the
>> harm in that either, for that matter.  If that increases M$'s VFP
>sales,
>> GREAT!  (Yes, that's laughable to say...cue the quote by BG about
>every
>> time VFP was sold, they lost $20,000 or something on SQL Server
>sales.)
>>
>>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/008101d5a15a$80f33a10$82d9ae30$@tpcqpc.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.

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

2019-11-22 Thread Paul H. Tarver 
Actually, I have a virtual machine I could do that on, I was just thinking
it would be easier to do side-by-side comparisons. One thing is certain,
doing the first install on a virtual machine is definitely probably the way
to start as the instructions are a bit vague. :)

Paul H. Tarver

-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 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 indicate the answer is no.
>
> Paul H. Tarver


Time for that 2nd laptop (Or Virtual Machine), Paul.


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/008201d5a15a$810402f0$830c08d0$@tpcqpc.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.

Re: Fatal error issuing CALCULATE command

2019-11-22 Thread Eric Selje 
Yes, Paul, that now makes my system crash with Fatal Error too in VFP9 and
VFPA.

On Fri, Nov 22, 2019 at 6:59 AM Paul Newton 
wrote:

> No Alan - the following code (adapted from Eric) demonstrates exactly what
> I am doing:
>
> #DEFINE _fields 35
> #DEFINE _rows 100
> =RAND(-1)
> CREATE CURSOR crsTest (id i)
> cCalcCmd = [CALCULATE ]
> cInsertFields = []
> cInsertValues = []
> cVariables = []
> FOR x = 1 TO _fields
>cField = "Field"+TRANSFORM(x)
>ALTER table crsTest ADD COLUMN (cField) I
>cCalcCmd = cCalcCmd + "SUM("+cField+"),"
>cInsertFields = cInsertFields + ","+cField
>cInsertValues = cInsertValues + ","+TRANS(INT(RAND()*100))
>cVariables = cVariables + "lc"+cField+","
> NEXT
> cInsertCmd = [INSERT INTO crsTest (ID ] + 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
>
> -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 + ...  + field32) to lnTotal
>
>
>
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/CAAwxvU=+RCvfxrD=C_+0k8TY52b6YYXzisPNWJ3E8+YgNH=r...@mail.gmail.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.

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

2019-11-22 Thread Eric Selje 
Yep, they don't mess with each other at all unless you have VFPA take over
your file extensions for .app files, etc.

On Thu, Nov 21, 2019 at 7:24 PM Tracy Pearson  wrote:

> Hi Paul,
>
> You missed Eric's SWFox presentation.
> You can have VFP 9 SP 2, VFP Advanced, and VFP Advanced 64bit running on
> the same machine. Eric didn't say you needed to change anything. Here did
> have both VFP 9 and Advanced running at the same time.
>
> Tracy
>
>
> On November 21, 2019 5:09:27 PM EST, "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 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: 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 settings for maximum backwards
> >compatibility.
> >
> >On Thu, Nov 21, 2019 at 2:07 PM MB Software Solutions, LLC <
> >mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
> >
> >> 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 developer should not.
> >> >
> >> > Eric
> >>
> >>
> >> I was surprised that M$ didn't send out a "cease and desist" or some
> >> such action for it.  Morally and ethically, there's nothing wrong
> >with
> >> it from what I can tell, but you recall the HUGE STINK they put up
> >when
> >> Whil Hentzen was going to show VFP running on WINE.  I can't see the
> >> harm in that either, for that matter.  If that increases M$'s VFP
> >sales,
> >> GREAT!  (Yes, that's laughable to say...cue the quote by BG about
> >every
> >> time VFP was sold, they lost $20,000 or something on SQL Server
> >sales.)
> >>
> >>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/CAAwxvU=-fuc+xc9xw1t+tbebhpk9axhark88vt2zqeq_t7c...@mail.gmail.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.

RE: Fatal error issuing CALCULATE command

2019-11-22 Thread Paul Newton 
Hi Alan

Yes it only seems to be when summing to variables.  Changing it to an array 
would necessitate further changes elsewhere.
I have changed the code to allow a maximum of 32 and if it exceeds 32 I 
construct another second command to deal with the rest of the fields/variables.

Paul


-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 into an array as 
per below works for > 32 fields but I don't know if that would help.

#DEFINE _fields 35
#DEFINE _rows 100
Clear
=RAND(-1)
CREATE CURSOR crsTest (id i)
cCalcCmd = [CALCULATE ]
cCalcCmd2 = [ SUM ]
cCalcCmd3 = ""
cTemp = ""
cInsertFields = []
cInsertValues = []
cVariables = []
FOR x = 1 TO _fields
   cField = "Field"+TRANSFORM(x)
   ALTER table crsTest ADD COLUMN (cField) I
   cCalcCmd = cCalcCmd + "SUM("+cField+"),"
   cCalcCmd2 = cCalcCmd2 + cField + ","
   cTemp = cTemp + cField + ","
   cInsertFields = cInsertFields + ","+cField
   cInsertValues = cInsertValues + ","+TRANS(INT(RAND()*100)) 
   cVariables = cVariables + "lc"+cField+","
NEXT
cInsertCmd = [INSERT INTO crsTest (ID ] + cInsertFields +[) VALUES 
(0]+cInsertValues+')'
FOR X = 1 TO _rows
   
Next
lcVars = Left(cVariables,Len(cVariables)-1)
cCalcCmd = Left(cCalcCmd,Len(cCalcCmd)-1) + " To " + 
Left(cVariables,Len(cVariables)-1) &&+ "AVG(Field1)"
cCalcCmd2 = Left(cCalcCmd2,Len(cCalcCmd2)-1) + " To " + 
Left(cVariables,Len(cVariables)-1)
cTemp = Left(cTemp,Len(cTemp)-1)
*? cCalcCmd
*? cCalcCmd2
? cTemp
? lcVars
=StrToFile(cCalcCmd + Chr(13) + Chr(13) + cCalcCmd2, "c:\temp\cmd.txt") ? 
Len(cCalcCmd2) *
*
Sum  to array laTots
List Memory like laTots
Return





--
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm

On Fri, 22 Nov 2019, at 12:59 PM, Paul Newton wrote:
> No Alan - the following code (adapted from Eric) demonstrates exactly 
> what I am doing:
> 
> #DEFINE _fields 35
> #DEFINE _rows 100
> =RAND(-1)
> CREATE CURSOR crsTest (id i)
> cCalcCmd = [CALCULATE ]
> cInsertFields = []
> cInsertValues = []
> cVariables = []
> FOR x = 1 TO _fields
>cField = "Field"+TRANSFORM(x)
>ALTER table crsTest ADD COLUMN (cField) I
>cCalcCmd = cCalcCmd + "SUM("+cField+"),"
>cInsertFields = cInsertFields + ","+cField
>cInsertValues = cInsertValues + ","+TRANS(INT(RAND()*100)) 
>cVariables = cVariables + "lc"+cField+","
> NEXT
> cInsertCmd = [INSERT INTO crsTest (ID ] + 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
> 
> -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 + ...  + field32) to lnTotal
> 
> 
> 
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
> 
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/by5pr02mb68528f9b6b1e73a4b2517fd9a1...@by5pr02mb6852.namprd02.prod.outlook.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.

Re: Fatal error issuing CALCULATE command

2019-11-22 Thread Alan Bourke 
There definitely seems to be a limit of 32 as you say. Summing into an array as 
per below works for > 32 fields but I don't know if that would help.

#DEFINE _fields 35
#DEFINE _rows 100
Clear 
=RAND(-1)
CREATE CURSOR crsTest (id i)
cCalcCmd = [CALCULATE ]
cCalcCmd2 = [ SUM ]
cCalcCmd3 = ""
cTemp = ""
cInsertFields = []
cInsertValues = []
cVariables = []
FOR x = 1 TO _fields
   cField = "Field"+TRANSFORM(x)
   ALTER table crsTest ADD COLUMN (cField) I
   cCalcCmd = cCalcCmd + "SUM("+cField+"),"
   cCalcCmd2 = cCalcCmd2 + cField + ","
   cTemp = cTemp + cField + ","
   cInsertFields = cInsertFields + ","+cField
   cInsertValues = cInsertValues + ","+TRANS(INT(RAND()*100)) 
   cVariables = cVariables + "lc"+cField+","
NEXT 
cInsertCmd = [INSERT INTO crsTest (ID ] + cInsertFields +[) VALUES 
(0]+cInsertValues+')'
FOR X = 1 TO _rows
   
Next
lcVars = Left(cVariables,Len(cVariables)-1) 
cCalcCmd = Left(cCalcCmd,Len(cCalcCmd)-1) + " To " + 
Left(cVariables,Len(cVariables)-1) &&+ "AVG(Field1)"
cCalcCmd2 = Left(cCalcCmd2,Len(cCalcCmd2)-1) + " To " + 
Left(cVariables,Len(cVariables)-1)
cTemp = Left(cTemp,Len(cTemp)-1)
*? cCalcCmd
*? cCalcCmd2
? cTemp
? lcVars
=StrToFile(cCalcCmd + Chr(13) + Chr(13) + cCalcCmd2, "c:\temp\cmd.txt")
? Len(cCalcCmd2)
*
*
Sum  to array laTots
List Memory like laTots
Return





-- 
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm

On Fri, 22 Nov 2019, at 12:59 PM, Paul Newton wrote:
> No Alan - the following code (adapted from Eric) demonstrates exactly 
> what I am doing:
> 
> #DEFINE _fields 35
> #DEFINE _rows 100
> =RAND(-1)
> CREATE CURSOR crsTest (id i)
> cCalcCmd = [CALCULATE ]
> cInsertFields = []
> cInsertValues = []
> cVariables = []
> FOR x = 1 TO _fields
>cField = "Field"+TRANSFORM(x)
>ALTER table crsTest ADD COLUMN (cField) I
>cCalcCmd = cCalcCmd + "SUM("+cField+"),"
>cInsertFields = cInsertFields + ","+cField
>cInsertValues = cInsertValues + ","+TRANS(INT(RAND()*100)) 
>cVariables = cVariables + "lc"+cField+","
> NEXT 
> cInsertCmd = [INSERT INTO crsTest (ID ] + 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
> 
> -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 + ...  + field32) to lnTotal
> 
> 
> 
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
> 
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/e8f58ea6-4439-4b7a-b523-1a8674dc3...@www.fastmail.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.

RE: Fatal error issuing CALCULATE command

2019-11-22 Thread Paul Newton 
No Alan - the following code (adapted from Eric) demonstrates exactly what I am 
doing:

#DEFINE _fields 35
#DEFINE _rows 100
=RAND(-1)
CREATE CURSOR crsTest (id i)
cCalcCmd = [CALCULATE ]
cInsertFields = []
cInsertValues = []
cVariables = []
FOR x = 1 TO _fields
   cField = "Field"+TRANSFORM(x)
   ALTER table crsTest ADD COLUMN (cField) I
   cCalcCmd = cCalcCmd + "SUM("+cField+"),"
   cInsertFields = cInsertFields + ","+cField
   cInsertValues = cInsertValues + ","+TRANS(INT(RAND()*100)) 
   cVariables = cVariables + "lc"+cField+","
NEXT 
cInsertCmd = [INSERT INTO crsTest (ID ] + 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

-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 + ...  + field32) to lnTotal



--
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/by5pr02mb6852482c0956b722d1047639a1...@by5pr02mb6852.namprd02.prod.outlook.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.

Re: Fatal error issuing CALCULATE command

2019-11-22 Thread Alan Bourke 
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: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/ab3d07d7-2285-43eb-b0ab-3c6b07fb7...@www.fastmail.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.

RE: Fatal error issuing CALCULATE command

2019-11-22 Thread Paul Newton 
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
--

This tweak adds rows so there's something to actually calculate. I tried it 
with many variations on fields and rows and cannot get it to crash.

#DEFINE _fields 35
#DEFINE _rows 100
=RAND(-1)
CREATE CURSOR crsTest (id i)
cCalcCmd = [CALCULATE ]
cInsertFields = []
cInsertValues = []
FOR x = 1 TO _fields
   cField = "Field"+TRANSFORM(x)
   ALTER table crsTest ADD COLUMN (cField) I
   cCalcCmd = cCalcCmd + "SUM("+cField+"),"
   cInsertFields = cInsertFields + ","+cField
   cInsertValues = cInsertValues + ","+TRANS(INT(RAND()*100)) NEXT cInsertCmd = 
[INSERT INTO crsTest (ID ] + cInsertFields +[) VALUES (0]+cInsertValues+')'
FOR X = 1 TO _rows
   
NEXT
cCalcCmd = cCalcCmd + "AVG(Field1)"




On Thu, Nov 21, 2019 at 11:37 AM Tracy Pearson 
wrote:

> Paul,
> There is no data in the cursor he created.
> How many records 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
>
> 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-----
> From: ProfoxTech  On Behalf Of Eric 
> Selje
> Sent: 21 November 2019 16:17
> 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"+TRANSFORM(x)
>ALTER table crsTest ADD COLUMN (cField) I
>cCmd = cCmd + "SUM("+cField+"),"
> NEXT
> cCmd = cCmd + "AVG(Field1)"
> 
>
>
> 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 expressions in a CALCULATE command.  In my case a 
> > fatal error occurred when trying to CALCULATE the SUMs of 32 
> > different fields in a cursor.  It took a while to establish what was 
> > going on, but when I reduced the number of expressions to 31 the 
> > error no longer
> occurred.
> >
> > Has anybody else encountered this issue?  Many thanks
> >
> > Paul Newton
> >
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/by5pr02mb6852cfeaf7d2144356db5fcaa1...@by5pr02mb6852.namprd02.prod.outlook.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.

RE: Fatal error issuing CALCULATE command

2019-11-22 Thread Paul Newton 
Hi Tracy
The problem doesn't lie in the number of records being SUMmed but in the number 
of fields being SUMmed being > 32
Paul

-Original Message-
From: ProfoxTech  On Behalf Of Tracy Pearson
Sent: 21 November 2019 17:37
To: profoxt...@leafe.com
Subject: RE: Fatal error issuing CALCULATE command

Sent by an external sender
--

Paul,
There is no data in the cursor he created. 
How many records 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

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-
From: ProfoxTech  On Behalf Of Eric Selje
Sent: 21 November 2019 16:17
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"+TRANSFORM(x)
   ALTER table crsTest ADD COLUMN (cField) I
   cCmd = cCmd + "SUM("+cField+"),"
NEXT
cCmd = cCmd + "AVG(Field1)"



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 expressions in a CALCULATE command.  In my case a 
> fatal error occurred when trying to CALCULATE the SUMs of 32 different 
> fields in a cursor.  It took a while to establish what was going on, 
> but when I reduced the number of expressions to 31 the error no longer
occurred.
>
> Has anybody else encountered this issue?  Many thanks
>
> Paul Newton
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/by5pr02mb6852967671f4e0227f21decca1...@by5pr02mb6852.namprd02.prod.outlook.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.

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

2019-11-21 Thread Tracy Pearson 
Hi Paul,

You missed Eric's SWFox presentation. 
You can have VFP 9 SP 2, VFP Advanced, and VFP Advanced 64bit running on the 
same machine. Eric didn't say you needed to change anything. Here did have both 
VFP 9 and Advanced running at the same time.

Tracy


On November 21, 2019 5:09:27 PM EST, "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 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: 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 settings for maximum backwards
>compatibility.
>
>On Thu, Nov 21, 2019 at 2:07 PM MB Software Solutions, LLC <
>mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
>
>> 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 developer should not.
>> >
>> > Eric
>>
>>
>> I was surprised that M$ didn't send out a "cease and desist" or some
>> such action for it.  Morally and ethically, there's nothing wrong
>with
>> it from what I can tell, but you recall the HUGE STINK they put up
>when
>> Whil Hentzen was going to show VFP running on WINE.  I can't see the
>> harm in that either, for that matter.  If that increases M$'s VFP
>sales,
>> GREAT!  (Yes, that's laughable to say...cue the quote by BG about
>every
>> time VFP was sold, they lost $20,000 or something on SQL Server
>sales.)
>>
>>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/520036ab-a1c5-4a42-839a-2a43a3ac2...@powerchurch.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.

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

2019-11-21 Thread 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 it."



Yeah, the ballmer days (thankfully) are long gone.  That guy sucked.

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/ae80d381-ab54-4489-f163-b04f90b13...@mbsoftwaresolutions.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.

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

2019-11-21 Thread MB Software Solutions, LLC 

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 indicate the answer is no.

Paul H. Tarver



Time for that 2nd laptop (Or Virtual Machine), Paul.


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/6b191dae-cfcb-cd7e-861b-d09c32152...@mbsoftwaresolutions.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.

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

2019-11-21 Thread Paul H. Tarver 
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 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: 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 settings for maximum backwards
compatibility.

On Thu, Nov 21, 2019 at 2:07 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> 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 developer should not.
> >
> > Eric
>
>
> I was surprised that M$ didn't send out a "cease and desist" or some
> such action for it.  Morally and ethically, there's nothing wrong with
> it from what I can tell, but you recall the HUGE STINK they put up when
> Whil Hentzen was going to show VFP running on WINE.  I can't see the
> harm in that either, for that matter.  If that increases M$'s VFP sales,
> GREAT!  (Yes, that's laughable to say...cue the quote by BG about every
> time VFP was sold, they lost $20,000 or something on SQL Server sales.)
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/012201d5a0b8$57a49c50$06edd4f0$@tpcqpc.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.

Re: Fatal error issuing CALCULATE command

2019-11-21 Thread Eric Selje 
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 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 expressions in a CALCULATE command.  In my case a
> fatal
> > > error occurred when trying to CALCULATE the SUMs of 32 different
> fields in
> > > a cursor.  It took a while to establish what was going on, but when I
> > > reduced the number of expressions to 31 the error no longer occurred.
>
>   Which fatal error?  There are many, and error messages are helpful.
>
> > > Has anybody else encountered this issue?  Many thanks
>
>   How long is the source line?  The limit is 8192.  Are you
> running into that?
>
>   Experimenting with long lines, the error I get is either
>Line is too long.
> if there is no .fxp and
> is not an object file.
> if there is one.  Either way, there is no .err file generated even if
> I explicitly compile with the compile command.
>
>   My client billing app has a source line that is close to 6K
> long in actual command, but it has line continuations and &&
> comments.  I have not experimented, but one of the two prevents the
> line from being too long as otherwise the source line would be just
> over 20K long.
>
> Sincerely,
>
> Gene Wirchenko
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/CAAwxvU=eor2fceqcnw1oqguozq9u3vruvqahcpxuf36izf0...@mail.gmail.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.

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

2019-11-21 Thread Eric Selje 
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 settings for maximum backwards
compatibility.

On Thu, Nov 21, 2019 at 2:07 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> 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 developer should not.
> >
> > Eric
>
>
> I was surprised that M$ didn't send out a "cease and desist" or some
> such action for it.  Morally and ethically, there's nothing wrong with
> it from what I can tell, but you recall the HUGE STINK they put up when
> Whil Hentzen was going to show VFP running on WINE.  I can't see the
> harm in that either, for that matter.  If that increases M$'s VFP sales,
> GREAT!  (Yes, that's laughable to say...cue the quote by BG about every
> time VFP was sold, they lost $20,000 or something on SQL Server sales.)
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/CAAwxvUk-K=wl9oapgvt8foz5svtwawye79tzy+p-125+d47...@mail.gmail.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.

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

2019-11-21 Thread MB Software Solutions, LLC 

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 developer should not.

Eric



I was surprised that M$ didn't send out a "cease and desist" or some 
such action for it.  Morally and ethically, there's nothing wrong with 
it from what I can tell, but you recall the HUGE STINK they put up when 
Whil Hentzen was going to show VFP running on WINE.  I can't see the 
harm in that either, for that matter.  If that increases M$'s VFP sales, 
GREAT!  (Yes, that's laughable to say...cue the quote by BG about every 
time VFP was sold, they lost $20,000 or something on SQL Server sales.)



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/bf276e54-5d5d-7b91-fa7d-add23a563...@mbsoftwaresolutions.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.

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

2019-11-21 Thread MB Software Solutions, LLC 

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 developer should not.

Eric



Cool.  So it's basically a new set of runtimes and you just redistribute 
those with your apps?  What's the VERSION() value returned?



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/b05949d0-976c-3b0d-83df-5d11ae928...@mbsoftwaresolutions.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.

Re: Fatal error issuing CALCULATE command

2019-11-21 Thread Gene Wirchenko 

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 expressions in a CALCULATE command.  In my case a fatal
> error occurred when trying to CALCULATE the SUMs of 32 different fields in
> a cursor.  It took a while to establish what was going on, but when I
> reduced the number of expressions to 31 the error no longer occurred.


 Which fatal error?  There are many, and error messages are helpful.


> Has anybody else encountered this issue?  Many thanks


 How long is the source line?  The limit is 8192.  Are you 
running into that?


 Experimenting with long lines, the error I get is either
  Line is too long.
if there is no .fxp and
   is not an object file.
if there is one.  Either way, there is no .err file generated even if 
I explicitly compile with the compile command.


 My client billing app has a source line that is close to 6K 
long in actual command, but it has line continuations and && 
comments.  I have not experimented, but one of the two prevents the 
line from being too long as otherwise the source line would be just 
over 20K long.


Sincerely,

Gene Wirchenko


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: https://leafe.com/archives/byMID/
** 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.

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

2019-11-21 Thread Eric Selje 
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 21, 2019 at 1:43 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> 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.)
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/CAAwxvUkAV1JvC-CjZoCrA7CBED3a=fn7wy4lga7v0nuzyym...@mail.gmail.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.

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

2019-11-21 Thread MB Software Solutions, LLC 

 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?



Is Anybody using "VFP Advanced" here?  IIRC, that's the Chinese VFP 10 
version for 64-bit...correct?



--- StripMime Report -- processed MIME parts ---
multipart/alternative
 text/plain (text body -- kept)
 text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/7f04c574-0408-075a-21b6-eab862b40...@mbsoftwaresolutions.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.

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

2019-11-21 Thread MB Software Solutions, LLC 

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 Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/1639363f-806f-ce60-c166-4b41fa738...@mbsoftwaresolutions.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.

Re: Fatal error issuing CALCULATE command

2019-11-21 Thread Eric Selje 
Fair question. That's VFP9. I was going to try it in VFPA if it failed in
VFP9 to see if that fixed the issue but since it didn't fail I haven't
bothered.

Update: It works fine in VFPA too.

On Thu, Nov 21, 2019 at 12:04 PM Tracy Pearson 
wrote:

> 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 adds rows so there's something to actually calculate. I tried it
> with many variations on fields and rows and cannot get it to crash.
>
> #DEFINE _fields 35
> #DEFINE _rows 100
> =RAND(-1)
> CREATE CURSOR crsTest (id i)
> cCalcCmd = [CALCULATE ]
> cInsertFields = []
> cInsertValues = []
> FOR x = 1 TO _fields
>cField = "Field"+TRANSFORM(x)
>ALTER table crsTest ADD COLUMN (cField) I
>cCalcCmd = cCalcCmd + "SUM("+cField+"),"
>cInsertFields = cInsertFields + ","+cField
>cInsertValues = cInsertValues + ","+TRANS(INT(RAND()*100))
> NEXT
> cInsertCmd = [INSERT INTO crsTest (ID ] + cInsertFields +[) VALUES
> (0]+cInsertValues+')'
> FOR X = 1 TO _rows
>
> NEXT
> cCalcCmd = cCalcCmd + "AVG(Field1)"
> 
>
>
>
> On Thu, Nov 21, 2019 at 11:37 AM Tracy Pearson 
> wrote:
>
> > Paul,
> > There is no data in the cursor he created.
> > How many records 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
> >
> > 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-
> > From: ProfoxTech  On Behalf Of Eric Selje
> > Sent: 21 November 2019 16:17
> > 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"+TRANSFORM(x)
> >ALTER table crsTest ADD COLUMN (cField) I
> >cCmd = cCmd + "SUM("+cField+"),"
> > NEXT
> > cCmd = cCmd + "AVG(Field1)"
> > 
> >
> >
> > 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 expressions in a CALCULATE command.  In my case a
> > > fatal error occurred when trying to CALCULATE the SUMs of 32 different
> > > fields in a cursor.  It took a while to establish what was going on,
> > > but when I reduced the number of expressions to 31 the error no longer
> > occurred.
> > >
> > > Has anybody else encountered this issue?  Many thanks
> > >
> > > Paul Newton
> > >
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/caawxvunhwqwo+0bqvl7yherofsfm2xwcdmqxz4env6c6pla...@mail.gmail.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.

RE: Fatal error issuing CALCULATE command

2019-11-21 Thread Tracy Pearson 
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 adds rows so there's something to actually calculate. I tried it
with many variations on fields and rows and cannot get it to crash.

#DEFINE _fields 35
#DEFINE _rows 100
=RAND(-1)
CREATE CURSOR crsTest (id i)
cCalcCmd = [CALCULATE ]
cInsertFields = []
cInsertValues = []
FOR x = 1 TO _fields
   cField = "Field"+TRANSFORM(x)
   ALTER table crsTest ADD COLUMN (cField) I
   cCalcCmd = cCalcCmd + "SUM("+cField+"),"
   cInsertFields = cInsertFields + ","+cField
   cInsertValues = cInsertValues + ","+TRANS(INT(RAND()*100))
NEXT
cInsertCmd = [INSERT INTO crsTest (ID ] + cInsertFields +[) VALUES
(0]+cInsertValues+')'
FOR X = 1 TO _rows
   
NEXT
cCalcCmd = cCalcCmd + "AVG(Field1)"




On Thu, Nov 21, 2019 at 11:37 AM Tracy Pearson 
wrote:

> Paul,
> There is no data in the cursor he created.
> How many records 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
>
> 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-
> From: ProfoxTech  On Behalf Of Eric Selje
> Sent: 21 November 2019 16:17
> 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"+TRANSFORM(x)
>ALTER table crsTest ADD COLUMN (cField) I
>cCmd = cCmd + "SUM("+cField+"),"
> NEXT
> cCmd = cCmd + "AVG(Field1)"
> 
>
>
> 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 expressions in a CALCULATE command.  In my case a
> > fatal error occurred when trying to CALCULATE the SUMs of 32 different
> > fields in a cursor.  It took a while to establish what was going on,
> > but when I reduced the number of expressions to 31 the error no longer
> occurred.
> >
> > Has anybody else encountered this issue?  Many thanks
> >
> > Paul Newton
> >
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/000501d5a096$1948fd10$4bdaf730$@powerchurch.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.

Re: Fatal error issuing CALCULATE command

2019-11-21 Thread Eric Selje 
This tweak adds rows so there's something to actually calculate. I tried it
with many variations on fields and rows and cannot get it to crash.

#DEFINE _fields 35
#DEFINE _rows 100
=RAND(-1)
CREATE CURSOR crsTest (id i)
cCalcCmd = [CALCULATE ]
cInsertFields = []
cInsertValues = []
FOR x = 1 TO _fields
   cField = "Field"+TRANSFORM(x)
   ALTER table crsTest ADD COLUMN (cField) I
   cCalcCmd = cCalcCmd + "SUM("+cField+"),"
   cInsertFields = cInsertFields + ","+cField
   cInsertValues = cInsertValues + ","+TRANS(INT(RAND()*100))
NEXT
cInsertCmd = [INSERT INTO crsTest (ID ] + cInsertFields +[) VALUES
(0]+cInsertValues+')'
FOR X = 1 TO _rows
   
NEXT
cCalcCmd = cCalcCmd + "AVG(Field1)"




On Thu, Nov 21, 2019 at 11:37 AM Tracy Pearson 
wrote:

> Paul,
> There is no data in the cursor he created.
> How many records 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
>
> 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-
> From: ProfoxTech  On Behalf Of Eric Selje
> Sent: 21 November 2019 16:17
> 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"+TRANSFORM(x)
>ALTER table crsTest ADD COLUMN (cField) I
>cCmd = cCmd + "SUM("+cField+"),"
> NEXT
> cCmd = cCmd + "AVG(Field1)"
> 
>
>
> 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 expressions in a CALCULATE command.  In my case a
> > fatal error occurred when trying to CALCULATE the SUMs of 32 different
> > fields in a cursor.  It took a while to establish what was going on,
> > but when I reduced the number of expressions to 31 the error no longer
> occurred.
> >
> > Has anybody else encountered this issue?  Many thanks
> >
> > Paul Newton
> >
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/CAAwxvUkucf5PSZ=fuLCc8LxNBJtSAqw3BvG1tuP2zh=yvlg...@mail.gmail.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.

RE: Fatal error issuing CALCULATE command

2019-11-21 Thread Tracy Pearson 
Paul, 
There is no data in the cursor he created. 
How many records 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

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-
From: ProfoxTech  On Behalf Of Eric Selje
Sent: 21 November 2019 16:17
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"+TRANSFORM(x)
   ALTER table crsTest ADD COLUMN (cField) I
   cCmd = cCmd + "SUM("+cField+"),"
NEXT
cCmd = cCmd + "AVG(Field1)"



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 expressions in a CALCULATE command.  In my case a 
> fatal error occurred when trying to CALCULATE the SUMs of 32 different 
> fields in a cursor.  It took a while to establish what was going on, 
> but when I reduced the number of expressions to 31 the error no longer
occurred.
>
> Has anybody else encountered this issue?  Many thanks
>
> Paul Newton
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/000401d5a092$4947a880$dbd6f980$@powerchurch.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.

RE: Fatal error issuing CALCULATE command

2019-11-21 Thread Paul Newton 
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-
From: ProfoxTech  On Behalf Of Eric Selje
Sent: 21 November 2019 16:17
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"+TRANSFORM(x)
   ALTER table crsTest ADD COLUMN (cField) I
   cCmd = cCmd + "SUM("+cField+"),"
NEXT
cCmd = cCmd + "AVG(Field1)"



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 expressions in a CALCULATE command.  In my case a 
> fatal error occurred when trying to CALCULATE the SUMs of 32 different 
> fields in a cursor.  It took a while to establish what was going on, 
> but when I reduced the number of expressions to 31 the error no longer 
> occurred.
>
> Has anybody else encountered this issue?  Many thanks
>
> Paul Newton
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/by5pr02mb6852c9d7d602e0883a1a2257a1...@by5pr02mb6852.namprd02.prod.outlook.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.

Re: Fatal error issuing CALCULATE command

2019-11-21 Thread Eric Selje 
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 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 expressions in a CALCULATE command.  In my case a fatal
> error occurred when trying to CALCULATE the SUMs of 32 different fields in
> a cursor.  It took a while to establish what was going on, but when I
> reduced the number of expressions to 31 the error no longer occurred.
>
> Has anybody else encountered this issue?  Many thanks
>
> Paul Newton
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/CAAwxvUnqNfqeV=cj_zspsecszeqc+cerhgwktx3qkfde9a8...@mail.gmail.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.