Bug #31684 update table from MS ACCESS table to mysql table using crystal report

• Submitted: 18 Oct 2007 1:47
• Modified: 18 Oct 2007 2:19
• Reporter: s w
• Status: Duplicate
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: Mysql client version 5.1.11
• OS: Windows (xp)
• CPU Architecture: Any

[18 Oct 2007 1:47] s w

Description:
hi there
i have a problem with mysql table which cannot used in crystal report. i'm using Windows XP sp1 crystal report 9. when i want to update ACCESS table with mysql table there was a error message like:
"Query Engine Error:'HY000:[MySQL][ODBC 3.51 Driver][MySQL-5.0.45-community-nt]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 'mydb`.`mytable` LIMIT 0` at line 1'.
please help me for the problem thx.

How to repeat:
hi there
i have a problem with mysql table which cannot used in crystal report. i'm using Windows XP sp1 crystal report 9. when i want to update ACCESS table with mysql table there was a error message like:
"Query Engine Error:'HY000:[MySQL][ODBC 3.51 Driver][MySQL-5.0.45-community-nt]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 'mydb`.`mytable` LIMIT 0` at line 1'.
please help me for the problem thx.

Suggested fix:
give me solution for the process update table can work successfully

[18 Oct 2007 2:19] Jim Winstead

Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

This was a repeat of Bug #31682.