ProFox

profox@leafe.com

2704 discussions

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

FRX and window envelopes
by Richard Kaye 11 Oct '18

11 Oct '18

While I start my own research, I thought I should call on the wisdom of the collective. Here's the goal. I have a number of client facing reports with address blocks. They may be one page. They may be many pages. I want to be able to fold the report to fit in a standard windowed envelope and not have any of the detail appear in the window. This requires a fixed location for the detail to start on the first page. I would like to reclaim some portion of that space for additional pages as the address block will not print on page 2 and after. What are some tricks to get a fixed height header on page 1 but not on subsequent pages? TIA -- rk --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 5

Fwd: Re: question about crazy ctrl C and ctrl V thing in the vfp9 sp2 program
by Ken McGinnis 10 Oct '18

10 Oct '18

sry, I meant to send this to the group, not your email. __________________________ This was compiled on Windows server 2012 R2. I tried compiling on Win7 and also on Win10 and got the same result. I am pretty sure it was not a problem on Win2000, but I don't have that available anymore. On 10/10/2018 1:26 PM, Tracy Pearson wrote: > Another thought about this: > I know vfp9 sp2 is supposed to fix some issues with how Vista caused > problems like this to happen. > I wonder if the exe was somehow compiled on vfp9 RTM or sp1. It's been years > since I saw this in my own product. > I do remember searching and finding workarounds for several Vista UI issues. > > > > -----Original Message----- > From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Tracy > Pearson > Sent: Wednesday, October 10, 2018 1:12 PM > To: profoxtech(a)leafe.com > Subject: RE: question about crazy ctrl C and ctrl V thing in the vfp9 sp2 > program > > You're description of the problem reminds me of what the LockScreen property > can do to a form. > I have seen some odd behaviors with Modal forms opening other Modal forms, > but not that specific behavior. > > Can you give some more detail about how these forms are built? > Is there any code that changes the LockScreen property? > Is this in Screen, or a top-level screen? > > -----Original Message----- > From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Ken > McGinnis > Sent: Wednesday, October 10, 2018 1:08 PM > To: profoxtech(a)leafe.com > Subject: Fwd: question about crazy ctrl C and ctrl V thing in the vfp9 sp2 > program > > I left out some important info. The box that contains the info you want > to copy is a memo text box. When you exceed the allowed amount, we pop > up a box that allows unlimited data entry. If you copy that, the crazy > stuff happens. > > ______________________________________ > > first of all ctrl C & V work as they are supposed to everywhere but this > one place: > > We have some text boxes on one screen in our program. If you ctrl C > (copy) anything from one text box and then ctrl V (paste) it to another > text box, the screen goes blank. > > Moving the mouse around after the screen is blank has no effect, the > screen stays blank. If you happen to click where that text box was, it > reappears. > > Then if you move your mouse to the side of the screen, the screen > reappears (but not the info you pasted). Then if you leave that screen > and then go back to that screen, everything seems normal. > > Someone just today noticed this. This has not been reported before in > many years. The same source code has been compiled in several versions > of VFP and several windows OS back to Win 2000. > [excessive quoting removed by server]

1 0

[NF] How many indexes do you need?
by Stephen Russell 09 Oct '18

09 Oct '18

The message the author presents works across all data environments. https://www.brentozar.com/archive/2018/10/index-tuning-week-how-many-indexe… -- 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 ---

2 1

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox