Re: Mopier mode printers and multiple collated copies

2016-08-31 Thread Ken Dibble
> I think they're in serious danger of completely trashing the good will and, > for lack of a better term, "trust", that they've built up among most of > their non-techie customers if they don't reverse this soon. > You mean, unlike their techie customers, who've known better for a long time?

Re: Test

2016-08-31 Thread Ken Dibble
Testing... is what clients are for; lob it over the wall and listen for the screams. Perfect! On Wed, Aug 31, 2016 at 12:26 PM, Ken Dibble <krdib...@stny.rr.com> wrote: > Testing > > [excessive quoting removed by server] __

Re: Mopier mode printers and multiple collated copies

2016-08-30 Thread Ken Dibble
/3113078/microsoft-windows/fumbled-fixes-highlight-problem-with-windows-10-cumulative-updates.html Windows Automatic Updates. Just say no. (TM) Ken Dibble www.stic-cil.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http

Re: Mopier mode printers and multiple collated copies

2016-08-31 Thread Ken Dibble
Surprised that your customers upgraded to Win 10. I think most business users didn't do it, because they were afraid of this kind of troubles. The patches for Vista, Win 7, Win 8/8.1 and 10 all have this problem. Ken Dibble www.stic-cil.org

Re: Mopier mode printers and multiple collated copies

2016-08-31 Thread Ken Dibble
llow the "security" portions to somehow be separated from the rest of the junk in these omnibus packages, but it is not clear that each separate update will be defined and controllable even using that method. Ken Dibble www.stic-cil.org __

Test

2016-08-31 Thread Ken Dibble
Testing ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive:

Re: Mopier mode printers and multiple collated copies

2016-08-31 Thread Ken Dibble
Resending. MS has some of the best software testing processes in the software world, but the increasing complexity of their environment is making it harder and harder to get it 100% right. Right. This isn't the B Apple environment, or the relatively limited range of cell phones and tablets.

Re: [NF] Hardware vs Software Router/Firewall Recommendations

2017-01-11 Thread Ken Dibble
email notifications and look at activity reported from every machine, as well as block URLs globally. Ken Dibble www.stic-cil.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free

Re: [NF] Hardware vs Software Router/Firewall Recommendations

2017-01-10 Thread Ken Dibble
it? Thanks very much for all of your responses so far. They've all been useful in helping me to understand the "modern" state of routers and firewalls. Ken Dibble www.stic-cil.org Which software router are you looking at? Coyote? Most of the software routers I have used are no longer being

Re: [NF] Arago

2016-12-19 Thread Ken Dibble
Wow, 15-20 min sounds Painful! It was longer on the 286. On the 386 I could time it to go with my coffee breaks. *L* Ken ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free

Re: [NF] Arago

2016-12-19 Thread Ken Dibble
y reports with @ SAY...GET commands. Ken Dibble www.stic-cil.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/p

Re: [NF] Arago

2016-12-20 Thread Ken Dibble
Easy peasey. We had to time our instructions to when they came up under the magnetic reader on the drum, and make sure the mercury tubes didn't get tilted... or something like that... Here we go, "Oh, sure, you kids had compilers and cards and paper tape. We had to wire our logic directly

[NF] Hardware vs Software Router/Firewall Recommendations

2016-12-21 Thread Ken Dibble
rdinary PC is likely to be slower than a dedicated hardware device. However, is the difference so significant for a network like mine as to rule out a cheaper software solution? Do you have preferences for specific devices or software packages? What do you all think? Many thanks. Ken Dibble www.st

Re: [NF] Hardware vs Software Router/Firewall Recommendations

2016-12-21 Thread Ken Dibble
n into any throughput issues with your load on any device, or software-based system. That's good to know. Thanks very much, Mike. Ken Ken Dibble wrote: Hi folks, Looks like our "ancient" (2008) CISCO router has died. I would appreciate the benefit of your experience regarding

[NF] Happy Holidays to All!

