>Mark, the code is great...
>BTW,do you have any idea on how to insert a field in the midle of table ?
Can't do it with Alter Table as this will only add fields to the end of the field list. You would have to recreate the table as a new table programmatically to get the fields in the order you want them. Then apend the data from the old table, delete the old table (which loses all DBC properties with respect to this table), rename the new table. Best way is to develop apps that are not reliant on the order of the fields in a table.
Mark McCasland
Midlothian, TX USA