Re: [NF] Cursing Microsoft for dialog boxes that will not expand in any direction in Word 2016

2019-05-21 Thread Kurt @ Gmail
Excellent! Don't we ALL Need an Upgrade in life??? On 5/21/2019 11:45 PM, Johan Nel wrote: On 2019/05/21 21:09, Eric Selje wrote: And as a programmer, can you fix my iPhone? Yes, it is called upgrade iPhone 4.0 to iPhone 6.0... :-D [excessive quoting removed by server] _

Re: [NF] Cursing Microsoft for dialog boxes that will not expand in any direction in Word 2016

2019-05-21 Thread Johan Nel
On 2019/05/21 21:09, Eric Selje wrote: And as a programmer, can you fix my iPhone? Yes, it is called upgrade iPhone 4.0 to iPhone 6.0... :-D ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

Re: [NF] Cursing Microsoft for dialog boxes that will not expand in any direction in Word 2016

2019-05-21 Thread Kurt @ Gmail
Touche! On 5/21/2019 3:09 PM, Gene Wirchenko wrote: At 12:09 2019-05-21, Eric Selje wrote: And as a programmer, can you fix my iPhone? Call a veterinarian instead. [snip] Sincerely, Gene Wirchenko [excessive quoting removed by server] _

Re: [NF] Cursing Microsoft for dialog boxes that will not expand in any direction in Word 2016

2019-05-21 Thread Kurt @ Gmail
Nope - and I wouldn't want to. To be honest - I prefer to hang out in the 3DP Realm... -K- On 5/21/2019 12:09 PM, Eric Selje wrote: And as a programmer, can you fix my iPhone? On Tue, May 21, 2019 at 12:32 PM Kurt @ Gmail wrote: Mike - how DARE you make a comment like that! You're a progra

Re: Filtering Oddity

2019-05-21 Thread AndyHC
update table set flda="blah' where table.pk=temp2.pk   -- && or thereabouts? On 21-May-19 11:07 PM, Gene Wirchenko wrote: At 03:17 2019-05-21, AndyHC wrote: +1 Not if you need to adjust the original table.  I frequently do.  This idiom of filter and diddle is very useful when I am chec

Re: [NF] Cursing Microsoft for dialog boxes that will not expand in any direction in Word 2016

2019-05-21 Thread Gene Wirchenko
At 12:09 2019-05-21, Eric Selje wrote: And as a programmer, can you fix my iPhone? Call a veterinarian instead. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/

Re: Filtering Oddity

2019-05-21 Thread Gene Wirchenko
At 11:24 2019-05-19, Koen Piller wrote: Gene If you would have used a select..where.. into cursor curTemp from myTable into curosr myCursor than your next select statement could be select...where...from myCursor into cursor Temp2 you are done. easy quick and dirty. Nope. Have you misse

Re: Filtering Oddity

2019-05-21 Thread Gene Wirchenko
At 03:17 2019-05-21, AndyHC wrote: +1 Not if you need to adjust the original table. I frequently do. This idiom of filter and diddle is very useful when I am checking the coverage of a report's error checking. [snip] Sincerely, Gene Wirchenko

Re: Filtering Oddity

2019-05-21 Thread Gene Wirchenko
At 07:29 2019-05-19, Man-wai Chang wrote: You can just watch the value of variable f. A valid filter expression stored in variable f will not produce error. What are you trying to do when you said "...would prefer just one statement in the heat of debugging"? Trying to restrict the

Re: ? Cross tabulation