2016-12-25 Thread Ken Dibble
Here's wishing all of you at ProFox a very Merry Christmas and Happy Hanukkah! Thanks to all of you who have provided help and/or thought-provoking ideas this year. And thanks to Ed for keeping it all going. Ken Dibble www.stic-cil.org ___ Post

RE: [NF] Arago

2016-12-19 Thread Ken Dibble
the Arago Quicksilver compiler for dbXL, you got one self-contained executable. No separate runtime file, no requirement for any dll dependencies like you have with VFP. It would take 15-20 minutes to compile a moderate-sized project on a 386 40 MHz machine. Ken Dibble www.st

Re: Monday Survey Question

2017-03-20 Thread Ken Dibble
you regret not owning? Tamar's book on SQL. 5. Would you buy VFP books if you could find them? Possibly. 6. Preferred format? Paper, PDF, CHM, ePub, HTML, other (which?) Paper. Ken Dibble www.stic-cil.org ___ Post Messages to: ProFox

Fuzzy Name Searching

2017-04-12 Thread Ken Dibble
many false positives. I suppose there are no easy answers, but if anyone has an algorithm for this kind of thing that they would be willing to share, I'd be grateful. Thanks. Ken Dibble www.stic-cil.org ___ Post Messages to: ProFox@leafe.com Subscription M

Re: Fuzzy Name Searching

