Devart Forums

I defined a parameter of type BOOL in a stored procedure and when I double click on the TMyStoredProc component, choose the "Parameters" item, I can see all my params even the one of type BOOL. But the problem is when I click on its name on the left, I get the message "EDParam: Data type not found".
I tried to change the type of the parameter into the stored proc with "BOOLEAN" or "TINYINT(1) but the problem still occurs.
What is the right way to define a boolean "in" parameter in a stored procedure ?
My configuration is :
- mysql server 5.0.21
- myDAC 4.30.1.17
- Delphi 7 Enterprise Edition
Thanks for your help.

More precisions :
when I select the TMyStoredProc component in the IDE and choose the "Params" property in the object inspector, I get the message "Unknown column type "BOOL" in "IN my_in_param BOOL"".

Precisions again :
About my last info, if the type in the stored proc is "TINYINT(1)", I can choose the "Params" property in the object inspector without getting the error message, but when inside the parameters configuration form I select the parameter in the left area, I get the message "EDParam: Data type not found".

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next MyDAC build.

OK, great.

Could I be informed from yourself when the fix will be available for download ?

Thanks again for your cooperation.

The next build of MyDAC will be released in about one month. Please watch for announcements on this forum.