Caro egostar,
the link you've send me is listed above, comments in red:
<<
Dear All,
I am porting a Delphi6 & BDE Paradox project onto MySQL 4.1 Server. To access MySQL, I am using BDE & MyODBC 3.51.12
SIMPLY
1. Set "return mactching rows" to enabled.
It's MySQL property.
2. Alter your table(s) so there are enough number of unique fields(I altered one field as primary key).
I just have 1 primary key
DETAILED
STEP 1. I got same error message. Then, I checked the table which error occurs. I set the "Return matching rows" to checked (in system data sources ->Configure->Advanced->Flags1 /3.51.12.00).
Then I saw that error message changed (to something like "more records when expecting only one). So, I checked my table. There were a lot of dublicate records. No, I had no primary, unique, index, etc. to prevent this situation on SQL server side, but I have code to prevent in client side (A code simply using TDataSet Find method). I understood that Find method does not work well.
STEP 2. I deleted the duplicatd records and alterer one of fields in table as primary key. Ooops, the error message was gone
No duplicate records
>>
I'd like to know if someone has an ODBC version newer then 3.525.1117.0 (for Win2K / XP)