ProFox December 2017

profox@leafe.com

47 participants
60 discussions

[NF] DB Code reuse anyone?
by Stephen Russell 08 Dec '17

08 Dec '17

Stored Procedures by a better name. Write it once there and call if from your app as needed. Learn how to use params as well in this simple introduction. https://www.mssqltips.com/sqlservertutorial/168/different-options-for-creat… -- 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 ---

1 0

Re: [NF] Restart now or later?
by Ken Dibble 08 Dec '17

08 Dec '17

>Windows is shipping new updates early this month. In the latest >"Windows 10 Fall Creators Edition Update" version, they now have a >pretty panel and call them "Feature Updates" rather than bug fixes, >but you know what that means. > >Info on the Windows Security Site [1] seems to indicate it's a fix for >many of their security products. That, combined with the week-early >date, make me suspect something's in the wild they don't want people >to catch. "Ask Woody" has a post at 8:30 am his time today referencing CVE-2017-11937. He promises a fuller post later on ComputerWorld. Meanwhile, other links say this is an issue with the Windows "Malware Protection Engine"--Windows Defender. The reason why Windows Defender isn't good enough is because it is manufactured by the same company that makes the OSes that it's supposed to protect. It is likely dependent on code in those OSes, and if there are flaws in that code, then there will be flaws in Windows Defender. That is the explanation I give people when I am asked if they should rely on Windows Defender instead of using third-party malware protection. Now I have actual data to back me up. Ken Dibble www.stic-cil.org

1 0

Check my wording on this and tell me if I'm right
by mbsoftwaresolutions＠mbsoftwaresolutions.com 08 Dec '17

08 Dec '17

Client's app performance is dreadfully slow, and I believe the Server is largely responsible. Dealing with a former PITA Corporate tech support team who doesn't know jack squat about VFP and is telling me how it works, especially on the application that I worked on from 2007 to 2010 and was never updated after I left. They probably can't even spell FoxPro. VFP9SP1 application running on client's workstation, using VFP free tables on network share folder managed by Stonefield Database Toolkit. Workstations are Win10 Pro. Server is Windows 2008 Standard. On the server, they've got Windows Defender *AND* an outdated Symantec Endpoint on there that hasn't been updated since 2015 (https://www.screencast.com/t/n5dYLWF0) I also wanted them to add the relevant VFP exclusions in Windows Defender. They said they were there, and I showed here "no they're not." (https://www.screencast.com/t/6vioItlZSuu9) Corporate "engineering" said this, regarding the slowness: "It's a 32-bit OS so it can only utilize 4GB of RAM. Sym_data folder is almost 600MB, with the most common used features being the largest. The files are locked, transferred over the network and then updated and written back." It's the last part especially that has me fueled up to deliver a smack down. Here's what my Draft reply is to my former coworker Tim, who is the Tech who sent me the bullshit answer: ************************ As for this comment (and I'm sure you copied it from the Engineering folks, so I'm not saying that YOU TIM are incorrect): "It's a 32-bit OS so it can only utilize 4GB of RAM. Sym_data folder is almost 600MB, with the most common used features being the largest. The files are locked, transferred over the network and then updated and written back." -- Tim, the OS has nothing to do with it; 32-bit is fine, and Symplicity won't utilize that much RAM anyway. More important that needs correcting is this Engineering person's understanding of how the Symplicity application and database work; his/her comments about the entire 600MB of files being locked, transferred over the network, then updated and written back are wrong. The Symplicity application is a Visual FoxPro 9.0 SP2 application that uses a File Server database and unlike Access or some other types like that, it does NOT suck over the entire dataset but instead takes the CDX files (which are the index files) to read the relevant data from the network DBFs, only dealing with data requested in the application as needed. Trust me, I know what I'm talking about as you know I fixed the Symplicity application's major bugs from 2007 to 2010, something perhaps your Engineering folks don't know. And it was never updated after I released version 4.0 before I left in 2010. Nobody at your company before or now knows as much about that application and its abilities as I do. That's not arrogance; that's an obvious fact. ************************ So...I am right that the entire 600MB of VFP data files on the network share don't come down over the network, but instead the indexes do, right? I don't even think the DBF comes down--all the "locking" occurs on the file server. I'm betting heavily on this one. Am I right? Was my Access comment right? (Ok, maybe I was a bit arrogant there, but these dudes need to seriously be corrected.) tia! --Mike

8 23

[NF] Client's workstation struggling (performance-wise)
by mbsoftwaresolutions＠mbsoftwaresolutions.com 08 Dec '17

08 Dec '17

(Sorry...forgot the [NF] subject prefix) We're hooking her up with a new machine next week, but I was curious because her current/old pc is an upgrade from something to Windows 10 Pro, and it stayed 32-bit, with 4GB of RAM, non-SSD hard drive. https://www.screencast.com/t/L5kB9hijhadn According to M$, she's got more than enough: https://www.microsoft.com/en-us/windows/windows-10-specifications Anyhoo...was just curious. Like I said, she's getting a new machine next week. Here's what she's getting: ---------------- Fanless Mini PCs ---------------- Intel NUC NUC7i3BNK Mini PC/HTPC - Intel Dual-Core i3-7100U 2.4GHz - 8GB DDR4 - 256GB SSD M.2 (faster than SATA SSD) - Wifi, Bluetooth - 4k Support, Dual Monitor Capable (HDMI & Mini DisplayPort 1.2) - Windows 10 Professional - 1x USB 3.1 Type-C, 4x USB 3.0 - 1x Headphone/Microphone Combo Jack We've used many styles of fanless Mini-PCs before. Here are the advantages I see: - Small - Less shipping - No fans (fans collect dust, bearings go bad) - M.2 PCIe 3.0 x4 storage is faster that SATA SSD - No rotational drive - Less heat - Less power consumption - External power supply can be replaced by the end user, by simply plugging in a new one, without having to disassemle the PC, plug in hard drives, motherboard, fans, etc... I can't wait to see how much better it is.

1 0

Re: [NF] Free Windows 10 Book by Woody Leonhard
by Ted Roche 07 Dec '17

07 Dec '17

Re: déshabillé -- had to look that one up ;) On Thu, Dec 7, 2017 at 11:14 AM, Ken Dibble <krdibble(a)stny.rr.com> wrote: > Woody Leonhard of "Ask Woody" and "Woody on Windows" is my go-to guy for > current information on the relative state of deshabille of various MS > operating systems. Want to know what you're risking by leaving automatic > updates on? He's the guy. > > He's also written a book on Windows 10, and his publisher is offering it as > a free PDF download. You can find out how to get it here: > > https://www.askwoody.com/ > > Ken Dibble > www.stic-cil.org > > [excessive quoting removed by server]

