ProFox May 2021

profox@leafe.com

16 participants
17 discussions

SET ANSI OFF
by MB Software Solutions, LLC 12 May '21

12 May '21

I was investigating why a simple query (SELECT DISTINCT srep FROM order WHERE srep <> "") worked on my machine and yet when deployed, it did NOT work. Instead of returning several dozen names, it was returning zero. Now..."why did it work before?" Well, I had changed the query from using WHERE NOT EMPTY(srep) to what you see at the top of this post. I figured it was the SET ANSI and confirmed it. I see the original developer explicitly says in the startup code SET ANSI OFF. I just can't understand why. This is very old code so I ask those who've been in the Fox game since 2.x days---was this an advantage when using some sort of xBase approach? I realize from VFP help that SET ANSI ON basically makes sure string comparisons are of equal length. I'm nervous about changing the value at startup because there are probably areas where the code is COUNTING on it. I see they also have SET NEAR ON and SET EXACT OFF. I guess code where I'm putting my own SQL in there (or changing it), I should save their settings, set as I would normally work (EXACT ON, ANSI ON, NEAR OFF), and then restore their settings. Kinda like that WorkAreaSave class that I learned (from Andy/Marcia?) way back when to use a lightweight class in a local variable to save the current work area when you start a procedure/function and then it restores it because the LOCAL variable is released on exit. -- Michael J. Babcock, MCP Fox/VFP dev since 1997 Developer of FabNet estimating software - mbsoftwaresolutions.com

1 0

Free Windows 10 development VMs
by Alan Bourke 11 May '21

11 May '21

FWIW, for Windows 10 application development and testing purposes you can download free virtual machines for VMWare, Hyper-V, Virtualbox and Parallels from: https://developer.microsoft.com/en-us/windows/downloads/virtual-machines/?W… These VM images come with these items pre-installed. * Windows 10, version 2004 (10.0.19041.0) * Windows 10 SDK, version 2004 (10.0.19041.0) * Visual Studio 2019 <https://developer.microsoft.com/windows/downloads?WT.mc_id=-blog-scottha> with the UWP, .NET desktop, and Azure workflows enabled and also includes the Windows Template Studio extension * Visual Studio Code * Windows Subsystem for Linux enabled with Ubuntu installed * Developer mode enabled The catch? They expire, although not for two months. Great for testing or messing around without screwing up your main dev environment. -- Alan Bourke alanpbourke (at) fastmail (dot) fm --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

RE: Drag and Drop code
by Jürgen Wondzinski 08 May '21

08 May '21

Just wondering: Why not use Grids with AllowCellSelection = .f. and HighLightStyle = 2 ? You'll get so much more possibilities (optical as well as technical) in comparison to Listboxes But back to your problem: So you want to drag players from the left list to any of those Team groups as well as criss-cross ? wOOdy -----Ursprüngliche Nachricht----- Von: ProFox <profox-bounces(a)leafe.com> Im Auftrag von MB Software Solutions, LLC Gesendet: Montag, 3. Mai 2021 21:44 An: ProFox Email List <profox(a)leafe.com> Betreff: Drag and Drop code Many many moons ago I did some drag and drop code, but I have forgotten completely and it's no longer in my possession anyway. I want to drag names amongst a screen full of listboxes: https://www.screencast.com/t/6M8XxvSFV I know I need to code in the OLEDragDrop event and native VFP Help sucks, not really showing me anything. I was thinking the oDataObject was the listbox where the drag started but no. I tried to SET STEP ON but VFP says "CANCEL or SUSPEND is not allowed." LPARAMETERS oDataObject, nEffect, nButton, nShift, nXCoord, nYCoord LOCAL loLB as ListBox loLB = oDataObject wait window loLB.ListCount && this fails SET STEP ON && this doesn't work either I have the properties set correctly to allow me to drag from one list to another but now I'm stuck. Going to search the archives next but throwing this out there in the meantime. Was hoping to have drag/drop implemented by the time I had a ZOOM call with my fellow hockey captains to set the teams tonight! tia, --Michael -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus [excessive quoting removed by server]

2 6

_framewk,vct is missing or invalid, but it isn't and it's not.
by Ted Roche 04 May '21

04 May '21

