ProFox

profox@leafe.com

2704 discussions

[NF] Conditions in JOIN clause instead of WHERE
by Garrett Fitzgerald 04 Apr '19

04 Apr '19

Hey, all. I had a general SQL question. Often, I find myself needing to use the syntax: FROM a LEFT JOIN b ON a.key = b.key AND b.field = 'Value' because if I filter b.field in the WHERE clause, I've effectively made the LEFT JOIN an inner one. That makes me wonder, at what point do we stop moving conditions to the JOIN clause? Obviously, some can't move for syntactical reasons, such as subqueries. But short of that, when does it make sense to limit a non-outer join in the join criteria? Never? --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 7

Re: Happy April Fools (and not OT!)
by Gene Wirchenko 03 Apr '19

03 Apr '19

At 08:06 2019-04-01, Ted Roche <tedroche(a)gmail.com> wrote: >Former Visual FoxPro marketing flunky, and >now... "Microsoft marketing chief Chris >Capossela sent out a note to employees last week >announcing that the company had decided against >doing any public-facing stunts, because âdata >tells us these stunts have limited positive >impact and can actually result in unwanted news cycles. So if you do bad marketing, it does not work. Maybe, doing good marketing would work. [snip] Sincerely, Gene Wirchenko

1 0

X# announcement
by Johan Nel 02 Apr '19

02 Apr '19

Hi Foxers, Just to keep you up to date. The following announcement on https://xsharp.info. (Note by Johan Nel - Since Nov 2015, only 1 point was ever not on time...). XSharp roadmap 2019 The schedule below of course is an indication and as always: no guarantees. Component Start Completed (Visual) FoxPro dialect, April 2019 including runtime functions and support for VFP DBC and VFP datatypes in the DBF format VFP - X# + Visual Studio converter August 2019 SQL Classes with Unicode and AnyCPU support on top of Ado.Net June 2019 August 2019 VFP UI Classes August 2019 October 2019 -- Johan Nel Friend of XSharp (FOX) George, South Africa.

2 1

ProFox List Statistics for March 2019
by List Administrator Account 02 Apr '19

02 Apr '19

