[WARNING! This is an archived post and as such there may be things broken/missing here.. you have been warned.]
Yesterday I mentioned that I played with the 2 Xtras.Net XDN giveaways this month. I reviewed the first of those products here. Now, I want to talk about the other product: Unicus SQL Table Utility.
Honestly, I'm struggling with this review. I found this utility less useful than the last one. So, here's the scoop. This utility let's you browse your objects in your SQL server. It also generates code for a coupl scenarios. It will build SQL for selecting, inserting, and updating a table. It will also generate QA code against a stored proc. Finally, it generates VB6 code that can used to manipulate a table or execute a stored proc (it will build simple functions/subs or a complete class module).
I guess because I'm use code generation utilities like CodeSmith or MyGeneration I'm less than impressed with this utility. I like code generating my own code instead of generating someone else' code (I know what my code does, and am confident in what it will do).
Beyond that fact that I don't use VB6 anymore... I'm actually ramping up to put the latest VS 2005 on my main machine. I also only use stored procs. I guess the generation of the SQL statements could save a lot of works on tables that have lot's of fields, but considering that CodeSmith and MyGeneration are free and I can generate complete stored procs for a table with my own custom comments (this all becomes a lot less useful)
While the QA code generation is kind of cool, it's the only real feature I find useful (for me).
Barring all this if you don't want to write your own templates and you're still using VB6 this might be a fairly useful utility for you (I'm not so arrogant to think that I represent the only true programming user in the universe).
Xtras.Net has it for $108 right here.