Rebuilding a project that includes c:\program files (x86)\microsoft visual foxpro 9\wizards\_framewk.vcx gives the error Memo file c:\program files (x86)\microsoft visual foxpro 9\wizards\_framewk.VCT is missing or invalid. But it isn't and it's not. I copied both _framewk files from another machine where it works, no change. I opened the file exclusively and tried to PACK and get the same error. I copy the two files to C:\temp and they pack fine, and compile classlib works there (after I also copied over _framewk.h) but moving the files back to the above directory and attempting a build project, rebuild all throws the same error. This is a permissions issue with the program files (x86) folder and I've tried turning off the "Read Only" settings and in the folder permissions granting Modify and Write to the Users group, but the errors continue. Any suggestions on how to get the Program files (x86) to be read-write for VFP? Moving the files to the project folder would be my preference, but it is not my project. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

7 16

Drag and Drop code
by MB Software Solutions, LLC 03 May '21

03 May '21

Many many moons ago I did some drag and drop code, but I have forgotten completely and it's no longer in my possession anyway. I want to drag names amongst a screen full of listboxes: https://www.screencast.com/t/6M8XxvSFV I know I need to code in the OLEDragDrop event and native VFP Help sucks, not really showing me anything. I was thinking the oDataObject was the listbox where the drag started but no. I tried to SET STEP ON but VFP says "CANCEL or SUSPEND is not allowed." LPARAMETERS oDataObject, nEffect, nButton, nShift, nXCoord, nYCoord LOCAL loLB as ListBox loLB = oDataObject wait window loLB.ListCount && this fails SET STEP ON && this doesn't work either I have the properties set correctly to allow me to drag from one list to another but now I'm stuck. Going to search the archives next but throwing this out there in the meantime. Was hoping to have drag/drop implemented by the time I had a ZOOM call with my fellow hockey captains to set the teams tonight! tia, --Michael -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

2 2

VFP9 (and VFPA) on Windows 10 -- wish Mr. Chen would fix the visual bugs!
by MB Software Solutions, LLC 03 May '21

03 May '21

