Hi Roger,
the problem in making the general JDBC driver "ALTER TABLE" capable is
that the alter table statement is not standardized.
So every database has his own format :-(
Best regards,
Ocke
Roger Keays wrote:
Hi,
I've noticed that in Base 2.0rc2 (and also earlier versions) that when
you use the JDBC bridge OOo will not let you modify any of the
columns. This seems to be the case regardless of the actual JDBC
driver used and its capabilities.
E.g. if you create a "JDBC" database with the mysql jdbc driver you
cannot alter the columns, but if you use the "Mysql (JDBC)" driver you
can. Presumable the latter is just a thin wrapper around the JDBC
driver which does something special.
Couldn't the JDBC bridge be written to allow column modifications?
Roger
--
Ocke Janssen Tel: +49 40 23646 661, x66661
Dipl. Inf(FH) Fax: +49 40 23646 550
Sun Microsystems Inc.
Sachsenfeld 4 mailto:[EMAIL PROTECTED]
D-20097 Hamburg http://www.sun.com/staroffice
Example isn't another way to teach,
it is the only way to teach.
Albert Einstein
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
