>I want to write an update program to update a table one of my products and i need to add a field between field 4 and 5,How?
>i write this code but it add that field at the bottom of fields :
>
>Alter Table contacts Add cdate c(10)
>
In order to do that, you've to
- create new table with required structure
- append records from the old one
- delete old table
- rename new one
It gets much more complicated if the table in question belongs to DBC. The
Stonefield Database Toolkit (SDT) can handle it for you.
--sb--