2019-05-21 Thread MB Software Solutions, LLC
Ah the good ol' days.  Still great content. Too bad M$ didn't keep the Fox going.   What a great toolstill to this day. On 5/21/2019 1:44 PM, Ted Roche wrote: (Replying to Eric because I never see Paul's original posts) July 2006 Advisor Answers: http://www.tomorrowssolutionsllc.com/Art

Re: [NF] Cursing Microsoft for dialog boxes that will not expand in any direction in Word 2016

2019-05-21 Thread MB Software Solutions, LLC
Excellent reply! Reminds me of this: https://www.google.com/search?q=No+I+will+not+fix+your+PC&client=avast&source=lnms&tbm=isch&sa=X&ved=0ahUKEwi_7cOMqq3iAhUE16wKHTfPCecQ_AUIDigB&biw=1904&bih=996 On 5/21/2019 3:09 PM, Eric Selje wrote: And as a programmer, can you fix my iPhone? On Tue, Ma

Re: [NF] Cursing Microsoft for dialog boxes that will not expand in any direction in Word 2016

2019-05-21 Thread Eric Selje
And as a programmer, can you fix my iPhone? On Tue, May 21, 2019 at 12:32 PM Kurt @ Gmail wrote: > Mike - how DARE you make a comment like that! You're a programmer - and > ALL code should look Easy to you!!! No??? > > :-) > > -K- > > > On 5/21/2019 8:49 AM, MB Software Solutions, LLC wrote: > >

Re: ? Cross tabulation

2019-05-21 Thread Ted Roche
(Replying to Eric because I never see Paul's original posts) July 2006 Advisor Answers: http://www.tomorrowssolutionsllc.com/Articles/Create%20Cross-tabs.PDF and the FoxWiki Tamar references: http://fox.wikis.com/wc.dll?Wiki~CrossTab~VB http://fox.wikis.com/wc.dll?Wiki~MatXTab (with download lin

Re: [NF] Cursing Microsoft for dialog boxes that will not expand in any direction in Word 2016

2019-05-21 Thread Kurt @ Gmail
Mike - how DARE you make a comment like that! You're a programmer - and ALL code should look Easy to you!!! No??? :-) -K- On 5/21/2019 8:49 AM, MB Software Solutions, LLC wrote: Ouch...that gives me a headache just trying to decipher that! On 5/21/2019 4:36 AM, Johan Nel wrote: And straigh

Re: [NF] Cursing Microsoft for dialog boxes that will not expand in any direction in Word 2016

2019-05-21 Thread MB Software Solutions, LLC
Ouch...that gives me a headache just trying to decipher that! On 5/21/2019 4:36 AM, Johan Nel wrote: And straight from the .NET runtime, the culprit is  drum rolling..  BestFitMapping = false :-) [DllImport("user32.dll", BestFitMapping = false, CharSet = CharSet.Auto, SetLastError =

RE: ? Cross tabulation

2019-05-21 Thread Paul Newton
Thanks Eric I seem to recall FastXTab from way, way back. I'll take another look at it Paul Newton -Original Message- From: ProfoxTech On Behalf Of Eric Selje Sent: 21 May 2019 15:28 To: profoxt...@leafe.com Subject: Re: ? Cross tabulation Sent by an external sender --

Re: ? Cross tabulation

2019-05-21 Thread Eric Selje
There's a cross-tab wizard that comes with VFP, but I'd look at this VFPX project: https://github.com/VFPX/FastXTab Eric On Tue, May 21, 2019 at 8:43 AM Paul Newton wrote: > Hi all > > I have data like this: > Tablename Auditdate Auditsize > CTRAN 01/01/2019

? Cross tabulation

2019-05-21 Thread Paul Newton
Hi all I have data like this: Tablename Auditdate Auditsize CTRAN 01/01/2019 25 PTRAN 01/01/2019 30 STRAN 01/01/2019 35 CTRAN 01/02/2019 30 PTRAN 01/02/2

RE: Filtering Oddity

2019-05-21 Thread Richard Kaye
The comment about edits doesn't seem right to me. I was just mentioning that VFP could potentially do a USE...AGAIN with a filter if you don't use either the NOFILTER (read-only) or READWRITE keywords when the destination is a cursor. Tamar's Taming SQL book has a good explanation of what VFP do

Re: Filtering Oddity

2019-05-21 Thread Peter Cushing
So if you leave off the NOFILTER/READWRITE you have a read only file, so "edits to this cursor would be written to the actual source table" would not apply.  It sounds like there are no circumstances where you could write data back from the select statement, or am I missing something? Peter On 21

RE: Filtering Oddity

2019-05-21 Thread Richard Kaye
VFP's query engine decides what has less overhead; running the query or doing a USE...AGAIN with a filter. NOFILTER and READWRITE force VFP to create a temp file with the results. -- rk -Original Message- From: ProfoxTech On Behalf Of Peter Cushing Sent: Tuesday, May 21, 2019 6:35 AM

Re: Filtering Oddity

2019-05-21 Thread Alan Bourke
> > I don't know if that behaviour was from an older VFP version but I don't > remember it. Am I getting Alzheimer's? Somebody put me out of my > misery :-) Since VFP6 if you do a select that involves one table and is 100% optimisable, it will just show you the actual table with a behind-the-s

Re: Filtering Oddity

2019-05-21 Thread Peter Cushing
On 20/05/2019 19:39, Fletcher Johnson wrote: > Not sure where the "Had to be bad coding" comes in. > > For example, if you did "select * from employee where last name = 'Smith'" > you would get a cursor of only those employees. The employee table would > still be open, but VFP opened it again, in

Re: Filtering Oddity

2019-05-21 Thread AndyHC
+1 On 19-May-19 7:24 PM, Koen Piller wrote: Gene If you would have used a select..where.. into cursor curTemp from myTable into curosr myCursor than your next select statement could be select...where...from myCursor into cursor Temp2 you are done. easy quick and dirty. Regards, Koen __

Re: [NF] Cursing Microsoft for dialog boxes that will not expand in any direction in Word 2016

2019-05-21 Thread Johan Nel
And straight from the .NET runtime, the culprit is  drum rolling..  BestFitMapping = false :-) [DllImport("user32.dll", BestFitMapping = false, CharSet = CharSet.Auto, SetLastError = true)] [SuppressUnmanagedCodeSecurity] [SecurityCritical] public static extern int MessageBox(HandleRef

Re: [NF] Cursing Microsoft for dialog boxes that will not expand in any direction in Word 2016

2019-05-21 Thread Kurt @ Gmail
Angry Mike - I thought your post was funny - but, then I looked at the pic - and had to laugh. You now remind me of Bad Steve! Oh no - now I'm Bad Kurt... :-) -K- On 5/20/2019 2:52 PM, MB Software Solutions, LLC wrote: GRR! I've got a colossal cleanup to do with bookmark references