Inherited an application written in Access. Have converted the GUI to C# with a real backend database. Sort of...
Part of the application allows the end user to write queries to be used in reports (which they write as well). The queries return both fields from the database, and various agragates. At the moment they are using the Access Query Wizard to write them.
Since this forces some of the data to live in Access, I've been trying to re-write it.
Ok, so I can provide a GUI where they can select fields, put clauses in, etc. But what I can't easy replace is the ability to use VBA functions in Access SQL. So you can do something like:
select MyFunc(col1) from table1
While the users can't write their own functions, trying to convert this automatically to proper SQL is a pain. Oh yes, this has to work against a non-SQL Server.
When I'm not busy trying to rewrite the world, recently I've been busy craming up on .NET 2.0 for the Beta exams I'm going to be taking. Unfortunately because they are only available over a short span of time, in about 4 weeks, I'll have a week with 4 exams in it. And for some reason just about every time I take them I only get 15 minutes for comments at the end (some of the questions have been... questionable :) ). One of the reasons that I go for .NET exams is that I find it forces me to learn more, and look at areas which I don't normally cover.
Print | posted on Thursday, February 09, 2006 9:33 PM