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 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
