Re: links from queries to tables:

>>>>> "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