ProFox May 2019

profox@leafe.com

33 participants
48 discussions

[NF] AtoutFox, Lyon, France
by Johan Nel 28 May '19

28 May '19

Hi Guys, Well not sure how many French speaking VFP users are on the English forums, but as some of you might be aware, Fabrice Foray from the X# Devteam was invited to make a presentation at AtoutFox. https://www.foxite.com/archives/x-presentation-at-atoutfox-lyon-france-0000… Would be good to hear if there are some attendees on this forum and their first impressions of what they have seen... Johan Nel George, South Africa FOX member: Friends of XSharp X# Website: https://xsharp.info <https://xsharp.info/>

3 3

[FW]Harbour for the web is finally here !!!
by Man-wai Chang 27 May '19

27 May '19

On 5/26/2019 5:52 AM, antonio.fivetech(a)gmail.com wrote: > > Please take some minutes to read this: > > https://fivetechsoft.github.io/mod_harbour/ > Very interesting.... "mod Harbour is an extension module for Apache that provides full support to execute PRGs and HRBs files from the web. If you are a Windows developer, you can build the web from your Windows 10 and then simply run your PRGs on Edge or Chrome powered by Apache on the Windows 10 bash using the mod Harbour extension. When everything is ready, simply take your PRGs to your dedicated Linux web server where you can install the mod Harbour for Apache." -- .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit Fedora 25 Server Spin /( _ )\ http://sites.google.com/site/changmw ^ ^ May the Force and farces be with you!

1 0

[NF] X# and Visual Studio 2019
by Johan Nel 27 May '19

27 May '19

Hi VFPers and X# lurkers, After some requests about other programming languages MS released a new build for VS 2019 and X# is now fully supported in VS 2019. See the announcement on the XSharp website. https://www.xsharp.info/articles/vs-2019 I have also posted this message on Foxite: https://www.foxite.com/archives/x-fully-supported-in-vs-2019-0000466364.htm A new build of X# is taking shape and I will keep you up to date regarding VFP syntax support. Johan Nel George, South Africa FOX member: Friends of XSharp X# Website: https://xsharp.info <https://xsharp.info/>

1 0

RE: Filtering Oddity
by Fletcher Johnson 22 May '19

22 May '19

Gene, Not to beat a dead horse.... While I think these may have been mentioned in various places.... 1) It used to be that a Select statement would be optimized by VFP to open the source table again, in another work area, and then set a filter on it. This was a problem when people thought they had a cursor and updated the contents, only to find out they had edited the actual data. So they added a "nofilter" clause that forced VFP to create a new cursor and not use the original approach. 2) I haven't seen any discussion on set relation - which might also do what you want (but I haven't actually tested it so may be wrong.) 3) You can use the browse for .... command (I tended to use this over set filter, especially since I could then use "browse last" as well.) As I recall, this worked the same as set filter but didn't require the literal values that set filter do. 4) Of course, Select is an option - but then you may have to guess if VFP did #1 or if it actually created a cursor and your edits are thrown away when you close it. 5) I can't remember, but did set filter allow you to reference a variable? And, if so, did changing that variable then change the effect of the filter? If so, this might also be an option. Take care, Fletcher Fletcher Johnson FletcherSJohnson(a)Yahoo.com LinkedIn.com/in/FletcherJohnson twitter.com/fletcherJ strava.com/athletes/fletcherjohnson 408-946-0960 - work 408-781-2345 - cell -----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Gene Wirchenko Sent: Tuesday, May 14, 2019 3:46 PM To: ProFox Email List Subject: Filtering Oddity Hello: I was looking over a program preparatory to an enhancement. I inserted a debugging browse statement in a branch that I was going to add some error reporting to. The branch, oddly, did not get executed. Dig, dig ... use cwkf set filter to validto>={^2019.01.01} count browse Lots of rows. Oh, the filter needs to be extended. set filter to filter()+" and empty(wfccccd)" VFP: Nice try. (Actually, "Command contains unrecognized phrase/keyword." set filter to (filter()+" and empty(wfccccd)") VFP: Don't be silly. (Same error.) Putting an avaluate() around it does not work either. ("Syntax error.") I do know that I can do f=filter()+" and empty(wfccccd)" set filter to &f but in the heat of debugging, I would prefer just one statement. Is there a way to extend a filter in one statement without retyping the current filter expression? Sincerely, Gene Wirchenko [excessive quoting removed by server]

7 10

? Cross tabulation
by Paul Newton 22 May '19

22 May '19

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/2019 35 STRAN 01/02/2019 40 CTRAN 01/03/2019 35 PTRAN 01/03/2019 40 STRAN 01/03/2019 45 And I want to process it in such a way that it ends up like this TableName 01/01/2019 01/02/2019 01/03/2019 CTRAN 25 30 35 PTRAN 30 35 40 STRAN 35 40 45 I realise that the dates would have be converted to valid field names. Anybody have ideas/suggestions? Does anybody know of a tool that would achieve this? Many thanks Paul Newton

4 5

[NF] Cursing Microsoft for dialog boxes that will not expand in any direction in Word 2016
by MB Software Solutions, LLC 22 May '19

22 May '19

GRRRRRR!!!!! I've got a colossal cleanup to do with bookmark references and this freaking window refuses to enlarge in any direction: https://www.screencast.com/t/PTDtv8bVI C'MON, M$!!! NOT TODAY!!!!! --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

4 9

Re: [NF] Cursing Microsoft for dialog boxes that will not expand in any direction in Word 2016
by Kurt ＠ Gmail 22 May '19

22 May '19

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

1 0

Re: Filtering Oddity
by AndyHC 21 May '19

21 May '19

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 <andy(a)hawthorncottage.com> 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 > > [excessive quoting removed by server]

1 0

Re: [NF] Cursing Microsoft for dialog boxes that will not expand in any direction in Word 2016
by Gene Wirchenko 21 May '19

21 May '19

At 12:09 2019-05-21, Eric Selje <Eric(a)saltydogllc.com> wrote: >And as a programmer, can you fix my iPhone? Call a veterinarian instead. [snip] Sincerely, Gene Wirchenko

1 0

Re: Filtering Oddity
by Man-wai Chang 21 May '19

21 May '19

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"? On Wed, May 15, 2019 at 6:46 AM Gene Wirchenko <gene(a)shaw.ca> wrote: > I do know that I can do > f=filter()+" and empty(wfccccd)" > set filter to &f > but in the heat of debugging, I would prefer just one statement. > > Is there a way to extend a filter in one statement without > retyping the current filter expression? -- .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit Fedora 25 Server Spin /( _ )\ http://sites.google.com/site/changmw ^ ^ May the Force and farces be with you!

4 3

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox May 2019