>I have an application I made for a friend's school. I need to add a field to a table, but I'm wondering what is the correct way to do this without disturbing the data in his database.
>TIA
Apart from ALTER TABLE, you can also have an empty copy of the database (with the new structures) and issue APPEND FROM for each table. The tricky part is to copy parent table before child table (avoid "trigger failed"). Also, if you have a lot of data, it helps to compare table structures and skip tables that haven't changed (use COPY FILE instead).
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)