Hi kevin,


>>Now, I do not expect you to write a full example, but hopefully you'll see what I mean here with data munging and why VFP is particular strong here. Maybe you can launch some ideas (no, no preprocessing on the databaseserver), constructive comments to get a better picture.

>The only problem I can foresee here is getting a good example to fit in with my current example, another again is that the app was designed as a fox app, and if designed as a C# app the structure of the DB would likely be massively different.

Aiii, I think this is a massive mistake. The database should be structured independed of the application attached, and more or less should follow the normalisation rules. Modeling a database is bound to certain rules (like normalisation) and is a task that should be totally independed from any application attached to it. Of course in practise you might add some redundacy to overcome massive digging into the database to get your query results, but that also should stand loose from the development platform, and should solely be done in order to query more effectively in the DML (SQL) language.

I suspect this is one of the pitfalls people could fall in when it seems difficult to get your data in a form that is directly usable in your front end, but this is really bad, bad practise.

Walter,