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

Reply via email to