> On 02-Aug-2004 06:38:28, James Armstrong wrote:
> I have done it two ways, the first is to include a sql text file that I
> execute on their database using isql from the install program. The other
> method I have used is to have the program check the fields and if they
> are not there or are not the correct type, issue a sql command to modify
> the database directly. This is done when the database connection is
> opened before the tables are opened.

Thanks, but how do you guarantee that these changes to the database won't
kill the data in the tables? Wouldn't either of these approaches for tables
to lose data content? Don't you have to dump the data out of the database
to a text file first, then change the schema, then re-import the data back
again?

Regards,
Myles

===============================
Myles Wakeham
Director of Engineering
Tech Solutions US, Inc.
(480) 451-7440
www.techsol.org