squidsrus85 wrote:

> It was after this, the table is then created, and crashing, but now that I know about the DDL, I am sure it will all go well.

As has been indicated, managing structure is somewhat different to managing the
data you are putting into it. Most of my own databases now have a 'version' tag
in them which I can check, and if it matches what the program expects, then it
uses the existing tables, otherwise it updates the database to the right format.

The tag also knows if this is a blank database, and so will modify the existing
content if required to bring it up to the current version. Changing field names,
adding and populating missing fields and so on. Although I would normally just
use the update scripts manually ( via Flamerobin since the servers tend to be on
Linux ;) ) to build a copy of the live data to the new format, and check the
results before switching the live database and programs. Older versions of the
program see a later version tag and advise that the program needs updating ...

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php