To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52887 Issue #:|52887 Summary:|Base creation of View causes error in MySQL Component:|Database access Version:|OOo 2.0 Beta Platform:|Other URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|gertblij
------- Additional comments from [EMAIL PROTECTED] Thu Aug 4 07:22:11 -0700 2005 ------- I tried to create a view combining vields from two tables in a MySQL database (V 4.1.13). The view ran fine in Base, but when I tried to save it I got: Error while connecting to data source Syntax error or access violation, message from server: "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 'View1' AS SELECT 'stockmaste', 'category', 'categorymaster', 'Category'. 'c' at line 1 --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
