Velo, Rapido | This is about a few different things.
OpenOffice has a database app. It has come a long (long, long) way over the last few years but uff is it ever just not there yet. I do need the query browser. Things you can’t do with OOo Base include add a fulltext index. Not with the gui because the gui doesn’t know that much, and not with the query browser because it balks.
CREATE FULLTEXT INDEX `FILER_NAME` ON `commcand` (`FILER_NAME`); gets me an error (“syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIK”) in Base’s interface (“Run Query”) but worked just fine at the mysql command line. Same for “
SHOW INDEX FROM tablename“. Works fine at the command line, OOo balks.
So OOo Base isn’t just translating between the two.
I’ll probably update this post as I come up with more new and different things to complain about.