I am using mysql 3.23.49-Max on Windows and I have configured InnoDB for transactions My front-end is created in Visual Basic connecting using MyODBC 3.51.02 I can be able to access the data using visual basic perfectly and it is supporting transactions okey. I am creating the reports in Crystal Reports 8.0 connecting using MyODBC When I create a report connecting to a single table the data can be previewed fine But when I create a report that has to relate two tables it gives me an error while I try to preview the report. The error I am getting is as follws.
ODBC error: [MySQL][ODBC 3.51 Driver][mysqld-3.23.49-max]You have an error in your SQL syntax near 'INNER JOIN 'rctdt' rctdt1 ON receipt1.'receiptno'=rctdt1.'rctdtno'} ORDER BY r' at line 1 This error comes with just an okey. When I click OK I get another message Error detected by database DLL I was earlier able to create the reports using mysql-3.23.49 with MyODBC 2.50 But I need the system to support transactions that is why I moved up to MySql 3.23.49-max with MyODBC 3.51.02 Any help will be highly appreciated since this system is crutial for my organisation. Kind regards Harrison Njamba Somak Travel Limited P.O. Box 48495 Tel 535509 / 0733-923214 Nairobi Kenya ____________________________________________________________________ - This email and any files transmitted with it are confidential and intended solely for the use of the addressee. If you have received this email in error you may not disclose, copy, distribute or act upon its contents without the authors prior written consent. Please can you notify the system manager at [EMAIL PROTECTED] immediately and delete this email. - Any views or opinions expressed are those of the author and do not necessarily represent those of Somak Travel Limited, Kenya. - This footnote also confirms that this email message has been swept for the presence of computer viruses. No responsibility can be accepted in the event that a virus is contained within it or any attachments. - SOMAK TRAVEL LTD - KENYA NAIROBI, PO BOX 48495. Tel: +(2542) 557832 Fax:+(2542) 535175 MOMBASA, PO BOX 90738. Tel: +(25411)486197 Fax:+(25411)487324 ____________________________________________________________________ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php