ProFox October 2018

profox@leafe.com

34 participants
26 discussions

Replacement for standard OLE image control
by Richard Kaye 24 Oct '18

24 Oct '18

I wish this had come up when I was at SWFox last week... As we all should know, the VFP OLE image control is...a bit long in the tooth. I just ran across an issue today with a client who was complaining that just recently some of his beautiful images are turning into pixelated goo. Of course, trying to figure out what is the underlying root cause is problematic at best. The display mechanism is reading a file from disk and using it as the source for a standard VFP OLE image control. So whilst I once again start my research out on the greater internet, I look to the collective wisdom here. Anybody using a 3rd party image control that does not have the underlying problems that come with using a native Windows control stuck in ~2003? Or otherwise have any other solutions for displaying JPGs in their UI? TIA -- rk --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 7

CleverFox backup tool
by mbsoftwaresolutions＠mbsoftwaresolutions.com 24 Oct '18

24 Oct '18

Hey ProFox Community, Just wanted to give an endorsement to Rick Schummer's and Frank Perez' automatic VFP backup product, CleverFox: https://cleverfoxbackup.com/ I use it for some of the Sylvan franchisees I support and it's been great. Not only is it affordable but it's super easy too. I had a couple issues at the start but that was just my needing to learn how to properly install it. Took less than an hour for sure. It's come in handy too on a couple of occasions when they needed me to restore some data that got tainted/overwritten wrongly. Cheers! --Michael

1 0

[NF] Microsoft Dynamics
by mbsoftwaresolutions＠mbsoftwaresolutions.com 23 Oct '18

23 Oct '18

Anyone here have a GOOD experience with Microsoft Dynamics? I just saw a former company of mine using it to replace an app I solidified years ago...and I gotta say, this replacement looks very rough...not user-friendly and klunky. Interested in your experience with it.

2 4

Southwest Fox
by Richard Kaye 18 Oct '18

18 Oct '18

For the first time in years I've convinced my company to pay my way to this year's Southwest Fox conference and the pre-conference Westwind session. Anyone else here in LeafeLand going to be attending? -- rk --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 7

VFP9SP2 & Excel automation -- how to enter this formula into a cell programatically from VFP?
by mbsoftwaresolutions＠mbsoftwaresolutions.com 16 Oct '18

16 Oct '18

See screenshot: https://www.screencast.com/t/wzLweduy General scenario: 2 input datetime values, with output being the native Excel command NetworkDays result on those 2 cells using 9 a.m. to 5:30 p.m. bounds, giving me the time elapsed between DateTime1 and DateTime2. I want to supply a start and end time and use Excel's native NetworkDays function to return the length of time between when we received a ticket and when we responded. So basically I just want to use Excel's formula/calculation rather than recreate this in the Fox. Every time I tried to set it manually from the VFP command window, it failed. See screenshot with my attempts: https://www.screencast.com/t/BtzVOQLu My current workaround is to have a simple worksheet with the formula predefined in a cell and just populate the input datetimes and then grab the resulting calculation from that NetworkDays(..) cell. I feel like that's a kludge though, and I'd rather just invoke Excel and programatically do it raw. Your thoughts on how to best proceed for this task? tia, --Mike

2 3

[NF] Solo Consultant Home Office/Small Office phone recommendations?
by Ted Roche 15 Oct '18

15 Oct '18

Thinking of cord-cutting the landline. My office phone is running close to $70 a month, as long as I don't use any "long distance" and the office is just me now, and there are rarely more than two hours of phone a month. For $850 a year, I'm thinking a good quality smartphone would be just as practical, without the need for voice mail at the base station, etc. I'm looking for a really good quality headset (earpieces & microphone) to use with a cell phone to replace my current landline cordless phone and headsets. I have some hearing loss, so high quality is really important. And I'm talking to clients, we're spelling out customer names and part numbers so both sides need to have pin-drop quality sound. Sounding like you're at the far end of a cardboard tube is not acceptable. Current smartphone is a Android Nexus 6P with 35mm audio jack and a USB-3 connector and Bluetooth. I've tried Bluetooth and that was an exercise in frustration, but perhaps they've gotten better. This is a business purchase, not a frugal home purchase, so if you're really convinced the $129.99 Plantronics Bluetooth is worth it, I'll give it a shot. Recommendations? -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 3

Re: Numbering Scheme
by Gene Wirchenko 13 Oct '18

13 Oct '18

At 07:48 2018-10-12, Alan Bourke <alanpbourke(a)fastmail.fm> wrote: >Easy for the staff to count, or difficult for the opposition to >count. Pick one. In situations like this, aren't there supposed to be three things with a choice of two? Especially on a Friday. Sincerely, Gene Wirchenko

1 0

Numbering Scheme
by Frank Cazabon 12 Oct '18

12 Oct '18

I have a client who issues tickets in numerical sequence (it's a pawnshop). The sequence helps them balance things back at the end of the day (read that as check for stealing) when checking the various parcels received for the tickets issued (they keep a copy of the ticket issued to their customer and at the end of the day sort them sequentially and read the numbers off the tickets to ensure they match the parcels). They are now not wanting the number printed on the ticket as their competitors may be able to get an idea from the sequential numbers how much business they are doing (by getting a ticket early in the morning and then one ate in the afternoon). So, they have asked me to come up with a solution and I must admit that I am coming up blank. Any ideas? -- Frank. Frank Cazabon

17 41

Re: [NF] How many indexes do you need?
by Gene Wirchenko 12 Oct '18

12 Oct '18

At 06:42 2018-10-11, Ed Leafe <ed(a)leafe.com> wrote: [snip] >âRule of thumbâ is not the same as >âarbitraryâ. The former is based upon >experience and observation. The latter is pulled out of thin air. Rule of thumb *is* arbitrary. It is not as bad as something purely arbitrary, but it is arbitrary. A rule of thumb saves time, because one does not consider the specifics of the specific case. It may be very useful, but then, there are the edge cases that can bite. Actually looking at the true requirements and determining what is needed is what is not arbitrary. Sincerely, Gene Wirchenko

1 0

RE: [NF] How many indexes do you need?
by Gene Wirchenko 11 Oct '18

11 Oct '18

At 14:12 2018-10-10, "Paul H. Tarver" <paul(a)tpcqpc.com> wrote: > > This is stupid advice. > > Don't hold back, Gene! > Tell us how you really feel. LOL In response to someone saying that an arbitrary number of indexes is great advice, I do not think my comment was at all out of line. >I think the point of the article was to help remind people to think about >indexes before just using them without understanding the effects on >performance. Having a rule of thumb like 5 indexes per table would make me >stop and consider whether a 6th index was required. If so, then great. But >at least I would have thought about the benefits and negatives before doing >it. Frankly, reminding people to consider the consequences of their actions >is NEVER stupid advice. Sure. But putting an arbitrary in is not good advice. In a given case, it might be that having a fifth index is wrong, or maybe, it is fine until the tenth index. You can consider the pluses and minuses without going arbitrary. After all, the idea of considering things is to avoid arbitraries. [snip] Sincerely, Gene Wirchenko

4 4

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox October 2018