>Hi George,
>
>I'm working with VFP native tables all the time, I haven't chance yet to work with SQL Server, for my regret :(
>Our customers want predefined OutPut Format. It could be a table, or SDF file, or Printed Report, or Excell book, or whatever. I think, only for DBF it doesn't really matter the field order, but in other cases it's important. I have an Output template for another customer, now I want to modify this template for other customer. Here I have a problem of changing fields order in a table with ~80 fields. I had this problem before, but now I'm really thinking about writting a more flexible interface for modifying structure.
>
If the problem is the pre-defined format, why not drive the table into a cursor via a query? Whatever format you specify there will be the format of the the resulting cursor. Besides, customer needs often change. It's a lot simpler to modify a query, than it is a table. Further, you could give them the option to create their own format.
If I recall correctly, earlier in this thread you mentioned that you didn't like the VFP expression build. Why not "roll your own"?
George
Ubi caritas et amor, deus ibi est