Shedding Some Light

Burt Rosen of Software News and Views posted a review of our ViewEditor Professional. Burt does Visual FoxPro development and also runs a Web site dedicated to reviewing business software. He is starting to review VFP related tools and books, writes for the UniversalThread magazine, and is a presenter. My favorite quote from the review is:

“In summary, I give ViewEditor an A for features, an A- for documentation and an A+ for technical support. I highly recommend this product. At a $75.00 per developer license fee, it is well worth the money. I easily saved the cost of purchase in my first use of this software.”

Thanks to Burt for the kind words. I can now reveal that Burt was the developer who provided me the reproducible steps to finding the ViewEditor table/view name ordering bug I complained about in my Having ASORT of Frustrating Day post. That might explain the A+ for tech support, but the rest of the high grades are mostly Steve Sawyer’s doing.

If you want to read the entire review you can sign up for a free thirty day trial on his Web site.

I have always been fascinated by patterns of numbers. Today it was all nines.

September 9th (9/9), I overslept and woke up at nine o’clock. I had nine emails waiting in the inbox and nine more in the Junk Mail folder this morning. On my way to my client I rolled the odometer from 16399 to 16400 miles and spent a lot of time working with their division 9 conversion.

All true.

I watched a little coverage of the Katrina aftermath last night and this morning on television. All day it has bothered me. How can one man help out and do his part to help those in need? My head hurts thinking about this. I am a fortunate man because my family is safe and my home is not under water or blown to smithereens.

The story I am really having trouble listening to is the looting. Not only taking the food off the grocery store shelves, but taking the shelves?? Worse yet, looters shooting other looters to take the stuff they already stole. What the heck is this world coming too???

In the last twelve months humankind has witnessed three unbelievable natural disasters: the peninsula of Florida get ravaged by too many powerful hurricanes, the Indian Ocean tsunami, and now Katrina. I am not sure we will ever see this level of natural disasters back-to-back-to-back and can only pray it never happens again. It will take a decade to recover from this.

To make matters worse, local news coverage seems more interested in the US$3.30 a gallon gasoline prices we have here in Michigan. Sorry, I have been inside all day. For all I know it could be US$3.60 a gallon by time I head home. The oil companies should be ashamed of themselves. This is just an un-natural disaster triggered by greed.

OK, back to work so I can afford to drive home .

If you are not a regular reader of Andy Kramek’s blog – head over there, hit the syndication RSS feed and make sure your aggregator is letting you know when Andy posts. I can count on both hands the blogs I read as soon as I see them pop up in FeedDemon. Andy’s is right their at the top of the list. I have been wondering why he has not posted in a while. I should have guessed.

Andy’s post on the conference season is dead on. There is no better time to head to a conference. If you are having trouble convincing your boss to pay for it, then consider paying your own way. I paid my way to two Advisor DevCons and one Great Lakes Great Database Workshop (GLGDW) when EDS did not want to pay. At least they gave me the time (not docking my pay). I can tell you from personal experience this was one of the many investments I have made in my career which have paid big dividends.

OK, back to my session preparation (nine sessions to create or refresh in the next few weeks).

Home run! I am back in the PowerDesk fold and Size Manager is working as sweet as it was back in the good old days. The ease of managing disk space is back in my powerful little hands… again.

Thanks to Rick Borup who tested out Size Manager on XP to back up a not-so-confident sounding statement by the V-Com salesperson. The only glitch was V-Com sending me out into left field looking for a serial number to a product I purchased back in the early 2000′s. I purchased it online at the Ontrack Web site so they should have records of it. “That Web site is obsolete Mr. Schummer.” Duh! So use those old-fashioned database apps to look up my registration.

A couple minutes later they provided me a serial number which might be mine, or might be one made up on-the-fly. I don’t care because it worked and I was able to upgrade and once again I am a happy camper.

Then it hits me. They finally fixed this little useful tool after it was broken for a long time. Now I know how a couple of the ViewEditor alpha testers felt last week when I finally tracked down and fixed the sorting bug in the list of tables and views when picking columns to be copied to the clipboard. Finally!

I am happy to announce ViewEditor Professional v3.6 entered beta today. A small team of dedicated developers are hard at work testing out all the new features (and several bug fixes) included the new version.

New features added so far:

