>>I'm told that I must move all new fields before fields adddate and addtime which are the last fields in my main table.
>>
>Position dependent fields in a relational database is a problem itself. In a relational database the only things the developer is supposed to depend on are the table name and the field name.
>
>You may be able to do what you want but it wil not be easy. You will need to copy all of the data oput of the existing table to a temproary table. Then recreate the existing table completley so the fields are positioned where you want them. Since you will need to destroy the existing table before you can recreate it you will then need to recreate any indexes that existed and any relations that existed relaed tot that table. Once all of that has been done you will then need to append all of the data from the temporary table you created in the first place to save the data.
An easier way out of this could be:
- copy all the data somewhere (or at least the adddate and addtime fields)
- drop the adddate and addtime fields
- add the new fields
- add the adddate and addtime fields as new fields
- set relation to recno() into the copy of the table and replace 1:1 the adddate and addtime fields from it
- discard the copy if everything went fine
Backup first, off cross :)