Friday, February 18, 2011

OpenOffice Base MySQL ALTER table structure

I may have missed it, but it's likely that you will have trouble refreshing table structure in OpenOffice Base if you connect to MySQL and ALTER a table.

Basically, the answer is to add the fields in the Edit of the table(s) in Base to match the new columns. If you don't know what they are, create a new table connecting to the ODBC of MySQL and edit the appropriate table.

It's a real pain, but there you are.

No comments:

Blog Archive