>>>>> "Frank" == Frank Schönheit <- Sun Microsystems Germany
>>>>> <[EMAIL PROTECTED]>> writes:
Frank> I think what you want to have here is a view - basically a
Frank> server-side SELECT statement, which to the clients -
Frank> including OOo - appears as if it were a table. Instead of
Frank> creating Query1, you would simply create a view with the
Frank> very same SELECT statement.
Frank> Unfortunately, I just tried this with a MySQL 4.1.7 on
Frank> WinXP via ODBC, and got an error message whenever I tried
Frank> to create a view (no matter if via OOo or
Frank> otherwise). However, I even tried exactly the examples from
Frank> the MySQL documentation, which didn't work, too. In other
Frank> words: There is at least one MySQL version were creating a
Frank> view seems to be broken ...
Same here, Linux debian, MySql 4.1.11
I get a message of the sort:
--8<------------------------schnipp------------------------->8---
[MySQL][ODBC 3.51 Driver][mysqld-4.1.11-Debian_4-log]You have an error
in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near 'VIEW
`MatQuim`.`View1` AS SELECT `ID`, `Alumno`, `Ej1`, `Ej2` FR
--8<------------------------schnapp------------------------->8---
I tried this with the mysql and the odbc driver
Uwe
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
