aj__
09-22-2003, 08:06 PM
I'm using Borland's BDE with a mySQL database through myODBC. It works fine except two things:
1) When I try to refresh a dataset I get an EDBEngineError "Index does not exist" and sometimes i get "Table does not support this operation because it is not uniquely indexed"
2) My program says "Boolean expected but SmallInt recieved". I've tried with bool, tinyint(1) and tinyint(4) in my mySQL database but nothing seems to be recognized as a boolean.
Does anyone has at least an idea what possibly may be wrong here?
1) When I try to refresh a dataset I get an EDBEngineError "Index does not exist" and sometimes i get "Table does not support this operation because it is not uniquely indexed"
2) My program says "Boolean expected but SmallInt recieved". I've tried with bool, tinyint(1) and tinyint(4) in my mySQL database but nothing seems to be recognized as a boolean.
Does anyone has at least an idea what possibly may be wrong here?