Re: So, about this VFPA thing...
Yes, that is the right site. Happy Coding! Tracy On November 22, 2019 10:42:56 PM EST, Vince Teachout wrote: >Apparently, I've been under a rock, and there's a magically enhanced >VFP9 SP2 that fixes some bugs, can run concurrently with vfp9, and >supports 64 bits. > >Before I download something, am I on the right site: >http://baiyujia.com/vfpadvanced/f_vfpa_about.asp ? > >Thanks! > > > > > >___ >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/ce5a8b3d-d308-5d78-eeb7-1c92e4e1d...@caracal.net >** 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. > >Report [OT] Abuse: >http://leafe.com/reportAbuse/ce5a8b3d-d308-5d78-eeb7-1c92e4e1d...@caracal.net --- 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/2bd0e3fe-9b9b-4c4b-aea4-a564bee4e...@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.
So, about this VFPA thing...
Apparently, I've been under a rock, and there's a magically enhanced VFP9 SP2 that fixes some bugs, can run concurrently with vfp9, and supports 64 bits. Before I download something, am I on the right site: http://baiyujia.com/vfpadvanced/f_vfpa_about.asp ? Thanks! ___ 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/ce5a8b3d-d308-5d78-eeb7-1c92e4e1d...@caracal.net ** 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)
/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
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
&cInsertCmd
NEXT
cCalcCmd = Left(cCalcCmd,Len(cCalcCmd)-1) + " To " +
Left(cVariables,Len(cVariables)-1) &&+ "AVG(Field1)"
? cCalcCmd
&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)
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: Windows 10 X to support Win32 apps
I thought we were pretty much told there would be no new operating systems past Windows 10, so if your VFP app ran on Windows 10 now, then it was going to run forever. On 11/22/2019 11:13 AM, Tracy Pearson wrote: This is good news. From what I gathered from the article the 32 bit apps will run in container. Not sure what that means yet. Time will tell. Tracy https://www.windowslatest.com/2019/11/21/windows-10-x-to-support-win32-apps- sandbox-other-features/ [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/bbd701e5-c8cc-96af-17ac-56921f36a...@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: Gartner Analyst Relations
On 11/22/2019 11:40 AM, Vince Teachout wrote: On 11/22/19 10:11 AM, MB Software Solutions, LLC wrote: Thankfully my memory on bullshit fades but I recall something about them hosing FoxPro wy before it's true demise. You others longer in the game than I may recall better (unless you've got that CRS syndome too. CRS = Can't Remember Shit) Yeah, we lost a client because those scrotes and their Foxpro is dead gospel. "Why would be use an obsolete tech?" I'm sure MANY shops/teams out there dumped FoxPro because of Gartner. SURE of it. My employer at the time used their words as gospel and was looking to dump the Fox too based on that. Is it too late for a class-action lawsuit against those douchebags? LOL ___ 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/3cc1e72b-f0bd-5807-363e-e6d0b3200...@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)
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)
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)
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: Gartner Analyst Relations
Yep, in 1995 or 96 they said "FoxPro is dead". I think that was VFP 5 time. Frank. Frank Cazabon On 22/11/2019 11:11 AM, MB Software Solutions, LLC wrote: Thankfully my memory on bullshit fades but I recall something about them hosing FoxPro wy before it's true demise. You others longer in the game than I may recall better (unless you've got that CRS syndome too. CRS = Can't Remember Shit) On 11/22/2019 9:35 AM, Charlie Coleman wrote: Gartner probably one of the most 'listened to' but 'highly inaccurate' companies that exist. So yes, I too would be irritated if they suggested (wasting my) time with them. :) -Charlie On Fri, Nov 22, 2019 at 9:27 AM MB Software Solutions, LLC < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: I still get slightly agitated when I see the name "Gartner" -- you all remember that?!?!? Forwarded Message Subject: Gartner Analyst Relations Date: Thu, 21 Nov 2019 21:18:58 + From: Noonan,Devin To: mbabc...@mbsoftwaresolutions.com Hi Michael, I’m reaching out to better understand if MB Software Solutions, LLCwould be a fit to work with our analyst community for thought leadership and strategic insight. I am spearheading a new Gartner channel that focuses on high growth startups and emerging tech/service providers, and would love to discuss how Gartner can contribute to MB Software Solutions, LLC's continued growth. Do you have 30 minutes for a phone call this week or next to discuss this further? Kind regards, Devin Devin Noonan Business Development Director *Gartner* Direct: +1 (239) 900-8405 | Mobile: +1 (732) 977-4929 gartner.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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/eef6e3e1-50cd-0e26-0860-f1b8f0617...@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: Fwd: Gartner Analyst Relations
+1 On 22-Nov-2019 7:56 PM, MB Software Solutions, LLC wrote: I still get slightly agitated when I see the name "Gartner" -- you all remember that?!?!? ___ 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/90907316-475c-12a9-f3f8-17c711ffb...@hawthorncottage.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: Gartner Analyst Relations
On 11/22/19 10:11 AM, MB Software Solutions, LLC wrote: Thankfully my memory on bullshit fades but I recall something about them hosing FoxPro wy before it's true demise. You others longer in the game than I may recall better (unless you've got that CRS syndome too. CRS = Can't Remember Shit) Yeah, we lost a client because those scrotes and their Foxpro is dead gospel. "Why would be use an obsolete tech?" ___ 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/d2db162e-adce-db95-db1b-fcb285c6a...@caracal.net ** 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
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
>&cInsertCmd
> NEXT
> cCalcCmd = Left(cCalcCmd,Len(cCalcCmd)-1) + " To " +
> Left(cVariables,Len(cVariables)-1) &&+ "AVG(Field1)"
> ? cCalcCmd
> &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)
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.
Windows 10 X to support Win32 apps
This is good news. From what I gathered from the article the 32 bit apps will run in container. Not sure what that means yet. Time will tell. Tracy https://www.windowslatest.com/2019/11/21/windows-10-x-to-support-win32-apps- sandbox-other-features/ ___ 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/000701d5a14f$ba0c6340$2e2529c0$@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: Gartner Analyst Relations
Thankfully my memory on bullshit fades but I recall something about them hosing FoxPro wy before it's true demise. You others longer in the game than I may recall better (unless you've got that CRS syndome too. CRS = Can't Remember Shit) On 11/22/2019 9:35 AM, Charlie Coleman wrote: Gartner probably one of the most 'listened to' but 'highly inaccurate' companies that exist. So yes, I too would be irritated if they suggested (wasting my) time with them. :) -Charlie On Fri, Nov 22, 2019 at 9:27 AM MB Software Solutions, LLC < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: I still get slightly agitated when I see the name "Gartner" -- you all remember that?!?!? Forwarded Message Subject:Gartner Analyst Relations Date: Thu, 21 Nov 2019 21:18:58 + From: Noonan,Devin To: mbabc...@mbsoftwaresolutions.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/2b974bca-94d3-7439-314d-a9c7f4c48...@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
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
&cInsertCmd
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) *&cCalcCmd
*&cCalcCmd2
Sum &cTemp 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
>&cInsertCmd
> NEXT
> cCalcCmd = Left(cCalcCmd,Len(cCalcCmd)-1) + " To " +
> Left(cVariables,Len(cVariables)-1) &&+ "AVG(Field1)"
> ? cCalcCmd
> &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: Gartner Analyst Relations
Gartner probably one of the most 'listened to' but 'highly inaccurate' companies that exist. So yes, I too would be irritated if they suggested (wasting my) time with them. :) -Charlie On Fri, Nov 22, 2019 at 9:27 AM MB Software Solutions, LLC < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > I still get slightly agitated when I see the name "Gartner" -- you all > remember that?!?!? > > > > Forwarded Message > Subject:Gartner Analyst Relations > Date: Thu, 21 Nov 2019 21:18:58 + > From: Noonan,Devin > To: mbabc...@mbsoftwaresolutions.com > > > > > Hi Michael, > > I’m reaching out to better understand if MB Software Solutions, LLCwould > be a fit to work with our analyst community for thought leadership and > strategic insight. > > I am spearheading a new Gartner channel that focuses on high growth > startups and emerging tech/service providers, and would love to discuss > how Gartner can contribute to MB Software Solutions, LLC's continued > growth. > > Do you have 30 minutes for a phone call this week or next to discuss > this further? > > Kind regards, > > Devin > > Devin Noonan > > Business Development Director > > *Gartner* > > Direct: +1 (239) 900-8405 | Mobile: +1 (732) 977-4929 > > gartner.com > > > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [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/cajgvlx1bor_muqv9c0ocnw9vp2nfxm-xdaxexjfsg2qve7b...@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.
Fwd: Gartner Analyst Relations
I still get slightly agitated when I see the name "Gartner" -- you all remember that?!?!? Forwarded Message Subject:Gartner Analyst Relations Date: Thu, 21 Nov 2019 21:18:58 + From: Noonan,Devin To: mbabc...@mbsoftwaresolutions.com Hi Michael, I’m reaching out to better understand if MB Software Solutions, LLCwould be a fit to work with our analyst community for thought leadership and strategic insight. I am spearheading a new Gartner channel that focuses on high growth startups and emerging tech/service providers, and would love to discuss how Gartner can contribute to MB Software Solutions, LLC's continued growth. Do you have 30 minutes for a phone call this week or next to discuss this further? Kind regards, Devin Devin Noonan Business Development Director *Gartner* Direct: +1 (239) 900-8405 | Mobile: +1 (732) 977-4929 gartner.com --- 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/d1d32d32-399d-29f3-64b3-355f00ad1...@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
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
&cInsertCmd
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)
*&cCalcCmd
*&cCalcCmd2
Sum &cTemp 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
>&cInsertCmd
> NEXT
> cCalcCmd = Left(cCalcCmd,Len(cCalcCmd)-1) + " To " +
> Left(cVariables,Len(cVariables)-1) &&+ "AVG(Field1)"
> ? cCalcCmd
> &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
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
&cInsertCmd
NEXT
cCalcCmd = Left(cCalcCmd,Len(cCalcCmd)-1) + " To " +
Left(cVariables,Len(cVariables)-1) &&+ "AVG(Field1)"
? cCalcCmd
&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
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
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
&cInsertCmd
NEXT
cCalcCmd = cCalcCmd + "AVG(Field1)"
&cCalcCmd
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)"
> &cCmd
>
>
> 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
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)"
&cCmd
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.
