Skip to main content


Showing posts from October, 2006

Reading/Writing Data from a Text File: VFP and DotNet

(note: the title of this post is based on what I started to write about which is comparing functions between VFP and DotNet but then went off onto a tangent about code readability)

While I do work in Visual Studio and DotNet a fair bit, my main development environment is Visual FoxPro. One of the things that I always remember from past Devcons was when Microsoft was really trying hard to rally the FoxPro-faithful to use DotNet and ADO.Net, and even at the first DevTeach when there were a fair number of FoxPro developers, (before it turned into a Fox-less event), was the justification for the way most things were objects in DotNet and how that made it better than the single function approach in VFP.

It always struck me as a "this is the right way to do it - so switch to using this approach, regardless of ease of use" type of argument. I know it wasn't intended that way - but that's the impression I always got. And I got it again recently.

Rhonda Tipton explains here how…

I was bit by a 2.6 year old Fox(Pro)

Talk about old ghosts coming back to haunt you.

I was upgrading a customer's old Foxfire! installation from version 3.0 to 8.0. They were running Foxfire! 3.0 under FoxPro 2.6/Windows.

But they had this one report that kept on crashing under the 8.0 version that would run fine under their old version.

I tried to run Foxfire! 3.0 under a copy of Visual FoxPro and it crashed there as well.

Hmmm...what could it be? I looked at the SQL generated.

There was the problem that was causing the crash: one of the relationships was referring to a field that didn't even exist.

The field in the SQL referred to a field named PART_SEC_ID_I but the real field was called PART_SEC_I.

But why didn't it crash under the older version?

The reason? FoxPro 2.6 ignored the extra fields.

I opened up the table in FoxPro 2.6.

? part_sec_i
** returned a value
? part_sec_id_i
** returned the same value.

Sheesh...I can't believe we were actually able to build quality applications back then but then again, when o…

The death of habeas corpus

I typically stay out of political matters on this blog but this article isn't a very good sign about the state of the world.

True, Olbermann typically has a razor-sharp tongue on many points but this one is further backed up by this Wikipedia article.

Considering what Canada just went through with the Arar report, it doesn't look good for basic justice anymore.

The death of habeas corpus - Countdown with Keith Olbermann

Creating Passionate Users

This post has gotten a lot attention and for all the right reasons so I wanted to re-iterate it here.

"If you knock out exuberance, you knock out curiosity, and curiosity is the single most important attribute in a world that requires continuous learning and unlearning just to keep up."

I have to say the list of traits as to why Robots make the best employees sounds scarily familiar to me. Do you know companies or developers who fit into that category?

This is why developers have to fight burn-out.
Creating Passionate Users: Knocking the exuberance out of employees

Be careful of TreeView.Nodes.Clear

As you may have surmised from my last post, we were dealing with some performance issues in a treeview when it was repopulating nodes. This is an older tip but it's certainly something to consider if you are using TreeViews. I got the tip here and it's a good one.

When the Nodes.Clear method is called, it refreshes the treeview for each node it removes.

If your treeview is small, you won't really notice it but if you have a lot of entries on it, it's really noticeable.

Here's a quick test to try
1. Build a form with a treeview on it.
2. Add 200 nodes to it:
FOR lni = 1 TO 200
.Nodes.Add(,"_"+LTRIM(STR(lni)),"Item "+LTRIM(STR(lni)))

3. Just issue a _SCREEN.Activeform.treeview.nodes.clear() in the Command window and see how long it takes for control to come back. It can be a while. (my test showed 14 seconds - YIKES!!!)

Instead, remove each node individually:

FOR lni = 1 TO THISFORM.Treeview.nodes.Count to 1 STEP -1

Writing better code in action...

Early this year, Andy Kramek wrote about Writing better code (Part 1).

I just saw an example that I thought would be worth sharing.

This system was using a treeview with two different "purposes". One was to show a list of about 10 nodes and the other showed a list with about 200 nodes on it.

When the system ran, it just seemed super slow. The first list would appear fairly quickly but then when it switched between the two, it would reduce to a crawl, even just to show 10 nodes.


The loop looked like this:
lnRec = RECNO()/RECCOUNT()*100

DOEVENTS is useful for allowing any Windows activity to refresh - so it's useful to call it - but calling it within the SCAN means it will take a hit on performance as well as the ShowProgress for every record.

As Andy notes: "Inform your users, but don’t compromise performance to do so"

With a few minor tweaks, the code now runs incredibly fast and I wa…

Kevin Ragsdale's Desktop Alerts Rock

So if you have ever wanted to have alerts pop-up like they do in Outlook, Kevin's got a great screen cast that walks through how he did this in Excel. He also had his intro one back from Sept 25 - here's the link so you know what he's referring to.

Warning: the screencast takes some time to popup but it's a very effective way of showing how this tool works, including from other applications such as within Excel.

I just added some basic toolbar Alerts to my application and now I'm totally jealous. I have to redesign it as Kevin's implementation totally rocks!

Now the question is: where's the code?

Kevin Ragsdale : Screencast: Desktop Alert Callbacks

What will you do with VFPCompression ?

Craig Boyd has posted about his Visual FoxPro VFPCompression library, a tool that lets developers programmatically zip and unzip files.

While many may immediately see the benefit of using this approach for aiding in backing up files, there's another use that may not be immediately obvious.

Zipped documents for backup are nothing new but file formats that are actually zip files with multiple documents are becoming more popular. MindJet's MindManager has used a Zipped file format since 2005 (maybe even earlier) and Office 2007 will also be using this approach.

Essentially what it means is that a Word Document (.docx extension) can be renamed to ZIP and decompressed. Inside the zip file are all of the pieces required to define the Word document. You can also use Word to open other file formats as well. Read the walkthrough to get a better understanding.

But how can you use this new approach in your FoxPro development? Well, thanks to the VFPCompression FLL, dealing with the indiv…

Where Development Dollars Could be Spent

Markus notes that
Error Messages Drive Me Crazy and he's right. One can simply read various posts on the issues with Visual Studio to get a feel for it. Yes, it's hard to catch every bug - and fixes come along every while that help things out and the knowledge you gain on debugging certainly helps but if you're looking for things to concentrate on, as Markus notes "Giving me better error messages would remove my main productivity hurdle..."

Great post.

Rick and others are MVP'd again!

With all respect to John's list, Microsoft also does a good job of recognizing those individuals who do a lot for FoxPro, even if some of it is on the financial side of things. Just as John's list came out, the October round of FoxPro MVPs was announced and what a great list:

Rick Schummer
Alex Feldstein
Eric Den Doop

Ted's got a good list here!

Shedding Some Light: MVP'd again!

Do your bugs lurk?

Adam Barr has a great post about debugging: Software Engineering Goal: Expose Bugs Faster in which he suggests that the critical task in improving software engineering is decreasing, not the bug count, but the lurkability of bugs.

FoxPro is terrible for lurking bugs. Think of C5 errors. If you have a missing object pointer somewhere, it will generate a C5 error. but not immediately - just later on at some point in time.

Yes, we know about some resolutions to this (Don't Return Inside With), but it's a great example of a lurker.

Which is one of the reasons why tools such as Coverage Profiler and FoxUnit exist - (read Eric Sink's great post about Code Coverage). It's also one of the reasons behind my earlier work on the Code Analyst, as part of VFPX.

I'm getting ready to get started on building further betas on this (Randy Jean had asked me about it at the beginning of last month and I have been too buried to get into it). We've already got a list of some of the …