Rick Flosi wrote: > now you do record again with the --edit flag. > This will open your default text editor and probably include something > at the bottome of the text file about the missing field 'foo'. > Then you write the SQL needed to get your current database up-to-date > with the new schema in this text file. Something like: > ALTER TABLE my_table ADD foo TEXT; > And save the file which will be written under the previous versions > path as upgrade from_old_version_to_new_version.sql > > When you then do sqlobject-admin upgrade it will first look at your > current version from the database and then look for the upgrade script > you just created and call that to upgrade to the current version.
Thanks, it worked, but there must be no ';' at the end. But I don't see why it isn't automatic. At least the ALTER line could be prefilled when the editor comes up? This does make the thing much more simple, doesn't it? Regards _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
