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.
>>Have you never been in situations, when you want to modify structure of existing tables? Change the order of fields? Do you always change the structure programatically?
>
>Nadya,
>
>The order of the fields shouldn't ever come into play. So it shouldn't make a difference. I'm not terribly familar with SQL Server, but I think I've heard that you can't insert a column into a table without completely re-building the data structure from scratch in that environment.
If it's not broken, fix it until it is.
My Blog