MySql Generates Windows App Event Log Warning

[Ed Sharp]

When I use any SQL statement that is not a plain select ... from that involves the "limit" clause, an warning is placed in the Windows App Events Log. I am using MySql in a business environment that maintains all records for the mandatory 7 years so I use the limit clause extensively when generating work tables to use in a datagridviews (insert into work select... from ... where...order by....limit ...).

Everything works fine in the application, but I generate tens of thousands of the following warnings.

The description for Event ID ( 100 ) in Source ( MySQL ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Statement may not be safe to log in statement format. Statement: update BKSBR4_101 set BR_SW = 9 where BR_Acct = 61201 AND br_deposit = 500.00 AND br_sw <> 9 order by br_datetran limit 1

Is there any solution to this problem?

Regards

Ed Sharp