Just a quick post about trying to determine the enabled/disabled status of an Oracle trigger. I found code snippets like this: Or like this: The first only gives you the triggers owned by the user session so if you are logged in as the admin, this won’t work for a trigger in a schema. The second one doesn’t work because the status of the object as Valid/Invalid. I figured if there is an all_objects table, there must be an all_triggers… [continue]
E-gineering Golf Outing 2011
E-gineering’s annual golf invitational turned out wonderful this year! It took place at Golf Club of Indiana. Not only were we blessed with incredible weather, but also with incredible fun and fellowship with our clients, partners, and employees. We had an eighteen hole shotgun start scramble format tournament. Not only were there prizes for the tournament, but we also had several side games where participants could win extra goodies. If all of that failed, there were several more door prizes… [continue]
Running Multiple Versions of IE on Win 7 with Virtual PC
My coworker Chad sent out a link to this article on the SitePoint blog a long time ago (probably about a year and a half ago) and I’ve been meaning to try it since that day, but just haven’t gotten around to it. Recently I started a new project for a client that is still supporting IE7 so I figured I better try to have an easy way to verify things in IE7. The article is really well written and… [continue]
JMeter JUG
I presented an introduction to JMeter at our local Java User’s Group here in Indianapolis, known as IndyJUG. For those who attended the meeting, I promised to make the presentation slides and JMeter example test plan from the demo available here on my blog. Here are the presentation slides in (OpenOffice) Open Document Presentation format. Here are the slides in PowerPoint format. If none of those work for you, then here they are in PDF format. Also, here is the… [continue]
AutoItX3 and QTP Part 2
First, let’s take a look at how I solved my problem of automating keystrokes from the number pad. This will be genericized so that you can run it inside QTP or even just save it in a .vbs file and execute it. It launches Notepad, waits for the notepad window to exist, makes sure it is activated, and then sends the keystrokes to generate the copyright symbol ©. Through messing around with AutoIt while trying to solve the problem of… [continue]
AutoItX3 and QTP Part 1
As usual, after I got into writing this, it got too long to be a single post. Part 1 covers the background for why I began to use AutoIt in QTP and how you can go about setting up a system to use it within QTP without installing all the tools that come with a full version of the AutoIt software. Part 2 will follow shortly and will cover some sample code that demonstrates how I used AutoIt in my… [continue]
Bringing Windows to the Front in QTP Scripts Part 2
Well, due to recent discoveries, I have to recant a lot of what I said in Part 1. Embarrassingly, that functionality is a snap to do with QTP’s Window object, and I finally figured out how to successfully call ShowDialog on a .NET Form and pass the QTP window to it making the dialog modal to the QTP window. This is what I was trying to accomplish and the whole reason I began this quest in the first place. In… [continue]
Bringing Windows to the Front in QTP Scripts Part 1
This became too long to put in one post, so I broke it into two parts. Part one will cover the QTP Extern Object and the User32.dll function SetForegroundWindow. Part two will cover the BrowseForFolder function on the Shell.Application object. Over the past few months, I have done a couple of custom testing functions that require user input. For example, in one script I was exporting an Excel file with some metrics pertaining to average log in and page load… [continue]