ProFox May 2019

profox@leafe.com

33 participants
48 discussions

Re: Filtering Oddity
by Gene Wirchenko 21 May '19

21 May '19

At 11:24 2019-05-19, Koen Piller <koen.piller(a)gmail.com> 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 missed where I stated that I need to diddle the original table? [snip] Sincerely, Gene Wirchenko

1 0

Re: Filtering Oddity
by Gene Wirchenko 21 May '19

21 May '19

At 07:29 2019-05-19, Man-wai Chang <changmw(a)gmail.com> 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 filter further. [snip] Sincerely, Gene Wirchenko

1 0

Changing VFP menu (during runtime in app) FONT NAME
by MB Software Solutions, LLC 20 May '19

20 May '19

VFP9SP2 on Win7/8/10 I see in VFP Help that if you're stick building your app's top positioned (not-pop-up) Menu code by hand, it has a FONT clause. However, I use the good ol' fashioned Menu designer (as clunky as it is). I've introduced the ability for the user to pick the Font s/he wants in my app now and have that working great for the forms UI...but I want to get the top menu using the same Font Name. I realize MESSAGEBOX fonts are a different beast so that's a different time. Here's a screenshot: https://www.screencast.com/t/kWLEGwE9G But the VFP menu: I adjusted the MyMenu.MPR file like below: https://www.screencast.com/t/U7ptKp7rrxV ...but that didn't work. Plus, to make it worse, when I rebuilt all files in the project, those font command changes went away. Ideas? tia, --Mike --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

8 13

.NET 5 and X#
by Johan Nel 17 May '19

17 May '19

Hi all, Not sure if you have seen the MicroSoft announcement regarding .NET 5, see https://devblogs.microsoft.com/dotnet/introducing-net-5/ Here is also a response from Robert van der Hulst on the X# forums regarding support for it: Our compiler already supports .Net Core. And AFAIK we have not used any APIs in our runtime that are not available on .Net Core. Maybe one or two, but I am sure we can work around that. The only thing stopping us from giving you .Net core support in VS at this moment is that we don't support the new "lean" project file format (yet). And of course the fact that this new project file format does not support things like Windows Forms and WPF (not even for C#). If you look at the videos of Build you will see that they promise to have the winform and WPF designer support in September 2019. If you want to see X# working with .Net core try this: <snip> Hope it is of interest to show that X# is not again a project that will die a sudden death... Johan Nel Friends of XSharp http://xsharp.info

3 3

RE: Filtering Oddity
by Richard Kaye 17 May '19

17 May '19

And here's a use case where SET FILTER can be quite useful in a production application. Let's say you have a form that displays account receivable transactions for a customer (invoices, payments, adjustments, etc.). You want to be able to display only open (i.e. unpaid) transactions or transactions related to a specific invoice. The primary query has returned all the rows I need to display for that customer. SET FILTER handles that quickly and simply without the overhead of running another query against the main database. -- rk -----Original Message----- From: ProfoxTech <profoxtech-bounces(a)leafe.com> On Behalf Of Gene Wirchenko Sent: Wednesday, May 15, 2019 2:55 PM To: profoxtech(a)leafe.com Subject: RE: Filtering Oddity At 11:41 2019-05-15, Richard Kaye <rkaye(a)invaluable.com> wrote: >Gene and Woody's point is that XBASE tools are quite useful for us when >developing/testing, not that they are necessarily preferable for >production code. Exactly. One advantage that is particularly nice is that they are often short, simple, and fast. When I am chasing a bug or working on an idea, I prefer being able to get done what I want done fast. The protections that one might well want for an app are often not relevant. [snip] Sincerely, Gene Wirchenko [excessive quoting removed by server]

4 9

How would you generate this report?
by MB Software Solutions, LLC 15 May '19

15 May '19

