Hi Michael, > me again ;) Probably there is bug regarding the save process in Base > when changing a default value or a description text. It appears with > MySQL and Ingres, but not with HSQLDB. I reviewed the driver method > OTable::alterColumnByName, but I didn't find the root cause for this. > > To reproduce try the following: > > 1. Create a table with a few columns, e.g. four. The name and the type > of the columns is arbitrary. > 2. Close the table > 3. Open the table design view > 4. Try to change the description text and the default value of one or > more columns and save it > 5. Reopen the table design view and check if the changes were saved > 6. Repeat steps 4. to 6. multiple times. The changes are not always > saved.
Definitely a bug - care to visit IssueZilla? One thing to mention is that the description text and the default value, as you see them in the UI, might not be what you expect them to be. That is, those values are completely client-side at the moment, even if the underlying database would support them, to. So, whatever you enter here, is not sent to the database, it's just used in Base's own UI. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
