ProFox May 2019

profox@leafe.com

33 participants
48 discussions

Re: Filtering Oddity
by Gene Wirchenko 15 May '19

15 May '19

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

1 0

Re: Filtering Oddity
by Ted Roche 15 May '19

15 May '19

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. But there are lots of workarounds: 1. Add the filter on to the commands: count for empty(wfccccd) browse for empty(wfccccd) 2. Use SQL: SELECT Count(*) FROM cwkf WHERE EVALUATE(FILTER("cwkf")) AND empty(wfccccd) SELECT * FROM cwkf WHERE EVALUATE(FILTER("cwkf")) AND empty(wfccccd) 3. Up-arrow twice and add the filter expression to the end of the filter. ;) -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 4

Filtering Oddity
by Gene Wirchenko 14 May '19

14 May '19

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

1 0

X# update and VFP support progress
by Johan Nel 14 May '19

14 May '19

Hi all X# followers, Just an update. With respect to VFP, (VFP members and I) have received in a private message the ANTLR lexical parser fingerprint for VFP and it shows very good progress on VFP syntax support. Here is the update that was published today on the X# website. Progress report May 2019 - Created: 12 May 2019 It's time for a quick update about what we have been doing. Here are some things that we have worked on since the last build: * We have started work on the FoxPro dialect and have also added a WITH block for all dialects * We have also added support for END keywords for entities that do not allow this yet, suchas END PROCEDURE,END METHOD,END ACCESS etc. These keywords are optional * We made several changes to improve the VS integration, such as better type lookup for functions declaredin namespaces, better supportfor the var keyword, improved supportfor Xbase++ dialect etc. X# works fine nowwith VS 2019,except that ourproject templates are still poorlyvisible on theNew Project dialect. Microsoft has now promisedto change thatin oneof the upcoming updates. * We have made several changes to the runtime. For example dynamic class creation for the Xbase++ dialect (ClassCreate() etc) and for the Xbase++ DataObjectclass. We have also added the functions that are partof the ASXMLLibrary from Xbase++ (XMLDocOpen() etc). * We have also improved several existing functions, such as Round(), ExecName() and others. * We have made several changes to the macro compiler, to solve some of the problems that were reported. * We have also added support for macro based aliased expressions and ivar access ( (alias)->&varname, expression:&ivarname etc) * And last but not least we have worked on the RDD system. Several small issues were detected and fixed in the Advantage RDD and the workon the DBFCDX driver is approaching theend. We expectto have a fully working DBFCDX rddany day now. More news will follow soon. Johan Nel George, South Africa FOX member: Friends of XSharp X# Website: https://xsharp.info <https://xsharp.info/>

4 5

[NF] Advice about Phone from eBay
by Charles Hart Enzer, M.D. 14 May '19

14 May '19

Please advise I bought a new Galaxy S7 on eBay Serial number on phone's label on the back back different than software - - *#06# The IMEs are the same My tests of phone 100%: https://lv.testm.com/latest-test?testId=5194455 Seller says: New message from: is.prime (3,029) The issue you mentioned may caused by the unlock procedure Would you mind keeping the phone to use if we refund $20 to you make as compensation and send a B&O earphone to you ? The B&O earphone value is 50USD. We wait for your news best regards Lotus Your previous message The Serial Number on the Back of the phone is not the same as in the phone. And the sticker was loose -- not glued. Thank you New Samsung Galaxy S7 G930T T-MOBILE 5.1" Unlocked Smartphone/Black Onyx/32GB eBay sent this message to Charles Enzer (enzerch). Learn more about account protection. eBay is committed to your privacy. Learn more about our privacy notice and user agreement. *Shai / שי **Charles Hart Enzer, MD(Ohio, USA), FAACAP* *Aliyah <https://en.wikipedia.org/wiki/Aliyah>: Cincinnati to Jerusalem <http://www.gojerusalem.com/items/263/German-Colony/>'s German Colony <https://en.wikipedia.org/wiki/German_Colony,_Jerusalem> May, 2017* *Volunteer Associate Professor of PsychiatryUniversity of Cincinnati Medical CenterWebSite: **EnzerMD.com <http://EnzerMD.com>* *Publications* <http://www.enzermd.com/CV.html#Publications> *Tiny Country, Huge Dreams* *ארץ זעירה, **חלומות ענקיים* *עם ישראל חי* --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 1

Southwest Fox 2019: Speakers and Sessions announced
by Rick Schummer 10 May '19

10 May '19

