To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=58795 Issue #:|58795 Summary:|SQL errors with backquote around object names Component:|Database access Version:|OOo 2.0 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|grodysk
------- Additional comments from [EMAIL PROTECTED] Fri Dec 2 07:43:57 -0800 2005 ------- CREATE TABLE `billing` ( `id` int(5) NOT NULL auto_increment, `people_id` varchar(20) NOT NULL default '', `datetime` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Master billing table' AUTO_INCREMENT=1 ; will yield... Unexpected token: ` in statement [CREATE TABLE ] I am in the process of replicating my MySQL database from our web site, to an offline copy we can use when not connected. I exported the complete structure and data via phpMyAdmin. The above is just a small clip to illustrate the issue. The back quote is a valid SQL method (i think), and should not cause an error in the OO SQL parsing. Thanks for looking into this, Steve 616-502-2454 (cell) --------------------------------------------------------------------- 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]
