I highly recommend the podcast with the original creator of SQLite The Untold Story of SQLite With Richard Hipp - CoRecursive Podcast[^] CoRecursive with Adam Gordon Bell is really great, but this particular one is one of the all-time best. You will get the details of how SQLite came to be and a lot of information of the challenges that Hipp had as he created it. Really great!!! I promise. :)

I had a couple of them deployed and they ended up corrupting the hard drives so I shelved the trial at that point. And you're exactly right about StarTech stuff. :laugh:

Thank you.

milo-xml wrote: Outlook Express was being removed from Win 10 in the 21H1 update[^]. I'm not sure exactly what that means, given that OE isn't bundled with the OS. Are they claiming that if you *do* have it installed (which means a user has gone out of his way to find the installer and set it up), it'll be deliberately removed?? [Edit] Ok, I've read the page...and it's not claiming anything re: OE specifically with 21H1; the page simply lists "features and functionality removed in Windows 10" - across all versions. In light of that...the last column on that page ("Removed in version") says 1709...so...maybe OE *was* bundled at some point (I don't remember that far), but was actually removed 3+ years ago? If you're only finding that out now, then it sounds like having it removed for the last 3 years hasn't really been a problem then...

Thanks!

You're welcome. Should be faster for a search than filtering each table, at the cost of some diskspace. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

This is exactly why I have given up on watching anyone TV show. If its not on one of the services I subscribe to, then I don't care. Though, if I could find all of the GunSmoke episodes and a few other TV shows from that era...As they are no longer shown any where I have found. Common sense is admitting there is cause and effect and that you can exert some control over what you understand.

Luckily the application and the data will be on the same computer. I think that by using the second method, which is able to get the local timezone info and convert it to UTC, I'll be able to avoid that mess.

Even worse, laying them all off and closing the business.

Damn, you're right. Shame on me :sigh: I confused it with 100 miles from The Hooters

It was me. I don't have any of those substitution extensions installed. What do you get when you cross a joke with a rhetorical question? The metaphorical solid rear-end expulsions have impacted the metaphorical motorized bladed rotating air movement mechanism. Do questions with multiple question marks annoy you???

2016 is out now :)

Thanks for the input!

Thanks for the follow up.

Thank you!

You forgot about this part :-D image hard drives remotely while the computer is running I'll have to rig something up inside the case.

Not at all. The feeling I crave is when I have developed some piece of code and it works. It can be anything - from some caching to improve performance in a business app, to collision detection in a game. The only aspect of debugging that I really like is when it helps me find the solution - which is what gives me my buzz. Debugging is the medicine that cures the sickness that makes me well - it doesn't necessarily taste nice, but when it's over I feel better.

Not really knowing the structure of your keys - something like this should work. SELECT s.PI, s.JobID, s.FormID, s.ShiftID, s.StartEvent, s.SW, s.SG, e.EndEvent, e.EG, e.EW FROM [BaseTable] s INNER JOIN [BaseTable] e ON (s.PI = e.PI AND s.JobId = e.JobId AND s.FormId = e.FormId AND s.ShiftId = e.ShiftId AND e.EndEvent = (SELECT MAX(EndEvent) FROM [BaseTable] WHERE s.PI = PI AND s.JobId = JobId AND s.FormId = FormId AND s.ShiftId = ShiftId)) WHERE s.StartEvent = (SELECT MIN(StartEvent) FROM [BaseTable] WHERE s.PI = PI AND s.JobId = JobId AND s.FormId = FormId AND s.ShiftId = ShiftId)