Speakers (http://swfox.net/speakers.aspx) and sessions (http://swfox.net/sessionsswfox.aspx) for Southwest Fox 2019 have been announced. Only 171 days until we gather in Gilbert. Regards, Rick Schummer, Doug Hennig, and Tamar Granor

3 2

ProFox Messages are not showing up
by Charlie-gm 08 May '19

08 May '19

Not sure what is going on. I got a weird message the other day saying my account has gotten a lot of bounces. Could someone drop a note when they see this in the list (I should have prefixed this with [OT] or [NF] but I wanted to see if the most "visible" target is going through). -Charlie

10 13

Re: Old Andy Kramek trick from WhilFest years ago...I can't recall exactly how he said it
by Gene Wirchenko 08 May '19

08 May '19

At 19:25 2019-05-07, "MB Software Solutions, LLC" <mbsoftwaresolutions(a)mbsoftwaresolutions.com> wrote: >On 5/7/2019 8:13 PM, Gene Wirchenko wrote: > Â Â >Â Â I set .lockscreen to .t. at the beginning >of instantiating a form > and back to .f. after >the setup.Â I have not looked at the speed-up > >recently, but in my testing years ago, it made >about a 20% difference. > > Â Â Â Â I do not >use it otherwise. > When you say "after the >Setup", Gene, what event is that...Show() ? I misstated some. The following is after a code check. First of all, at the beginning and end of form .init(). Secondly, I have some display routines where a lot happens (basically, a lot of .enable setting). To avoid flicker, I use .lockscreen there, too. I use .lockscreen minimally. I am not trying to do tricks to speed up display maximally but rather enough that it works. My display methods are not .show() -- it has never occurred to me to add code to .show() -- but custom methods. They often call .refresh() indirectly. ("indirectly" because I usually do not directly call methods where there is an event of the same name. I tend to call a method that does that call.) Sincerely, Gene Wirchenko

1 0

Re: Old Andy Kramek trick from WhilFest years ago...I can't recall exactly how he said it
by MB Software Solutions, LLC 08 May '19

08 May '19

On 5/7/2019 8:13 PM, Gene Wirchenko wrote: > I set .lockscreen to .t. at the beginning of instantiating a form > and back to .f. after the setup. I have not looked at the speed-up > recently, but in my testing years ago, it made about a 20% difference. > > I do not use it otherwise. > When you say "after the Setup", Gene, what event is that...Show() ? --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

1 0

RE: Old Andy Kramek trick from WhilFest years ago...I can't recall exactly how he said it
by juergen＠wondzinski.de 08 May '19

08 May '19

Hi Gene, yepp, either be very serious about the counterparts, or just issue a thisform.lockscreen = 0 and don't give a shit about that counterparts; just flip it to OFF in any situation. wOOdy -----Ursprüngliche Nachricht----- Von: MB Software Solutions, LLC <mbsoftwaresolutions(a)mbsoftwaresolutions.com> Gesendet: Mittwoch, 8. Mai 2019 00:15 An: juergen(a)wondzinski.de Betreff: Re: AW: Old Andy Kramek trick from WhilFest years ago...I can't recall exactly how he said it Oh, so the Lockscreen = .T. commands along a process path would accumulate and thus you'd need an equal number of offsetting Lockscreen = .F. commands to make things right? That might explain some weirdness I've seen over the years when I had set Lockscreen=.T. in Routine_A but then it called Routine_B which called Routine_C etc and some of those may have also have Lockscreen = .T. commands. I suppose the takeaway there is make sure you have the Lockscreen = .F. in the same routine as its counterpart? On 5/7/2019 6:05 PM, juergen(a)wondzinski.de wrote: > Maybe it was, that Lockscreen also accepts a numeric 0 instead of .F. > Every lockscreen = .t. increments an internal counter, and every lockscreen = .F. decrements it. Thus you really need to watch out to always have a balanced on/off couple count. You can override that with just setting that counter to 0, and don't care about "have I thought about every exit path in that module?" > That undocumented(?) feature is helpful if you're doing a lot of > subroutines but don't know if everyone is behaving correctly 😊 > > wOOdy > > > > -----Ursprüngliche Nachricht----- > Von: ProFox <profox-bounces(a)leafe.com> Im Auftrag von MB Software > Solutions, LLC > Gesendet: Dienstag, 7. Mai 2019 23:33 > An: profox(a)leafe.com > Betreff: Re: Old Andy Kramek trick from WhilFest years ago...I can't > recall exactly how he said it > > Hi Tracy, > > No, that's not it. I use thisform.lockscreen now. It was something more "nifty" or "crafty" with his approach. > > I don't have any issues really; was just trying to remember what was "cool" about his trick/tip that was better than Thisform.refresh. Just curiosity. > > Thanks, > --Mike > > > > _______________________________________________ > Post Messages to: ProFox(a)leafe.com > Subscription Maintenance: > http://mail.leafe.com/mailman/listinfo/profox > OT-free version of this list: > http://mail.leafe.com/mailman/listinfo/profoxtech > Searchable Archive: https://leafe.com/archives This message: > https://leafe.com/archives/byMID/007901d50520$ec780a80$c5681f80$@wondz > inski.de > ** 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. --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox May 2019