ProFox

profox@leafe.com

2704 discussions

Virtual Fox Fest 2020: Speakers, Sessions, and Registration
by Rick Schummer 15 Jul '20

15 Jul '20

Speakers (https://virtualfoxfest.com/speakers.aspx) and Sessions (https://virtualfoxfest.com/sessions.aspx) for Virtual Fox Fest 2020 have been announced, and registration (http://geekgatherings.com/Registration) is open! Virtual Fox Fest is October 15, 21, and 27, 2020! Only 92 days until we gather virtually via the Internet! Rick White Light Computing, Inc. www.whitelightcomputing.com

1 0

[NF] Less Filling or Tastes Great?
by Stephen Russell 13 Jul '20

13 Jul '20

https://www.youtube.com/watch?v=5ycx9hFGHog -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 4

Bizarre scenario solved by READWRITE clause on end of SELECT SQL
by MB Software Solutions, LLC 10 Jul '20

10 Jul '20

VFP9SP2 (build 7423) on Win2K12 Terminal Server client user. Screenshot: https://www.screencast.com/t/EYptATFR3ETW Client said app that they have used since 2016 is now acting strange. In short, a record count being reported about a cursor was now erroneous. Underlying cause I found was that VFP was just filtering on the underlying table, returning the record count of the actual DBF instead of the record count returned in the query. Solution was to add the READWRITE clause. *** mjb 06/24/2020 - dev note: select was settng _tally = 1 but yet RECCOUNT was using the Order.dbf instead! Solution was to add READWRITE clause. SELECT invoice ; FROM broker!order f1 ; WHERE vendor_id = liVendorID AND ven_inv = loRec.ven_inv ; INTO CURSOR cur2ndChance READWRITE IF RECCOUNT('cur2ndChance') = 1 THEN && found it llFound = .T. liLoadNum = cur2ndChance.invoice ELSE this.AddToExceptionReport(loRec, RECCOUNT('cur2ndChance')) ENDIF USE IN SELECT('cur2ndChance') && done with it Now again, keep in mind that this solution has been working for years...and when we did an update recently to the database (including the ORDER.dbf table), then this problem arose. We did NOT update this program! I vaguely recall the Foxperts here saying how VFP, rather than create a new cursor, would filtering the underlying DBF instead, but what puzzles me is why this solution worked for 4 years and then suddenly didn't?!??!? Appreciate your thoughts on this, --Mike -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

10 23

[NF] WIN 10 Won't Update App
by Charles Hart Enzer, M.D. 10 Jul '20

10 Jul '20

When trying to update apps on PC, error: "the feature you are trying to use is on a network resource that is unavailable" OS - WIN 10 Pro - Version 1909 - Latest Quality Update - 2020-06 Cumulative Update for Windows 10 Version 1909 for x64-based Systems (KB4560960) Apps include - Chrome - Everynote - HanDBase - Calibre -- *Shai / שי **Charles Hart Enzer, MD(Retired, **Ohio**), 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> "*There are no bad soldiers, there are bad commanders*" *Israel Defense Forces (IDF)* --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 3

[NF] VirtualBox
by Charles Hart Enzer, M.D. 07 Jul '20

07 Jul '20

Error trying to install VirtualBox *Installation failed:* *Error: The system cannot find the file specified* The EXE is on the F Drive of the Dell Optiplex 3060 - WIN 10 Pro 64 Bit Version 1909 - C Drive is am SSD - Wanting to Install to F Drive -- *Shai / שי **Charles Hart Enzer, MD(Retired, **Ohio**), 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> "*There are no bad soldiers, there are bad commanders*" *Israel Defense Forces (IDF)* --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 1

RE: DBFs Server 2012 R2 very slow with Certain Processors
by Philip Borkholder 07 Jul '20

07 Jul '20

Thank you Dave, We did shut off all the power saving features of the NIOC. I'll try these other settings. Philip ---------- Original Message ---------- From: Dave Crozier <DCrozier(a)flexipol.co.uk> To: profoxtech(a)leafe.com Subject: RE: DBFs Server 2012 R2 very slow with Certain Processors Date: Tue, 7 Jul 2020 08:59:20 +0000 Philip, Check the NIOC and set it to default to 1Gb and not use the "Auto" feature to decide what speed it is running at i.e. in the Advanced Properties of the network card set Speed & Duplex to be 1.00Gb and set Auto Disable Gigabit to disabled (if this setting is present). Also, sometimes the "Green Ethernet" setting allows the NIC to go to sleep so try disabling this as well. Dave Flexipol® Packaging Ltd T 01706 222 792 E DCrozier(a)flexipol.co.uk W https://www.flexipol.co.uk/ Follow us: Unit 14 Bentwood Road, Carrs Industrial Estate, Haslingden, Lancashire, BB4 5HH This communication and the information it contains is intended for the person or organisation to whom it is addressed. Its contents are confidential and may be protected in law. If you have received this e-mail in error you must not copy, distribute or take any action in reliance on it. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the risk of virus transmission through email and therefore any files sent via e-mail will have been checked for known viruses. However, you are advised to run your own virus check before opening any attachments received as Flexipol Packaging Ltd will not in any event accept any liability whatsoever once an e-mail and/or any attachment is received. It is the responsibility of the recipient to ensure that they have adequate virus protection. -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  Terms & Conditions: Notwithstanding delivery and the passing of risk in the goods, the property in the goods shall not pass to the buyer until the seller Flexipol Packaging Ltd. ("The Company") has received in cash or cleared funds payment in full of the price of the goods and all other goods agreed to be sold by the seller to the buyer for which payment is then due. Until such time as the property in the goods passes to the buyer, the buyer shall hold the goods as the seller's fiduciary agent and bailee and keep the goods separate from those of the buyer and third parties and properly stored protected and insured and identified as the seller's property but shall be entitled to resell or use the goods in the ordinary course of its business. Until such time as the property in the goods passes to the buyer the seller shall be entitled at any time -----Original Message----- From: ProFox <profox-bounces(a)leafe.com> On Behalf Of Philip Borkholder Sent: 06 July 2020 18:30 To: profox(a)leafe.com Subject: Re: DBFs Server 2012 R2 very slow with Certain Processors Thank you Ted, I'll have him test this out. When I looked at the properties of the NIC driver, it said it was connected at 1GB but that probably is what you were pointing out. Question to you though: won't the speedtest.net just test the Internet connection speed rather than the LAN speed? Thanks, Philip ---------- Original Message ---------- From: Ted Roche <tedroche(a)gmail.com> To: profoxtech(a)leafe.com Subject: Re: DBFs Server 2012 R2 very slow with Certain Processors Date: Fri, 3 Jul 2020 15:07:17 -0400 Phil: 1. Can you confirm the local machine's network is actually running at full speed? Just because the driver thinks it's connected at 1Gbps doesn't mean it isn't rejecting 90% of packets. Try https://speedtest.net on this and another machine on the network to ensure there's not some blockage at the networking level. 2. Is it possible to (temporarily) move a set of DBFs locally to the machine, and see if the app runs okay with local data? This will determine if it is the local machine (bad CPU, bad RAM, something-something-local) or if the problem is the network or the server. In my experience, there's often a configuration problem on a new machine that needs adjustment. The machine's logs would show this. 3. Ensure the new machine is up to date in Windows updates and also drivers supplied by the vendor -- an amazing number of machines ship with software that doesn't work until it's updated. On Thu, Jul 2, 2020 at 2:08 PM Philip Borkholder <plborker(a)netzero.net> wrote: > I just set all three registry settings back to their > defaults:DirectoryCacheLifetime=10FileInfoCacheLifetime=10FileNotFound > CacheLifetime=5 There was no increase in speed. Anyone have any other > advice? > Thanks,Philip > ---------- Original Message ---------- > From: "Philip Borkholder" <plborker(a)netzero.net> > To: profoxtech(a)leafe.com > Subject: Re: DBFs Server 2012 R2 very slow with Certain Processors > Date: Thu, 2 Jul 2020 17:24:16 GMT > > Followup question Alan,When you stopped setting these to zero because > Win > 10 was "fixed" How did you leave the File Server LanManServer settings > for > :SMB1SMB2SMB3 Some recommendations out there state we need to shut off > SMB2 & 3 and turn on SMB1 on newer File Servers This File Server has > not shut off SMB2 or 3 My understanding was that the 3 Registry > settings I listed were set to zero then to compensate for not shutting > of SMB2 & 3 Thanks,Philip > > ---------- Original Message ---------- > From: "Alan Bourke" <alanpbourke(a)fastmail.fm> > To: profoxtech(a)leafe.com > Subject: Re: DBFs Server 2012 R2 very slow with Certain Processors > Date: Thu, 02 Jul 2020 17:44:36 +0100 > > On Thu, 2 Jul 2020, at 4:11 PM, Philip Borkholder wrote: > > > I set the LanManWorkstation > > settings for to avoid CDX > > > corruption:[HKEY_LOCAL_MACHINE\\\\SYSTEM\\\\CurrentControlSet\\\\Servi > ces\\\\LanmanWorkstation\\\\Parameters] > > FileInfoCacheLifetime = > > 0FileNotFoundCacheLifetime=0DirectoryCacheLifetime=0 > > Set them back to the defaults again (10 or 15 in each case IIRC), set > to zero they can cause serious speed issues and aren't needed unless > you are experiencing the particular corruption issues that zeroing them fixes. > AFAIK recent Windows 10 versions have fixed whatever MS broke in SMB > that caused these corruption issues in VFP (and MS Access). > > > > -- > Alan Bourke > alanpbourke (at) fastmail (dot) fm > [excessive quoting removed by server]

1 0

Re: DBFs Server 2012 R2 very slow with Certain Processors
by Philip Borkholder 07 Jul '20

07 Jul '20

Thank you Ted, I'll have him test this out. When I looked at the properties of the NIC driver, it said it was connected at 1GB but that probably is what you were pointing out. Question to you though: won't the speedtest.net just test the Internet connection speed rather than the LAN speed? Thanks, Philip ---------- Original Message ---------- From: Ted Roche <tedroche(a)gmail.com> To: profoxtech(a)leafe.com Subject: Re: DBFs Server 2012 R2 very slow with Certain Processors Date: Fri, 3 Jul 2020 15:07:17 -0400 Phil: 1. Can you confirm the local machine's network is actually running at full speed? Just because the driver thinks it's connected at 1Gbps doesn't mean it isn't rejecting 90% of packets. Try https://speedtest.net on this and another machine on the network to ensure there's not some blockage at the networking level. 2. Is it possible to (temporarily) move a set of DBFs locally to the machine, and see if the app runs okay with local data? This will determine if it is the local machine (bad CPU, bad RAM, something-something-local) or if the problem is the network or the server. In my experience, there's often a configuration problem on a new machine that needs adjustment. The machine's logs would show this. 3. Ensure the new machine is up to date in Windows updates and also drivers supplied by the vendor -- an amazing number of machines ship with software that doesn't work until it's updated. On Thu, Jul 2, 2020 at 2:08 PM Philip Borkholder <plborker(a)netzero.net> wrote: > I just set all three registry settings back to their > defaults:DirectoryCacheLifetime=10FileInfoCacheLifetime=10FileNotFoundCacheLifetime=5 > There was no increase in speed. Anyone have any other advice? > Thanks,Philip > ---------- Original Message ---------- > From: "Philip Borkholder" <plborker(a)netzero.net> > To: profoxtech(a)leafe.com > Subject: Re: DBFs Server 2012 R2 very slow with Certain Processors > Date: Thu, 2 Jul 2020 17:24:16 GMT > > Followup question Alan,When you stopped setting these to zero because Win > 10 was "fixed" How did you leave the File Server LanManServer settings for > :SMB1SMB2SMB3 Some recommendations out there state we need to shut off SMB2 > & 3 and turn on SMB1 on newer File Servers This File Server has not shut > off SMB2 or 3 My understanding was that the 3 Registry settings I listed > were set to zero then to compensate for not shutting of SMB2 & 3 > Thanks,Philip > > ---------- Original Message ---------- > From: "Alan Bourke" <alanpbourke(a)fastmail.fm> > To: profoxtech(a)leafe.com > Subject: Re: DBFs Server 2012 R2 very slow with Certain Processors > Date: Thu, 02 Jul 2020 17:44:36 +0100 > > On Thu, 2 Jul 2020, at 4:11 PM, Philip Borkholder wrote: > > > I set the LanManWorkstation > > settings for to avoid CDX > > > corruption:[HKEY_LOCAL_MACHINE\\\\SYSTEM\\\\CurrentControlSet\\\\Services\\\\LanmanWorkstation\\\\Parameters] > > FileInfoCacheLifetime = > > 0FileNotFoundCacheLifetime=0DirectoryCacheLifetime=0 > > Set them back to the defaults again (10 or 15 in each case IIRC), set to > zero they can cause serious speed issues and aren't needed unless you are > experiencing the particular corruption issues that zeroing them fixes. > AFAIK recent Windows 10 versions have fixed whatever MS broke in SMB that > caused these corruption issues in VFP (and MS Access). > > > > -- > Alan Bourke > alanpbourke (at) fastmail (dot) fm > [excessive quoting removed by server]

2 1

Re: DBFs Server 2012 R2 very slow with Certain Processors
by Philip Borkholder 06 Jul '20

06 Jul '20

Thanks Alan, I don't usually shut off SMB2 or 3 either, just others have suggested it on other forums. It always makes the speed worse. Philip ---------- Original Message ---------- From: "Alan Bourke" <alanpbourke(a)fastmail.fm> To: profoxtech(a)leafe.com Subject: Re: DBFs Server 2012 R2 very slow with Certain Processors Date: Fri, 03 Jul 2020 12:00:09 +0100 I never touch any of that Philip. You want to be running on SMB2 or SMB3. They are orders of magnitude faster than SMB1 and much more secure. In fact on newer Windows servers SMB1 isn't even present any more. -- Alan Bourke alanpbourke (at) fastmail (dot) fm On Thu, 2 Jul 2020, at 6:24 PM, Philip Borkholder wrote: > Followup question Alan,When you stopped setting these to zero because > Win 10 was "fixed" How did you leave the File Server LanManServer > settings for :SMB1SMB2SMB3 Some recommendations out there state we need > to shut off SMB2 & 3 and turn on SMB1 on newer File Servers This File > Server has not shut off SMB2 or 3 My understanding was that the 3 > Registry settings I listed were set to zero then to compensate for not > shutting of SMB2 & 3 Thanks,Philip > > ---------- Original Message ---------- > From: "Alan Bourke" <alanpbourke(a)fastmail.fm> > To: profoxtech(a)leafe.com > Subject: Re: DBFs Server 2012 R2 very slow with Certain Processors > Date: Thu, 02 Jul 2020 17:44:36 +0100 > > On Thu, 2 Jul 2020, at 4:11 PM, Philip Borkholder wrote: > > > I set the LanManWorkstation > > settings for to avoid CDX > > corruption:[HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Services\\LanmanWorkstation\\Parameters] > > FileInfoCacheLifetime = > > 0FileNotFoundCacheLifetime=0DirectoryCacheLifetime=0 > > Set them back to the defaults again (10 or 15 in each case IIRC), set > to zero they can cause serious speed issues and aren't needed unless > you are experiencing the particular corruption issues that zeroing them > fixes. AFAIK recent Windows 10 versions have fixed whatever MS broke in > SMB that caused these corruption issues in VFP (and MS Access). > > > > -- > Alan Bourke > alanpbourke (at) fastmail (dot) fm > [excessive quoting removed by server]

1 0

[NF] Hyper-V
by Charles Hart Enzer, M.D. 06 Jul '20

06 Jul '20

What problems might I have loading Hyper-V onto my PC WIN 10 Pro 64bit I want to run a WIN 3.1 and DOS programs I would install WIN 95 on Hyper-V -- *Shai / שי **Charles Hart Enzer, MD(Retired, **Ohio**), 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> *Retirement is **not What You are Retiring from* *Retirement is about What You are Retiring to* --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

[NF] Workstation Installation Incompatible after WIN10 Upgrade
by Charles Hart Enzer, M.D. 06 Jul '20

06 Jul '20

For versions of VMWare Workstations 12 thru 15, *Troubleshooter* Program reports "Incompatible Program" Host is WIN 10 Pro 64 Bit Version 1909 C Drive is am SSD Installing to F Drive Error installing Workstation 15 *Setup cannot continue. The Microsoft Runtime DLL installer failed to complete installation* -- *Shai / שי **Charles Hart Enzer, MD(Retired, **Ohio**), 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> *Retirement is **not What You are Retiring from* *Retirement is about What You are Retiring to* --- 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