[dba-users] OOo1.9.92 altering database

[Juraj Trenkler]

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.

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.

Is this bug or I am doing something wrong? Only SELECT for hsqldb?
juraj
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]