I shouldn’t be so proud of myself, but…
On Monday our Quality Coordinator came to me and asked if I could add a customer to our database because she had an ATR request from them and couldn’t enter it. I told her I’d see what I could do and went about my business.
My business soon became finding the customer already existed in the database and not having a blessed clue about why the application couldn’t find them.
I’ve told you before about how the existing pages were built on very old technology, and while the working was clever and works, sometimes it works better than others. When I checked into why the page didn’t work, I couldn’t find the reason. At all.
Four days later, I finally was provided the solution by God. He’s really good to me like that, and every once in a while He really pulls something phenomenal off. He led me to look into the base query which the page uses to access the data it’s supposed to display. Turns out, that query didn’t return this customer for some reason. (I still don’t know why.) So I went into the server, copied the database to my local machine, and started working with the query designer.
Fortunately for me, this is built on Microsoft Access databases, and I have the lovely QBE – or Query Builder Environment – to work in. It’s basically a graphical representation of the tables, which I can use to select the data and what conditions I want to use for filtering, etc. When I was finished at about 3:30PM, the query pulled the customer when searched by customer number.
I tested by searching by customer name, and it still didn’t work. *SIGH*
I was about to give up and tell her she can’t use that feature for this customer when it dawned on me: I needed to look at the page and see what it did with customer names. I found the query had to be adjusted slightly and when I did that, badda-bing! She worked!
WOO! I almost shouted.
The thing I hate MOST in my job is having to tell my boss “I don’t know.” I prayed, I almost wept, and I’ve been under so much stress about this I couldn’t sleep well.
Well, tonight, I’m going to sleep like a baby.
And tomorrow, I’ll realize I’m going on vacation Monday and have only about two weeks to finish Appmageddon.
I’ll get stressed about that when it’s time, I guess.
For today, I’m going to revel in victory and enjoy setting up my out of office auto-response tomorrow.