Review of CodeAssist
Supplied on CD-ROM or downloadable from the Internet, installation of CodeAssist was speedy and problem free. My version ate about 6MB of hard disk space.
From the first launch, it's fair to say Access users may feel quite at home. Nope, not due to an innovative interface but rather a welcome screen that features graphics suspiciously similar to those featured in the Office database application.
Hmm, can you spell lawsuit?
Still, eager and raring to go, I took the well-organised quick start tour in an attempt to figure out the application. It turns out that generating code with this application consists of three main steps:
- Choose the database you want to work with
- Drag-and-drop the tables/fields you want to base your code on
- Select the type of code you want to generate from a template library
So I decided to put it to the test...
Unfortunately my initial experience with this first step didn't prove highly successful. I couldn't connect to my Access 2000 database, even when cunningly disguised behind an ODBC connection.
Still, who uses Access 2000—right? Ha!
Instead, I opted for the eternal Access 97 Northwind database—and was instantly given a pretty decent visual schema. Table structures, querydefs and relationships—they were all there—and looking rather impressive, I might add.
All ODBC / Access 97 databases are supported. Apparently.
Enter Stage Step Two
Next, I dragged-and-dropped particular fields from the tables into a Data Object, which is just a holding place for the data your final chunk of code will be based on.
I was particularly impressed by the way CodeAssist automatically handled information originating from multiple tables—identifying simple relationships as required.
Next up, you're required to select a Template library. These are pre-built templates around which your final code is built.
And we're not just talking about class code for Visual Basic programmers here. Oh no—C++, Delphi and Internet HTML templates are also bundled. It's particularly nice to see support for the more advanced (and as such, troublesome) technologies, such as MTS.
If you're a little unsure what type of code you should be generating or whether you should be using the DAO, RDO, ADO or numerous other templates... the help includes a groovy lil' selection wizard to assist in your decision.
But if the supplied templates don't suit your needs, you can always use the built-in Code Template Editor to create your own. Sure, the half-hour you take learning the syntax starts eating away at promises of time-saving code generation—but it could be worth the investment on larger projects.
Showdown at Code Corral
After the three steps, it's time for showdown at Code Corral. With a few clicks of the mouse, your Data Object is automatically turned into a screen full of code, ready for pasting into your latest project.
And for once, it's great to see good quality, personalised code—without a single 'Copyright Sheridan' notice! Very commendable.
Page 2 of 3