Hi Juraj, > I tried to alter hsqldb database in my .odb file. (OOo1.9.92, > Windows XP). When I want to change field for example char(4) to > char(5) OOo only deletes original field and then creates new with > the same name. I loose all data from that field.
Cannot reproduce. Do you have a small sample .odb? > So I tried to add new field and to fill it with data from another > field. SQL command "ALTER table SET field = another_field". But > nothing happens. The same sql command with MySQL database in OOo > works as expected. The syntax for HSQLDB is simply different (I'm not sure at the moment to which extent ALTER TABLE is part of the standard, and which of both DBs would be closer to it). Look at http://hsqldb.sourceforge.net/web/hsqlDocsFrame.html. Ciao Frank -- - Frank Sch�nheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems, Inc. http://www.sun.com/staroffice - - OpenOffice.org Database Access http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
