>Hi Ko,
>
> We have an already written by my colleague application, called XForm, which can convert one input structure to another. Each field has its own converting algorithm (or function), and each configuration is stored in so-called 'MetaFile'. My colleague invented this tecnique and originally I planned to implement something similar, but then I gave up this idea. The problem with this technique is that is too much complicated in its current implementation and noone except him can deal with it... Therefore I took a different road: I created parent-child scheme for each configuration: in parent table I store GroupBy, OrderBy, Description, etc. fields and in child - each field in output table. But my problem is deeper than that. As you can see from the example you helped me with, we didn't run field by field transformation. We ran 2 or 3 SQLs instead and called function GetMedianValue (BTW, I created a FAQ here GetMedian). So the question is: how can I generalize this approach? Do I have to
>create independant program (or part of the program) for each configuration and when just reference it somehow?

---

Nadya,

Sorry for not understanding.
The problem is not in the conversion to another table?
Can you please explain the problem where the problem lies then?

TOA, KW

---

>Regarding color formatting HTML: Mike Helland created a program called mhHTMLCode, which converts VFP program into HTML color-formatting code. This file is in Files section. I modified his program a little in order to not colorize words in string expression. Unfortunately, my code is not completely correct and it doesn't do, what I want. I finally gave up this idea, because I spent too much time on it inspite of my current job.

---

looks good, but i have to download mike's table too.