Re: Re: links from queries to tables:

On Fri, 2005-07-22 at 16:25 +0000, Uwe Brauer wrote:
> >>>>> "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

Hi Uwe,

I believe the VIEW command is not actually implement in the 4.x series
of MySQL, but in the newer 5.x series.

Regards
Jonathon
-- 
OOo Tips (RSS) - http://mindmeld.cybersite.com.au/tips.rss
OOo Knowledgebase - http://mindmeld.cybersite.com.au/
Cybersite Consulting - http://www.cybersite.com.au/
Training4Linux - http://www.training4linux.com