Thursday, March 23, 2006

Even more useful utilities…

I already mentioned Silurian as one option for examining the exports from DLLs. Another option is PE Explorer. Like Silurian, it handles both exports:

Exports

And resource information:

Resources

Sunday, March 12, 2006

Ottawa Sybase User Group Meeting

David Dichman, Senior Sybase Product Manager for PowerDesigner, will be the guest speaker at the Ottawa Sybase User Group (OSUG) meeting on Tuesday, April 4th, 2006. PowerDesigner is one of the worlds premier Business / Data Modeling tools and Sybase has just released version 12.0. Mr. Dichman will demonstrate why the 2005 Gartner group report concluded PowerDesigner is the number one modeling tool.

Tuesday, March 07, 2006

Brute force pbtrace.log processing (revisited)

An update to my previous post on using Excel to parse a pbtrace.log file.

The problem with the function in the second column is that it's trying to find the last occurance of a "(", and it's doing it by assuming that it can start at a certain fixed position before the end of the string. That turns out to be an issue.

Excel doesn't have a LastPos function, but VBA does. So you can create a VBA macro that does a LastPos and then call that from an Excel function. Launch the VBA editor in Excel, and then create a function as:

Public Function FindRev(sFind_Text As String, sWithin_Text As String) As Integer
FindRev = InStrRev(sWithin_Text, sFind_Text, -1, vbTextCompare)
End Function

Now in the second column, use this function instead:

=IF(A1>0,FindRev("(",D1),0)

The other thing you may want to consider is adding Conditional Formatting to Column C in order to make the problemattic statements more obvious. Select Column C, select Format-> Conditional Formatting from the menu, and then enter your criteria. In this example, I'm setting the background color of the cell to red if the statement took more that 1000 milliseconds (1 second):

Conditional Formatting

Wednesday, March 01, 2006

Deja Vu all over again…

Back in the late 1980's I was using a data management tool known as DataEase. At the time it was a DOS based tool that communicated only with its own proprietary database files. Essentially a competitor to dBase, but one that was more network aware and provided better screen generation capability.