I finally moved my dev to a Windows 10 laptop. Was using Win7 forever prior. The window dialog border "phantoms/shadows" is very annoying. It'd be great if Mr. Chen fixed in addition to the other bugs he's fixed! (I think I have his name wrong...I've looked on his http://www.baiyujia.com/vfpadvanced/f_vfpa_gotovfpa64.asp site but I just see CCB)

4 6

ProFox List Statistics for April 2021
by List Administrator Account 01 May '21

01 May '21

================================================== ProFox List Statistics April 2021 ================================================== Subscriber Count at End of Month: ProFox: 296 ProFoxTech: 183 ================================================== Total Posts: 92 (Up 10.84% from March 2021) Total [OT] Posts: 0 (Unchanged from March 2021) Total [NF] Posts: 11 (Down 35.29% from March 2021) Daily Message Counts for April 2021 ------------------------------------------------ DOW Date Count --- ---- ----- T 1 - 1 F 2 - 10 T 6 - 7 W 7 - 2 T 8 - 3 F 9 - 2 M 12 - 1 W 14 - 4 T 15 - 11 F 16 - 20 S 17 - 6 M 19 - 4 T 20 - 1 W 21 - 2 T 22 - 2 F 23 - 8 S 24 - 1 M 26 - 1 T 29 - 2 F 30 - 4 Message Counts By Day of Week for April 2021 ------------------------------------------------ DOW Count --- ----- Mon - 6 Tue - 8 Wed - 8 Thu - 19 Fri - 44 Sat - 7 Distinct Posters to the List (changes relative to March 2021) ------------------------------------------------ Non-OT messages: 25 (Up 8.7%) OT messages: 0 (Unchanged) NF messages: 5 (Down 37.5%) Total number: 25 (Up 8.7%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 15 Richard Kaye 2. 13 MB Software Solutions, LLC 3. 9 Alan Bourke 4. 5 Ed Leafe 5. 4 Philip Borkholder 6. 4 Christof Wollenhaupt 7. 4 Malcolm Greene 8. 4 Frank Cazabon 9. 3 Stephen Russell 10. 3 Ken McGinnis 11. 3 Tracy Pearson 12. 3 Ted Roche 13. 3 Eric Selje 14. 3 Gianni Turri 15. 3 Rick Schummer 16. 2 Paul McNett 17. 2 Adam Buckland 18. 2 António Tavares Lopes 19. 1 List Administrator Account 20. 1 Dave Crozier Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 5 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 4 Ed Leafe 2. 2 Malcolm Greene 3. 2 MB Software Solutions, LLC 4. 2 Stephen Russell 5. 1 Eric Selje Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 15 Richard Kaye 2. 13 MB Software Solutions, LLC 3. 9 Alan Bourke 4. 5 Ed Leafe 5. 4 Philip Borkholder 6. 4 Christof Wollenhaupt 7. 4 Malcolm Greene 8. 4 Frank Cazabon 9. 3 Stephen Russell 10. 3 Ken McGinnis 11. 3 Tracy Pearson 12. 3 Ted Roche 13. 3 Eric Selje 14. 3 Gianni Turri 15. 3 Rick Schummer 16. 2 Paul McNett 17. 2 Adam Buckland 18. 2 António Tavares Lopes 19. 1 List Administrator Account 20. 1 Dave Crozier Top 7 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 3 MB Software Solutions, LLC 2. 2 Rick Schummer 3. 2 Ken McGinnis 4. 1 List Administrator Account 5. 1 Philip Borkholder 6. 1 Richard Kaye 7. 1 Stephen Russell Top 17 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 28 Variations in CSV settings by region 2. 15 File Server Sharing SMB1: W10 Update KB5001330 shuts off SMB1 3. 9 looking for a multi-user alternative to view gmail emails 4. 6 [NF] VS 2022 will be 64 bit they say. 5. 6 Paul McNett 6. 5 Interesting Error 1426 on COPY TO (lcFile) FIELDS a, b, c FOR condition TYPE XL5 7. 5 [NF] Desktop Development in the roaring 20s 8. 4 Virtual Fox Fest 2021 (May): Time to Register 9. 3 VFP9 (and VFPA) on Windows 10 -- wish Mr. Chen would fix the visual bugs! 10. 3 Interesting Error 1426 on COPY TO (lcFile) FIELDS a, b, c FOR condition TYPE XL5 11. 2 VFP9 (and VFPA) on Windows 10 -- wish Mr. Chen would fix the visual bugs! 12. 1 ProFox List Statistics for March 2021 13. 1 Virtual Fox Fest 2021 (May) is almost here! 14. 1 More required to make things work nowadays (was Paul McNett) 15. 1 VFP9 (and VFPA) on Windows 10 -- wish Mr. Chen would fix the visual bugs! 16. 1 Virtual Fox Fest 2021 (May): Procrastinators Unite and Register Today! 17. 1 Fwd: looking for a multi-user alternative to view gmail emails Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 17 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 28 Variations in CSV settings by region 2. 15 File Server Sharing SMB1: W10 Update KB5001330 shuts off SMB1 3. 9 looking for a multi-user alternative to view gmail emails 4. 6 [NF] VS 2022 will be 64 bit they say. 5. 6 Paul McNett 6. 5 Interesting Error 1426 on COPY TO (lcFile) FIELDS a, b, c FOR condition TYPE XL5 7. 5 [NF] Desktop Development in the roaring 20s 8. 4 Virtual Fox Fest 2021 (May): Time to Register 9. 3 VFP9 (and VFPA) on Windows 10 -- wish Mr. Chen would fix the visual bugs! 10. 3 Interesting Error 1426 on COPY TO (lcFile) FIELDS a, b, c FOR condition TYPE XL5 11. 2 VFP9 (and VFPA) on Windows 10 -- wish Mr. Chen would fix the visual bugs! 12. 1 ProFox List Statistics for March 2021 13. 1 Virtual Fox Fest 2021 (May) is almost here! 14. 1 More required to make things work nowadays (was Paul McNett) 15. 1 VFP9 (and VFPA) on Windows 10 -- wish Mr. Chen would fix the visual bugs! 16. 1 Virtual Fox Fest 2021 (May): Procrastinators Unite and Register Today! 17. 1 Fwd: looking for a multi-user alternative to view gmail emails

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox May 2021