Stranger than fiction – wierd FoxPro (2.6 yes I said 2.6) query problem (and the kludge)

I have a client with one last holdout FoxPro 2.6 application. It manages all of their incredibly complex billing and is a work of art and works beautifully and someday we will upgrade it, not to make it better, but just because we will have to. But for now, just accept that fact and move on. 🙂

The woman who does the invoicing noticed an odd inconsistency that did not affect billing but a payroll report that was missing one person’s 3 hour stint for a particular day  – one of 3 rows that made up one guy’s particular day.

That report is created by a union of two queries. The first picks up all the data, the second picks up any body who didn’t have any hours that week (10 maybe 15 extra). I looked and looked at this then broke the queries into two. The record was there. Ran the queries with the union, the record was gone and the row count was off by one.

I have been fiddling with this all morning (it’s a disease, what can I say?) and there is no rhyme or reason for it. So I just bagged the union and did two queries and appended the results to each other.

But, no complaints. We are all ecstatic that this 8 year old program (which gets tweaked here and there from time to time) still works on the new computers and is great. Thanks to all who are responsible for that!!

  Sign up for my newsletter so you don't miss my conference & Pluralsight course announcements!  

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.