1. SQL code window is now a normal program editor window when you are using a VFP Resource file (FoxUser), otherwise it uses the same editor window it has used since this tool was first released (fixed size to start). This allows you to retain the size and fonts you specify for the program editor.
2. You can specify Default SQL code when you first edit the SQL in the SQL program editor. This new code defaults to the null character string, but you can change the default code on the Configuration page.
3. The Validate SQL setting is saved between sessions instead of defaulting to “on” each time you start the ViewEditor.
4. The AllowSimultaneousFetch view property introduced in VFP 8 can be set on the View Properties page when running ViewEditor in VFP 8 or higher on remote views with shared connections.
5. The list of views and tables (when opening a view, or when copying columns to clipboard) are now ordered based on the collation sequence you select. This defaults to Machine because this is what the lists were previous to this release, but you can change the collation on the Configuration page.
6. The main ViewEditor window is now resizable when using VFP 9 or better.
7. Table and view selection dialog retains the position and size between ViewEditor sessions.
8. Minor user interface tweaks.
9. Added FAQs, macro expansion and view clauses, and made some improvements on the DBC-Specific Options Help topics.
10. New version of the Help file includes Favorites page (based on upgrade to West Wind HTML Help Builder 4.0).

I expect the beta to last a few weeks, but longer if necessary. The product will be shipped when it is ready, not a minute before.

Back in the day, the PowerDesk explorer replacement had a great utility I used when I wanted to find obsolete files and folders hogging space. It allowed me to rapidly search and destroy, and free up space so I could load one more set of sample data for the applications I support. This tool did not work on Windows XP and I have missed it ever since.

You would think this would be a common utility built into the operating system. Even so, you would think it would be easy to find a utility out on the various shareware download sites. Not today. I Googled, I looked on Download.com, Tucows, ZDNet, PC Magazine, and found little to nothing.

Last night I tried Disk Space Inspector v3.3 from AdvexSoft LLC and it is not too bad, but it is not perfect and is a little slow. Definitely not as good as Size Manager in PowerDesk. Size Manager was fast and it worked really well. In case you are not familiar with PowerDesk, it is an Explorer replacement and it rocked. Unfortunately it was a casualty of software company mergers and was not really upgraded. A couple of years ago Novatix got the rights from VCom and created ExplorerPlus, but they did not fix Size Manager. I asked and they said it was on the to-do list. My recent check on ExplorerPlus updates reveals Novatix is focusing on other packages and does not even show ExplorerPlus on their main Web site. Bummer.

Now I see VCom has released PowerDesk v6.0. Maybe they have fixed it, but I would be perfectly happy paying $30-$50 for a Disk Size Manager tool which works well. I want a packaged tool designed and tested to do the following:

1. Show me a bar graph of with each drive and the space consumed
2. Drill down in the graph to subfolders showing me another bar graph with the space consumed for more subfolders and files
3. Ability to delete folders and files
4. Good performance
5. Ability to sort manager by folder name, size consumed, dates
6. Not adware or spyware
7. Established software (not interested in v1.o)
8. Reasonable priced and supported

Anyone know of a good package and willing to share? Please do not point me to Calvin Hsia’s VFP code which calculates drive and folder space. I already know about this and want a program someone already constructed and others have debugged, not the base code for me to write the rest of the tool.

Have you ever had one of those days where nothing seems to go your way? Today was one of those days for me. I hit three deadends on three different projects today. We are definitely near a full moon. When this happens I put the project down for a bit and hope for inspiration or divine intervention, and most of the time it works.

About a year ago a developer who uses ViewEditor sent me a bug report noting the list of tables and views in the Copy Columns to Clipboard feature was not sorted properly. I looked into it and could not reproduce the problem. He was using the VFP 9 beta at the time and we both passed it off as a possible bug in the beta. Frustrating for both of us, but I kept the report around in case I got another report or better steps to reproduce the problem. It is not a show stopper type bug, but definitely causes frustration when working with lots of views or lots of tables in a DBC.

Fast forward one year. No one else reported this problem, well, until a week or so ago. The second developer is using the production version of VFP 9. The results were the same on my end as I could not reproduce the problem based on the report. One report could be a fluke, but two is doubtful. So I spent 3 hours while I was on my way home from vacation trying to figure out some reproducible steps to show Microsoft how ASORT() is broken. I could not get it to fail. Searching the Microsoft Knowledgebase and a post on Tek-Tips turned up nothing.

This morning I wrote a quick program for the developer to run which created the array using ADBOBJECTS() and sorted it using a couple of different collation sequences. Sure enough the results on the other developer’s machine were identical to mine. This drove another couple of questions, which triggered additional information, which lead me to find the bug in the ViewEditor. Finally. Once I had the complete information I was able to develop the test condition and plain as day, there was a list of tables out of order. Took me less than 15 minutes to find the bug, make the fix, and test it.

The good news is the bug is finally found. The better news is I will be starting a beta for ViewEditor v3.6 soon with the highly respected White Light Crash Test Dummies. I have nearly a dozen enhancements and a half dozen bug fixes almost ready to roll.