Dna St 13. Apr�l 2005 09:56 "Frank Sch�nheit - Sun Microsystems, Inc." napisal: > > > 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. > I tried UPDATE according to hsqldb syntax but it does not work. No change in table. If I make mistake I get error message.
As I have written with MySQL sql commands work as expected. juraj --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