2017-04-14 Thread Ken Dibble
Unfortunately, that would require modifications to the database, which I try to avoid due to the downtime they require. Why would that be an issue of consequence? You add some columns to a table. The rest of the software can ignore them. (Unless you use select * or other black

Re: Fuzzy Name Searching

2017-04-13 Thread Ken Dibble
17 at 9:55 AM, Ken Dibble <krdib...@stny.rr.com> wrote: > Hi folks, > > I've been thinking of how I can improve the ability of my users to find > people's names in a system that has over 30,000 people in it. > > I've looked at soundex, and I've considered munging nam

RE: Hard-Coded Scalar Value Substituted at Run Time

2017-03-02 Thread Ken Dibble
To follow up from yesterday evening, now that I'm back at work: The code in question is a FOR ... ENDFOR loop that iterates an array, with the loop limiting value being the number of rows in the array, and there is nothing within that loop that removes or adds rows or columns to the array.

Re: [NF] Scheduled Tasks, VFP, Batch, 7-Zip and PuTTY glitch

2017-03-09 Thread Ken Dibble
something like three years ago, so take it for what it's worth. But I did solve the problem, because the task, to pop-up a message in the middle of the day, persisted in annoying this user for quite some time until we finally disabled it. Ken Dibble www.stic-cil.org _

RE: Hard-Coded Scalar Value Substituted at Run Time

2017-03-02 Thread Ken Dibble
At 12:47 PM 3/2/2017, you wrote: Content-Transfer-Encoding: base64Hi Ken, You may want to use SET COVERAGE at the beginning and turn it off at the end of the method that errors, and add that log, of it exists to your error logging. You'll see what lines for called and which iteration it was

Re: Hard-Coded Scalar Value Substituted at Run Time

2017-03-02 Thread Ken Dibble
> FOR m.x = 1 TO ALEN(THISFORM.oMail.aSortList,1) > thekey = THISFORM.oMail.aSortList(m.x,10) && "array dimensions > invalid" > Is this m.x declared local to the procedure, or is it possibly shared with other m.x's in different scopes? It's declared local in this procedure, and all of

Re: Hard-Coded Scalar Value Substituted at Run Time

2017-03-02 Thread Ken Dibble
Of course, the way to handle this is to add code to test the size of the array before trying to iterate it, which I have now done. But I am still at a loss to understand how the error could occur. What I usually do in situations like this is to put in lines of code to write out to log files.

Re: Hard-Coded Scalar Value Substituted at Run Time

2017-03-01 Thread Ken Dibble
Never seen something like this, but if you are distributing an exe, then you should md5 it so you can detect any change comparing with a saved md5. This way I've found viruses that changed parts of the code and antiviruses have cleaned them up, but leaving the exes in a different state than

Re: Fuzzy Name Searching

2017-04-13 Thread Ken Dibble
it in my utility for detecting and removing duplicate records. That wouldn't involve pre-processing. I think it could really speed that up. Thanks. Ken Dibble www.stic-cil.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http

Re: GETFILE() Returns Empty String in Some Cases

2017-07-31 Thread Ken Dibble
laration, the variable is declared LOCAL. But in application mode there is a field in an open table with the same name as the variable. I applied the "essential m-dot" to the variable, and that fixed it. Thanks very much Philip!! Ken Dibble www.stic-cil.org __

GETFILE() Returns Empty String in Some Cases

2017-07-31 Thread Ken Dibble
Hi folks, VFP 9 SP1 on Windows 7 Ultimate. I have a process to let the user choose a file. The user opens a .scx form, presses a button to run some code that calls GETFILE(), and when the user has done so, the path and file name are displayed on the form. When I run this form in stand-alone

RE: GETFILE() Returns Empty String in Some Cases

2017-07-31 Thread Ken Dibble
lso tried it simply as: mypath = GETFILE() Then I manually navigate to the file location. But that doesn't make it work either. I'm sorry, I got sidetracked and failed to properly end the original message. I meant to conclude with: Thanks in advance. Ken Dibble www.stic-cil.org _

Re: GETFILE() Returns Empty String in Some Cases

2017-07-31 Thread Ken Dibble
Permissions issue on the folder or on the selected file? I don't see how. In both cases it's me doing the test, on the same computer, with the same folder and file, with the same domain administrator account. Ken Dibble www.stic-cil.org

Re: [NF] Windows updates August problems?

2017-08-10 Thread Ken Dibble
And as a double-bonus, if you had any updates hidden, say because they corrupted your machine, the cumulative update un-hid them so they get applied and, *boom*. How can you not love the company that does this? I DO! I DO love them! We STILL do not have any Windows 10 machines (and I have

RE: GETFILE() Returns Empty String in Some Cases

2017-08-01 Thread Ken Dibble
I agree with reasoning, but I have a slightly different methodology I actually have my own methodology; I just failed to follow it. I personally find type abbreviations to be difficult to read and interpret quickly. For generic variables I usually just prefix "the", ie. thefile, thefolder,

RE: GETFILE() Returns Empty String in Some Cases

2017-08-01 Thread Ken Dibble
I remember!! It was Calvin Hsia! Here's the blog article: https://blogs.msdn.microsoft.com/calvin_hsia/2004/12/14/foxpro-performance-tip-field-name-lookup-for-tables/ Ken On 2017-08-01 10:00, Ken Dibble wrote: A member of the VFP Team (I can't remember his name; he was the guy who "too

Re: [NF] Windows updates August problems?

2017-08-09 Thread Ken Dibble
installed? http://www.computerworld.com/article/3214488/microsoft-windows/windows-10-1607-cumulative-update-kb-4034658-wipes-out-update-history.html Windows Automatic Updates. Just Say No. (TM) Ken Dibble www.stic-cil.org ___ Post Messages to: ProFox

Re: Bulk Imports While Multi-User System is in Use

2017-06-26 Thread Ken Dibble
Thank you to everyone who responded. Is the proposed import doing any updates of the parent records or just adding\updating child records? The import will not create parent records. It also won't edit existing records, only create new child records in one particular table. If the expected

Bulk Imports While Multi-User System is in Use

2017-06-22 Thread Ken Dibble
prevent issues ("simple" means, no major changes to the framework or the database)? Or is this something I don't really need to worry about? Thanks very much for any suggestions. Ken Dibble www.stic-cil.org ___ Post Messages to: ProFox@

[NF] Friday Afternoon Discussion: Passwords

2017-05-05 Thread Ken Dibble
t as easy for a brute-force botnet application to "guess"#51aQ4@5)?" as it is to guess "YourMomma!") Maybe I should start my own security newsletter Ken Dibble www.stic-cil.org ___ Post Messages to: ProFox@leafe

Re: [NF] Friday Afternoon Discussion: Passwords

2017-05-05 Thread Ken Dibble
1. Forcing people to frequently change passwords is not helpful. It just makes it more likely that they will stick the password on a Post-IT on their monitors because they can't remember it. It does help some. If someone has your password but has not changed it, because it would alert

Re: [NF] Friday Afternoon Discussion: Passwords

2017-05-06 Thread Ken Dibble
Not so silly. There are password processes that depend on gestures that are under testing. The ability to click and swipe through a series of images is somewhat unique due to biomechanical parameters or personal habits. I've also seen proposed some sort of facial recognition. The sooner we get

Re: Odd Behaviour

2017-10-13 Thread Ken Dibble
instances in which bad code generates errors under some circumstances but not others, in seemingly random fashion, owing most likely to the behavior of the compiler. Ken Dibble www.stic-cil.org ___ Post Messages to: ProFox@leafe.com Subscription

Re: [NF]Debugging Pain Survey

2017-09-26 Thread Ken Dibble
nded to be static. And I need stuff to be available before any objects are instanciated and after all of them are destroyed. Ken Dibble www.stic-cil.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/l

Re: Entering invalid date hangs form

2017-10-02 Thread Ken Dibble
ring. A work-around would be to supply a date-picker, though I realize that could be a lot of work. Ken Dibble www.stic-cil.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free ver

Re: [NF] Restart now or later?

2017-12-08 Thread Ken Dibble
s 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

Re: [NF] Restart now or later?

2017-12-08 Thread Ken Dibble
- On 12/8/2017 10:07 AM, Ken Dibble wrote: 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

Re: [NF] Restart now or later?

2017-12-08 Thread Ken Dibble
Bad Ken is stealing my line! Once you go ERP you never go back. I usually go ERP a few times after drinking some beers and eating some barbecue Ken ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: [NF] Restart now or later?

2017-12-08 Thread Ken Dibble
> As I said in the other thread on this topic: Experts recommend that people > should not rely on a single product, no matter who makes it, >> >> >> --- You shoudl talk to more ERP vendors for a different opinion. hahahahaha Yeah, I should have been more specific.

[NF] Free Windows 10 Book by Woody Leonhard

2017-12-07 Thread Ken Dibble
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 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailma

Re: BitDefender Doesn't Play Well With VFP

2017-12-06 Thread Ken Dibble
he way, avast! recently purchased AVG. I don't know what that will bode for the future but right now they are managing them as two completely separate products. (And no disclaimer needed; I don't work for avast! nor am I a reseller of it--or of anything else except my own

Re: Microsoft Catch 22 RDP Update

2018-05-22 Thread Ken Dibble
feel your pain. I've been following this issue, and waiting to see whether MS issued a version of the patch that does not mess up NIC/DHCP addressing. Did you have any issues with losing static internal IP addresses or NIC settings on Server 2008? Thanks. Ken Dibble www.stic-cil.org

RE: Microsoft Catch 22 RDP Update

2018-05-23 Thread Ken Dibble
-Original Message- From: ProFox <profox-boun...@leafe.com> On Behalf Of Ken Dibble Sent: 22 May 2018 17:14 To: profox@leafe.com Subject: Re: Microsoft Catch 22 RDP Update >Just had a 1 day full on panic here with the latest May 2018 update >from Microsoft for Server 2008 and

Re: Query Involving Sums and Two Most Recent Dates

2018-06-25 Thread Ken Dibble
base64You just need to change the first line of the query to this: SELECT COUNT(Status.ConFK) AS ConsCount, SUM(LastHours.AppHours) AS HoursSum; Frank. Frank Cazabon On 22/06/2018 01:04 PM, Ken Dibble wrote: Maybe this will do what you want: €£M1 PMхÑÕ̹ ½¹,°1…ÍÑ!½ÕÈs.AppHours; FROM Sta

[ADMIN] Filter Redux

2018-06-27 Thread Ken Dibble
Message sent 12:53 PM EDT. Not received by 3:04 PM EDT, and not in the archives. Ed? Please check the filter again. Thanks. Ken Dibble www.stic-cil.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman

[NF] "Modern Standby", Win 10, and Bitlocker with Azure

2018-06-27 Thread Ken Dibble
crucial piece of information. Thanks for any help. Ken Dibble www.stic-cil.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.c

Re: Nothing like a cryptic error to start the work week!

2018-06-25 Thread Ken Dibble
of events, which probably calls your BO code. I would put SET STEP ON in the form's Load() event and step through until the actual error occurs. Ken Dibble www.stic-cil.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http

Re: Query Involving Sums and Two Most Recent Dates

2018-06-22 Thread Ken Dibble
Maybe this will do what you want: SELECT Status.ConFK, LastHours.AppHours; FROM Status ; INNER JOIN (SELECT ConFK, MAX(Date) AS MaxDate; FROM Status; GROUP BY ConFK) M ON Status.ConFK = M.ConFK AND Status.Date = M.MaxDate ; AND Type = "Approved"; LEFT JOIN

RE: Query Involving Sums and Two Most Recent Dates

2018-06-22 Thread Ken Dibble
oves the record pointer, which might not be desirable in some circumstances but wouldn't make a difference in my case. Ken Dibble www.stic-cil.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profo

Re: Query Involving Sums and Two Most Recent Dates

2018-06-22 Thread Ken Dibble
ON Hours.ConFK = MH.ConFK AND Hours.Date = MH.MaxHoursDate ) LastHours ;  ON STatus.ConFK = LastHours.ConFK Frank. Frank Cazabon On 22/06/2018 12:21 PM, Ken Dibble wrote: ˆÑSPÕÛۜÝ[Y\‹Š‹Ý]\ˊ‹Ý\œË\Ý\œ€ FROM Consumer JOIN Status on Consumer.ConPK=Status.ConFK Q•ÕUTˆ“ÒSˆÝ\œÈۈ

Re: Query Involving Sums and Two Most Recent Dates

2018-06-22 Thread Ken Dibble
SELECT Consumer.*, Status.*, Hours.AppHours FROM Consumer JOIN Status on Consumer.ConPK=Status.ConFK LEFT OUTER JOIN Hours on Consumer.ConPK=Hours.ConFK WHERE Status.Date = (SELECT MAX(Stat2.Date) FROM Status Stat2 WHERE Stat2.ConFK = Consumer.ConPK GROUP BY Stat2.ConFK) AND Status.Type =

Re: Query Involving Sums and Two Most Recent Dates

2018-06-22 Thread Ken Dibble
> Interesting. I've always just followed the principle that if a parent can > own more than one value for a particular item, you put that item in a child > record, and keep the child records in a separate table and JOIN it as > needed. So, can a Consumer be both Approved and Pending? By your

RE: [NF] Meltdown and Spectre CPU Flaw Information

2018-01-04 Thread Ken Dibble
into the memory space of other VMs. Very bad. Unless you don't have any sensitive info that needs to stay that way. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ken Dibble Sent: Thursday, January 04, 2018 1:35 PM To: profoxt...@leafe.com Subject: Re

Re: [NF] Meltdown and Spectre CPU Flaw Information

2018-01-04 Thread Ken Dibble
for shipping their patches a week early, and spontaneously rebooting idle Windows workstations while people were freaking out over the new exploits. Good job! On Thu, Jan 4, 2018 at 12:27 PM, Ken Dibble <krdib...@stny.rr.com> wrote: > Hi folks, > > Ask Woody has a very thorough report on t

RE: [NF] Meltdown and Spectre CPU Flaw Information

2018-01-05 Thread Ken Dibble
If you are a HIPAA shop then I'm sure your IT team is paying proper attention to this. Hah! I AM the IT team. (I have a couple of part-time assistants who do help desk and maintenance, but I'm the CIO/SysAdmin/DBA/Systems Analyst/Code Monkey/chief cook and bottle washer. We have an

[NF] Meltdown and Spectre CPU Flaw Information

2018-01-04 Thread Ken Dibble
Hi folks, Ask Woody has a very thorough report on this, with links to more information. We all need to be fully informed about this; it is going to affect everybody. https://www.askwoody.com/ Ken Dibble www.stic-cil.org ___ Post Messages

Re: [NF] RE: Timers in VFP

2018-01-24 Thread Ken Dibble
Something make me click on your website link, Ken, and I was surprised to see you work in the Binghamton, NY area. My wife is the from Elmira/Corning and I've been through your pretty town many times. HI Paul. Pleased to hear that you think it's pretty. I do too--you can be anywhere in this

Re: Foxpro/Programming Training Question

2018-01-26 Thread Ken Dibble
6.0 - Marcus Egger Debugging Visual Foxpro Applications (Nancy Folsom; whatever happened to her?) Visual Foxpro Report Writer - Cathy Pountney Ken Dibble www.stic-cil.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe

Re: [NF] Printer brands

2018-01-17 Thread Ken Dibble
come out of the printer with the same colors they see on their monitors, and they also have to understand that the ony real way to get a truly "professional" result is to create a PDF and send it off to an actual print shop. HTH. Ken Dibble ww

Re: Timers in VFP

2018-01-24 Thread Ken Dibble
ou're blue in the face and it just doesn't happen until VFP gets done doing whatever it thinks is more important. I, too, recall this issue being discussed and I think some people had some even more esoteric points. Ken Dibble www.stic-cil.org ___ Pos

Re: Foxpro/Programming Training Question

2018-01-27 Thread Ken Dibble
> Hacker's Guide to Visual Foxpro 6.0 (THANKS TED!!!) Please thank Tamar. The book blurb said it was "exhaustive and irreverent." I was the irreverent part. By the time it shipped, Tamar was exhausted. These days I get exhausted just lifting that mighty tome off from and onto the bookshelf

RE: [NF] RE: Timers in VFP

2018-02-18 Thread Ken Dibble
John, For some reason this message didn't get delivered to my work email. I was just combing through the list at home and saw it today. Singer Link is gone. CAE Corp bought it, and Hughes Aircraft bought CAE and relocated most of the simulator stuff to Arlington, TX. The federal government

Re: String Reference to Object

2018-02-15 Thread Ken Dibble
do this: mytable = "foo" myfield = "bar" ? mytable.myfield Then you need to do: ? A [table].[field] reference is not an object reference and can't be treated like one. It's a thing unto itself. Ken Dibble www.stic-cil.org _

RE: [NF] RE: Timers in VFP

2018-02-19 Thread Ken Dibble
And, for what it's worth, (and strangely enough), although the local airport is now called the "Greater Binghamton Airport", the actual _field_, as in "airfield", is still called "Edwin A. Link Field". Ken John, I had a play around with the early GAT-1 simulator but never got to try out

Re: Query Involving Sums and Two Most Recent Dates

2018-06-21 Thread Ken Dibble
Er... and while still rendering a total number of Consumers whose hours were totalled--at least via _TALLY if nothing else. I should have realized that from your example solution. I *ASSuMEd* we were totalling hours. My bad. SELECT Consumer.*, Status.*, Hours.AppHours FROM Consumer JOIN

Re: Query Involving Sums and Two Most Recent Dates

2018-06-21 Thread Ken Dibble
SELECT Consumer.*, Status.*, SUM(Hours.AppHours) AS TotalHours FROM Consumer JOIN Status on Consumer.ConPK=Status.ConFK JOIN Hours on Consumer.ConPK=Hours.ConFK WHERE Status.Date = (SELECT MAX(Stat2.Date) FROM Status Stat2 WHERE Stat2.ConFK = Consumer.ConPK) AND Status.Type = "Approved"

[ADMIN] Stuck inside the Filter (with the Memphis blues again)

2018-06-21 Thread Ken Dibble
happens unless the message was stuck in the filter. Can you please check it? Thanks. Ken Dibble www.stic-cil.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version

Query Involving Sums and Two Most Recent Dates

2018-06-21 Thread Ken Dibble
cursor, and it works fine and is fast enough, but it just makes me crazy every time somebody wants a slightly different report along these lines. It seems like there should be a way to do this more simply. I am sure that I am missing something extremely obvious. Thanks for any help. Ken Dibble

Re: [ADMIN] Stuck inside the Filter (with the Memphis blues again)

2018-06-21 Thread Ken Dibble
> Despite the convential wisdom about the vagaries of email, in all my previous experience with ProFox, this never happens unless the message was stuck in the filter. You called it. Thanks, Ed. Ken ___ Post Messages to: ProFox@leafe.com

Re: Query Involving Sums and Two Most Recent Dates

2018-06-21 Thread Ken Dibble
I should have realized that from your example solution. I *ASSuMEd* we were totalling hours. My bad. SELECT Consumer.*, Status.*, Hours.AppHours FROM Consumer JOIN Status on Consumer.ConPK=Status.ConFK JOIN Hours on Consumer.ConPK=Hours.ConFK WHERE Status.Date = (SELECT MAX(Stat2.Date) FROM

Re: Query Involving Sums and Two Most Recent Dates

2018-06-21 Thread Ken Dibble
SELECT Consumer.*, Status.*, SUM(Hours.AppHours) AS TotalHours FROM Consumer JOIN Status on Consumer.ConPK=Status.ConFK JOIN Hours on Consumer.ConPK=Hours.ConFK WHERE Status.Date = (SELECT MAX(Stat2.Date) FROM Status Stat2 WHERE Stat2.ConFK = Consumer.ConPK) AND Status.Type = "Approved"

Re: Query Involving Sums and Two Most Recent Dates

2018-06-21 Thread Ken Dibble
Responses in-line: No, it's just a little quirky due to your design choices. Typically, I would have a "current status" value in the Consumer record that's an FK into the Status history table. A common problem with data modeling is determining if your system is a reflection of the current

Re: Query Involving Sums and Two Most Recent Dates

2018-06-21 Thread Ken Dibble
At 02:21 PM 6/21/2018, you wrote: What's your expected output from the data you presented? Answer: 2 Approved Consumers, having a total of 12 Hours. I did include that in my original post. To make it a little easier for people to try to help, here's some code to build up the data and my

Re: Query Involving Sums and Two Most Recent Dates

2018-06-21 Thread Ken Dibble
At 02:33 PM 6/21/2018, you wrote: I mean specifically, which records (consumer PK and apphours) would you expect in your results? There are two Consumers whose most recent (last) status is "Approved": Consumer PKs 1 and 3. The relevant Status records are Status PKs 2 (for Consumer 1) and 8

[ADMIN] No Messages Since August 2

2018-08-14 Thread Ken Dibble
I'll check the archives to see if this message arrives or if there is any response. Thanks. Ken Dibble www.stic-cil.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this

RE: [ADMIN} No Messages Since August 2

2018-08-14 Thread Ken Dibble
explaining what they did. Just a thought Ken Dibble www.stic-cil.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo

Re: [ADMIN] Still No Messages Since August 2

2018-08-28 Thread Ken Dibble
Folks, Thanks to those who responded. This pretty clearly seems to be a case of my email provider suddenly blocking everything coming from leafe.com. Ed contacted me directly and I am trying to follow up with the email provider. In the meantime I'm reading the list in the archives. Ken

[ADMIN] Still No Messages Since August 2

2018-08-27 Thread Ken Dibble
if I don't hear from Ed on this in a few days, I'll unsubscribe from this address, and try an address at a different domain with a different mail provider. Ken Dibble www.stic-cil.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance

Re: [ADMIN] Still No Messages Since August 2

2018-08-29 Thread Ken Dibble
>In the meantime I'm reading the list in the archives. You just can not leafe this list alone. Well, maple* I can, and maple I can't... But the effort it takes to spoof a direct reply to the listserv should indicate how much I love ProFox. Ken * In honor of Gene's beautiful flag

Re: [ADMIN] Still No Messages Since August 2

2018-08-29 Thread Ken Dibble
>> But the effort it takes to spoof a direct reply to the listserv should indicate how much I love ProFox. > I'd be curious to know what you did with that post. It was received without a Message-ID: header, which means that the link in the footer doesn't work. Oh, all I did was copy the

Re: Performance issues on virtual 2K12 server

2018-01-23 Thread Ken Dibble
r. Application runs on that server, and the data (VFP tables) are on a virtualized 2012 server on the same hypervisor. It's blazingly fast, no matter where the end user is. Faster, in fact, for many users, than running it on a desktop in our building. Ken Dib

Re: Grids (Not Really)

2018-04-19 Thread Ken Dibble
I have tried about four times to post regarding grids. I wonder if such posts are being filtered. Nah. Grids just suck. Ken Dibble www.stic-cil.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com

Re: [ADMIN] Testing

2018-03-27 Thread Ken Dibble
Yes, it was marked as spam. I’ll send the first and delete the dupes. Thanks very much, Ed. Ken ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list:

[ADMIN] Testing

2018-03-27 Thread Ken Dibble
Not receiving my own posts? ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive:

RE: [ADMIN] Testing

2018-03-27 Thread Ken Dibble
Of Ken Dibble Sent: Tuesday, March 27, 2018 3:31 PM To: profoxt...@leafe.com Subject: [ADMIN] Testing Not receiving my own posts? [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http

Re: [ADMIN] Testing

2018-03-27 Thread Ken Dibble
At 03:30 PM 3/27/2018, you wrote: Not receiving my own posts? I don't think it likes my subject line. I'll try resending with a different subject. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: [ADMIN] Testing

2018-03-27 Thread Ken Dibble
Roche <tedro...@gmail.com> wrote: > On Tue, Mar 27, 2018 at 3:30 PM, Ken Dibble <krdib...@stny.rr.com> wrote: >> Not receiving my own posts? >> > > Well, you already know what they say, right? > > > -- > Ted Roche > Ted Roche & Associates, LLC

Get Method Issue with Hidden Property

2018-03-27 Thread Ken Dibble
just irks me. I've seen it before; built-in VFP functions just flat-out lie, leaving my code with nothing to trust--but it only happens once in a blue moon. Any thoughts (other than "Use anchors instead"?) Thanks. Ken Dibble www.stic-cil.org ___

Re: [ADMIN] Testing

2018-03-27 Thread Ken Dibble
At 03:30 PM 3/27/2018, you wrote: Not receiving my own posts? The message to which I am replying was sent out at 3:30 pm EDT March 27 2018. It's in the ProFox archive. I received it almost immediately. Others have seen it and replied. I sent a message at 2:21 pm EDT March 27 2018 with

Re: [NF] "Modern Standby", Win 10, and Bitlocker with Azure

2018-06-28 Thread Ken Dibble
e local login credentials, well you're on your own. If that's your fear maybe enable two-factor authentication (e.g. Windows Hello and a PIN). Eric On Wed, Jun 27, 2018 at 11:53 AM, Ken Dibble wrote: > Perhaps someone here can answer this question. > > I have a Windows 10 Pro laptop. It is

Re: [ADMIN ] Duplicate messages from Ken Dibble

2018-06-29 Thread Ken Dibble
I'm only sending to ProFox. And I only get one copy of my own messages. Ken Hi Ken Dibble and all I am getting duplicate messages on the list from Ken Dibble - one seems to be via ProFox and the duplicate via ProFoxTech. Is anybody else seeing this and can anything be done about it? Ken

Re: [NF] Seeking well-equipped laptop recommendations

2019-08-16 Thread Ken Dibble
So modernity expects a person like me to be happy with 256 GB. But I've always been a fan of over-provisioning because the unpredictable and the unexpected is an everyday thing in my life. What is unexpected about needing more memory and disk space on a computer? Oh, Gene, Gene,

<    6   7   8   9   10   11   12   >