1 0

Issue with _cliptext
by Paul Newton 07 Dec '17

07 Dec '17

Hi all If I run the following code = Adbobjects(laTables, 'Table') = Asort(laTables) _Cliptext = "" * The array has 365 rows For lnTable = 1 To Alen(laTables) Use (Right(Juststem(loData),1) + "_" + laTables(lnTable)) _Cliptext = _Cliptext + Padr(laTables(lnTable),20) + Replicate(Chr(9),2) + Str(Reccount(),10,0) + Chr(13) Endfor ? MemLines(_Cliptext) * _Cliptext only has 357 lines But if I use a variable lcCliptext instead of _Cliptext all is well (lcCliptext has 365 lines). It is as if _Cliptext can't keep up ... Paul Newton

4 5

[NF] Free Windows 10 Book by Woody Leonhard
by Ken Dibble 07 Dec '17

07 Dec '17

Woody Leonhard of "Ask Woody" and "Woody on Windows" is my go-to guy for current information on the relative state of deshabille of various MS operating systems. Want to know what you're risking by leaving automatic updates on? He's the guy. He's also written a book on Windows 10, and his publisher is offering it as a free PDF download. You can find out how to get it here: https://www.askwoody.com/ Ken Dibble www.stic-cil.org

1 0

2 VFP sessions running; 1 hangs and so does the other
by mbsoftwaresolutions＠mbsoftwaresolutions.com 07 Dec '17

07 Dec '17

VFP9SP2 Win7Pro Had a long running Quickbooks query from VFP (via QODBC tool) take forever. I launched a 2nd instance of VFP to work on something totally different. While editing some code in a PRG, my 2nd VFP session hangs. I leave it, come back HOURS later, still hung. Both VFP sessions. I'm guessing this is because it's single-threaded (although I'll be the first to admit I'm not a threading expert). Ideas? Thanks, --Curious in Maryland

5 8

Listbox auto-magically filters unwanted characters
by Man-wai Chang 07 Dec '17

07 Dec '17

I found that in WIndows 10 Home Premium, the system locale Big5 might cause VFP's listbox not to display a row of data. When the locale was English, all records were displayed without losing one. Is it an expected behavior? -- .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit Fedora 25 Server Spin /( _ )\ http://sites.google.com/site/changmw ^ ^ May the Force and farces be with you!

3 5

Re: BitDefender Doesn't Play Well With VFP
by Alan Bourke 07 Dec '17

07 Dec '17

Since we're on the subject of AV I would recommend the free Sophos Home http://www.techradar.com/reviews/sophos-home -- Alan Bourke alanpbourke (at) fastmail (dot) fm

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox December 2017