================================================== ProFox List Statistics March 2019 ================================================== Subscriber Count at End of Month: ProFox: 293 ProFoxTech: 182 ================================================== Total Posts: 181 (Up 12.42% from February 2019) Total [OT] Posts: 1 (Down 88.89% from February 2019) Total [NF] Posts: 46 (Up 91.67% from February 2019) Daily Message Counts for March 2019 ------------------------------------------------ DOW Date Count --- ---- ----- F 1 - 18 S 2 - 5 S 3 - 4 M 4 - 15 T 5 - 3 W 6 - 3 T 7 - 1 S 9 - 4 M 11 - 8 T 12 - 7 W 13 - 7 T 14 - 24 F 15 - 6 S 16 - 1 M 18 - 1 T 19 - 2 W 20 - 20 T 21 - 9 F 22 - 10 S 23 - 10 S 24 - 9 M 25 - 7 T 26 - 4 W 27 - 2 T 28 - 1 Message Counts By Day of Week for March 2019 ------------------------------------------------ DOW Count --- ----- Sun - 13 Mon - 31 Tue - 16 Wed - 32 Thu - 35 Fri - 34 Sat - 20 Distinct Posters to the List (changes relative to February 2019) ------------------------------------------------ Non-OT messages: 38 (Unchanged) OT messages: 1 (Down 85.71%) NF messages: 22 (Up 83.33%) Total number: 38 (Down 7.32%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 22 Kurt at VR-FX 2. 14 Tracy Pearson 3. 12 Ted Roche 4. 10 Fletcher Johnson 5. 9 Dave Crozier 6. 9 mbsoftwaresolutions(a)mbsoftwaresolutions.com 7. 9 Thierry Nivelet 8. 7 Stephen Russell 9. 6 Paul Newton 10. 6 Alan Bourke 11. 5 John Weller 12. 5 Gene Wirchenko 13. 5 MB Software Solutions, LLC 14. 5 Vince Teachout 15. 4 Charlie-gm 16. 4 Frank Cazabon 17. 4 Ed Leafe 18. 4 Johan Nel 19. 4 Koen Piller 20. 3 Chris Davis Top 1 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ 1. 1 9% Fletcher Johnson Top 20 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 6 Thierry Nivelet 2. 5 Fletcher Johnson 3. 4 Kurt at VR-FX 4. 3 Charles Hart Enzer, M.D. 5. 3 Alan Bourke 6. 2 Johan Nel 7. 2 Vince Teachout 8. 2 Stephen Russell 9. 2 <mike(a)morchellas.com> 10. 2 MB Software Solutions, LLC 11. 2 Eric Selje 12. 2 Tracy Pearson 13. 1 Gene Wirchenko 14. 1 John Weller 15. 1 Mike 16. 1 Joe Yoder 17. 1 Kevin J Cully 18. 1 Ted Roche 19. 1 Dave Crozier 20. 1 Paul H. Tarver Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 22 Kurt at VR-FX 2. 14 Tracy Pearson 3. 12 Ted Roche 4. 11 Fletcher Johnson 5. 9 Dave Crozier 6. 9 mbsoftwaresolutions(a)mbsoftwaresolutions.com 7. 9 Thierry Nivelet 8. 7 Stephen Russell 9. 6 Paul Newton 10. 6 Alan Bourke 11. 5 John Weller 12. 5 Gene Wirchenko 13. 5 MB Software Solutions, LLC 14. 5 Vince Teachout 15. 4 Charlie-gm 16. 4 Frank Cazabon 17. 4 Ed Leafe 18. 4 Johan Nel 19. 4 Koen Piller 20. 3 Chris Davis Top 17 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 4 MB Software Solutions, LLC 2. 2 Tracy Pearson 3. 2 Kurt at VR-FX 4. 2 <juergen(a)wondzinski.de> 5. 1 List Administrator Account 6. 1 Desmond Lloyd 7. 1 Kurt @ Gmail 8. 1 mbsoftwaresolutions(a)mbsoftwaresolutions.com 9. 1 Paul Newton 10. 1 Charlie-gm 11. 1 Chris Davis 12. 1 Dave Crozier 13. 1 Ted Roche 14. 1 Charles Hart Enzer, M.D. 15. 1 Johan Nel 16. 1 Joe Yoder 17. 1 Fletcher Johnson Top 20 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 24 UCLA & FoxPro... 2. 24 A FoxPro Transition @ UCLA... 3. 19 [NF] Looking for current summary of VFP clones 4. 13 Your laptop 5. 11 File Access Issues 6. 9 Creating a copy of a database -- best practice? 7. 8 [NF] Recomendations for VFP to Python language reference? 8. 7 Test Message - Please ignore 9. 7 Using WPF controls on Foxpro forms 10. 6 Foxwiki is down 11. 6 Windows 10 Home and VFP9SP2 apps 12. 5 [NF] Why don't more folks use RDP? 13. 4 AW: Custom Scrollbar 14. 4 FoxBin2Prg Form.Property = "" becomes .F. 15. 3 [ADMIN] Broken archive 'View Full Thread' 16. 3 A FoxPro job in NJ! 17. 3 VF9 - Running an app on a schedule.... 18. 3 [NF] AdBlade popup windows a major annoyance at one of my clients 19. 3 [NF] DVD Drive - Prerecorded DVDs not recognized 20. 3 [NF] Windows 10 versions (was Looking for current summary of VFP clones) Top 1 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 1 [OT] Test Message - Please ignore Top 20 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 24 UCLA & FoxPro... 2. 24 A FoxPro Transition @ UCLA... 3. 19 [NF] Looking for current summary of VFP clones 4. 13 Your laptop 5. 11 File Access Issues 6. 9 Creating a copy of a database -- best practice? 7. 8 [NF] Recomendations for VFP to Python language reference? 8. 7 Test Message - Please ignore 9. 7 Using WPF controls on Foxpro forms 10. 6 Foxwiki is down 11. 6 Windows 10 Home and VFP9SP2 apps 12. 5 [NF] Why don't more folks use RDP? 13. 4 AW: Custom Scrollbar 14. 4 FoxBin2Prg Form.Property = "" becomes .F. 15. 3 [ADMIN] Broken archive 'View Full Thread' 16. 3 A FoxPro job in NJ! 17. 3 VF9 - Running an app on a schedule.... 18. 3 [NF] AdBlade popup windows a major annoyance at one of my clients 19. 3 [NF] DVD Drive - Prerecorded DVDs not recognized 20. 3 [NF] Windows 10 versions (was Looking for current summary of VFP clones)

4 6

Happy April Fools (and not OT!)
by Ted Roche 01 Apr '19

01 Apr '19

Former Visual FoxPro marketing flunky, and now... "Microsoft marketing chief Chris Capossela sent out a note to employees last week announcing that the company had decided against doing any public-facing stunts, because “data tells us these stunts have limited positive impact and can actually result in unwanted news cycles.” https://www.washingtonpost.com/technology/2019/04/01/its-april-fools-day-he… -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 2

2-factor authentication in your apps
by MB Software Solutions, LLC 01 Apr '19

01 Apr '19

I see I asked this 2 years ago but apparently no replies back then: https://leafe.com/archives/full_thread/509408 Do any of you use 2-factor authentication in your apps? tia, --Mike --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

2 1

Your laptop
by MB Software Solutions, LLC 27 Mar '19

27 Mar '19

Been 6 years on my Dell Latitude 5530. Time to get a new one. What are all you cool kids using nowadays? Do you recommend it? tia, --Mike --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

8 8

Re: Your laptop
by Gene Wirchenko 27 Mar '19

27 Mar '19

At 03:29 2019-03-26, Ted Roche <tedroche(a)gmail.com> wrote: >On Mon, Mar 25, 2019 at 6:16 PM Gene Wirchenko <genew(a)telus.net> wrote: > > > At 05:01 2019-03-24, Koen Piller <koen.piller(a)gmail.com> wrote: > > >Dell , why do you change a winning team? > > > > Dell was not a winner for me. I had a Dell Optiplex. > >Dell and HP and all the rest make many lines of machines. There are >inexpensive consumer-grade machines that won't put up with daily commutes >and intense usage. There are servers designed for long-term support and >predictable although mediocre performance, There are gaming laptops. >Finally, there are professional machines that developers would need. > >If you buy a sports car, you can't complain it's lousy for hauling manure. But I can complain that a laser printer not even getting through two toner cartridges in light use is just not good enough. >If you want a professional machine, a Dell Lattitude or Lenovo ThinkPad T >or X are the product lines from those two vendors. I'm sure other vendors >also have good machines, I'm just less familiar with them. Sincerely, Gene Wirchenko

1 0

Re: Your laptop
by Gene Wirchenko 26 Mar '19

26 Mar '19

At 05:01 2019-03-24, Koen Piller <koen.piller(a)gmail.com> wrote: >Dell , why do you change a winning team? Dell was not a winner for me. I had a Dell Optiplex. The laser printer I did not use heavily. Possibly, the printer resented this as it died after using about 1.2 toner cartridges. Yes, that is one and a fifth. A few months later, the computer itself died. Loneliness? I still have the monitor though. Winning team or not, there may be other brands with some useful features that you find useful though computers are rather commodity. [snip] Sincerely, Gene Wirchenko

4 3

[ADMIN] Broken archive 'View Full Thread'
by Ted Roche 25 Mar '19

25 Mar '19

Ed: Seeing some funny misbehavior with the archive, or perhaps people are reposting old message threads. When I look at message https://leafe.com/archives/msg/512987 that Mike posted yesterday, and select the link for "View Entire Thread" the link is: https://leafe.com/archives/full_thread/512987 But the resulting message is from 2004! That's a long thread, even for us! -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 2

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox