TMyStoredProc parameter of type BOOL or BOOLEAN

jackfirst72 · Post by **jackfirst72** » Mon 06 Nov 2006 12:11

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.

jackfirst72 · Post by **jackfirst72** » Mon 06 Nov 2006 12:21

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"".

jackfirst72 · Post by **jackfirst72** » Mon 06 Nov 2006 12:26

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".

Antaeus · Post by **Antaeus** » Mon 06 Nov 2006 13:15

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

jackfirst72 · Post by **jackfirst72** » Wed 08 Nov 2006 07:38

OK, great.

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

Thanks again for your cooperation.

Antaeus · Post by **Antaeus** » Wed 08 Nov 2006 08:22

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