Screenshot of Word document in question (with notations for where content is dynamic; some parts blurred just to protect the players): https://www.screencast.com/t/vOJd9eBwPaX Currently, my colleague did so many of these documents MANUALLY in Word. I'd pull my hair out if I had to do that, especially since I've got VFP. The trick here is to dynamically enter the names for each letter to an organization. Each organization can have 1:M names in this report. The quick thought is a VFP FRX Report, using XFRX (or something else) to save the output to a Word document. And given that the text above the dynamic organization name and user names/emails part is static, I could do it. But like you've probably encountered before, I don't like to force the Line-breaks in the VFP Report Writer if I can avoid it (PITA). So how would you produce these dynamic Word documents easily? Flattened cursor for this would have this structure: * OrgName * OrgID (e.g., P0135) * Name * Email * AcctType That's it. User would select the Yes/No values and return to us. Task here is generated these 100 reports without having to manually do it (and obviously avoid the human error factor). tia, --Mike --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 6

RE: Filtering Oddity
by Gene Wirchenko 15 May '19

15 May '19

At 11:41 2019-05-15, Richard Kaye <rkaye(a)invaluable.com> wrote: >Gene and Woody's point is that XBASE tools are quite useful for us >when developing/testing, not that they are necessarily preferable >for production code. Exactly. One advantage that is particularly nice is that they are often short, simple, and fast. When I am chasing a bug or working on an idea, I prefer being able to get done what I want done fast. The protections that one might well want for an app are often not relevant. [snip] Sincerely, Gene Wirchenko

1 0

Re: Filtering Oddity
by Koen Piller 15 May '19

15 May '19

Gene I would like to see an actual situation where set filter is preferable over select() according to you. Regards Koen Op wo 15 mei 2019 om 19:49 schreef Gene Wirchenko <gene(a)shaw.ca> > At 02:00 2019-05-15, Koen Piller <koen.piller(a)gmail.com> wrote: > >Hi, > >The use of 'Set Filter' in VFP is outdated. Nowadays we use > >Select....from...Where...into > > Who is "we"? > > Your select statement does not do the same thing. I use set > filter to check for data having certain properties especially when I > am likely to change said data. It is excellent for when I wish to > diddle some data to force an error condition during program testing. > > Many xBASE commands are very good for use in exploration, > debugging, testing, and the like. > > [snip] > > Sincerely, > > Gene Wirchenko > > [excessive quoting removed by server]

4 7

Re: Filtering Oddity
by Gene Wirchenko 15 May '19

15 May '19

At 11:01 2019-05-15, Koen Piller <koen.piller(a)gmail.com> wrote: >Gene >I would like to see an actual situation where set filter is preferable over >select() according to you. I put such a case in the message of mine that you replied to! >Regards >Koen > >Op wo 15 mei 2019 om 19:49 schreef Gene Wirchenko <gene(a)shaw.ca> > > > At 02:00 2019-05-15, Koen Piller <koen.piller(a)gmail.com> wrote: > > >Hi, > > >The use of 'Set Filter' in VFP is outdated. Nowadays we use > > >Select....from...Where...into > > > > Who is "we"? Here is the case you are asking for: > > Your select statement does not do the same thing. I use set > > filter to check for data having certain properties especially when I > > am likely to change said data. It is excellent for when I wish to > > diddle some data to force an error condition during program testing. From there, I can browse the data and change it as needed. Or I could use replace. These commands and others were what I was referring to in this paragraph: > > Many xBASE commands are very good for use in exploration, > > debugging, testing, and the like. Sincerely, Gene Wirchenko

1 0

Re: Filtering Oddity
by Gene Wirchenko 15 May '19

15 May '19

At 16:43 2019-05-14, Ted Roche <tedroche(a)gmail.com> wrote: >On Tue, May 14, 2019 at 6:46 PM Gene Wirchenko <gene(a)shaw.ca> wrote: > > > > > use cwkf > > set filter to validto>={^2019.01.01} > > count > > browse > > > > 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? > > > >No, SET FILTER is an ancient command that doesn't seem to accept anything >other than the literal expression inline. Your two-line macro expansion is >likely the fastest and simplest. I posted about this problem to foxite.com as well. Yuri Rubinov suggested EXECSCRIPT("SET FILTER TO "+FILTER()+" and empty(wfccccd)") which works. [snip] Sincerely, Gene Wirchenko

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox May 2019