Re: use Store proc from Delphi

[Raul Manzanares]

Thanks Huali for your "Paperback solution" ;D , but I'd like to use the component that comes with Delphi for that purpose... and if I can't, I'm not going to use stored procedures I think... It's not so necessary for me at the moment.

I think this is a bug. I don't know if it's either from Delphi, from MySQL server or from MySQL Connector (I use the latest production version, the ODBC/Connector 3.51.12). But the thing is that, although you add parameters to the call in Delphi, Delphi translation (or Connector translation) is like that: call `stored_procedure`('a_parameter'), and that doesn't work as well.

And this, between the '{ }'. And so, I think the problem is not the missing of '()' like Robin says, I think the problem is the '{ }' or something strange. Because the error message is an SQL syntax error... .

If anybody find the solution of how connector use instead the newer, or if the problem is in the Delphi environment, please post it here!! hahahaaha...

read you soon,

regards