@Lilienthal is that nessesary though? I Kind of feel that it makes the op a bit more human and often more open to suggestions when they put in sentences like that.
I edit a lot of posts every day. I often run across posts with 'Hi' and 'Thanks' on the top and the bottom of the post respectively. I also run across things like:
--User
Should these items be removed during the editing of the post by an editor?
@Lilienthal If you know anyone going for a masters or doctorate in psychology, the posts that manage to hang around in HNQ would make for a fascinating dissertation.
> The acronym SAP stands for Systems, Applications, and Products in data processing. The SAP acronym was derived from the original German name, which was Systemanalyse und Programmentwicklung.
@RoryAlsop My bad, I didn't read it close enough. I worked for a German company that loved it, so I should have remembered it. I do remember Waste Management suing the heck out of them too. It's a nightmare to deal with.
@RoryAlsop Small companies often make the mistake of assuming that since they don't know how to do something, a bigger company does. Not often the case. I can tell you a few nightmares about a publishing application that was so awful that we had to create over 150 applications to support it.
@RoryAlsop I swear, I should write a book. I know a company that took four months and two dozen meeting to change one line of code to add a line in a drop-down menu for a form that was only used for reporting, no processing involved at all, other than printing out the form. The drop down menu item was for a product that had already been in production for over a year.
I've led a very unusual life, and a career to match. I should publish it as fiction because nobody would believe it otherwise ;)
@RichardU how about a "critical" feature that was delayed for two years?
I've just handed in the company laptop and badge. My job is officially over. I asked my team leader about what happened to me, and he only said "sh*t happens".
@Trickylastname I once lost a job because the higher ups wanted my director to quit, so they forced him to lay off 1/3 of his staff. He loved all of us, so it hurt him more than it did us. When we were sitting across the table, his face was longer than mine. There is no reason for a firing or a laying off that I will not believe at this point.
He's an hypocrite. The manager as well. The day after my manager broke me the news they talked sh*t of the ones they fired, in plain sight of the rest of the team while sipping coffee. I took the trouble of telling my team mates what happened, before they lie about it.
Anyhow, I wrote an Address class that takes the attributes of a unique index on the corresponding table and provides a function to look up the surrogate ID. The issue is that I made the ID column an AutoNumber and from what I can tell there's literally no value in the LongInteger range that AutoNumber can't potentially take on
When I workshopped the data model internally the feedback I got was "this is a small project so I'd just do it in Excel"
And I made the mistake of not putting my foot down and saying "we're doing it my way"
Because I'm relatively junior and everyone else has loads of experience doing things like this and management is clueless about whether they've been doing them wrong
Anyhow, everything I'm reading online about how to approach "find a value if it exists" functions is that if it doesn't exist, you just pick some value outside of the range of good values and return that instead.
Which I hate in general, but in particular, it doesn't look like there is such a thing for AutoNumber
Now, it's supposed to start at 0 and increment, and the table should only ever grow to ~10^4 records so -1 should be a perfectly safe value to use for "not found"
But eughhh
And I can't find any documentation that explicitly addresses whether AutoNumber uses the full range of a signed long int
I don't have any problem checking within the function whether the result set is empty, what frustrated me is that when I returned from the function without assigning any return value it didn't give me an empty integer - it gave me a default (0)
I guess I'm just going to have to guess at the lesser evil between returning -1 or using Variant so I can return Null
Only other thing I can think of is to create a Type holding the return value and a flag
And then check the flag to decide whether the return value is BS
I'm curious if the term "Power User" has outlived its usefulness. There are several different definitions. Some include nothing more than knowing keyboard shortcuts for Microsoft Word, while others involve maintaining advanced hardware and having at least some programming capability.
Is the ter...
Air, could you make a test system where you start from INT_MAX instead of 0? That way you could quickly see what happens on overflow. The Wikipedia page for AutoNumber doesn't sound like it'd go negative but like you say it's hard to be sure.
I have been working on multiple projects as of late. A few are in my job description others are not. I expect this and have no problem helping out by doing some other projects.
My boss came to me two weeks ago with a project to acquire the missing documents from several employees (we were at app...
I edit a lot of posts every day. I often run across posts with 'Hi' and 'Thanks' on the top and the bottom of the post respectively. I also run across things like:
--User
Should these items be removed during the editing of the post by an editor?
I'm curious if the term "Power User" has outlived its usefulness. There are several different definitions. Some include nothing more than knowing keyboard shortcuts for Microsoft Word, while others involve maintaining advanced hardware and having at least some programming capability.
Is the ter...
The Water Cooler
The Water Cooler