MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

Re: use Store proc from Delphi
Posted by: Daniel Altamira
Date: November 23, 2005 07:31AM

Hi, js_gros. I develop with Delphi and I had the same problem.

There is a MySQL bug when you try to call SP without parameters, the parenthesis "()" at the end of the SP Name doesn't appear. There is no problem if your SP has parameters, but there is a bug if your SP has not parameters.

I solved it using TADOQuery instead TADOStoredProc, in the SQL property write this: "CALL StoredProcName();" then in your code use ExecSQL.

This is a temporary solution, I hope that this bug is solved.

Best regards.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
use Store proc from Delphi
5846
js gros
September 01, 2005 09:34AM
Re: use Store proc from Delphi
3124
Robin Schumacher
September 01, 2005 12:31PM
Re: use Store proc from Delphi
2941
IASTER AKI
October 17, 2005 06:00AM
Re: use Store proc from Delphi
3284
Huali Li
November 05, 2005 10:34PM
Re: use Store proc from Delphi
3278
Raul Manzanares
November 16, 2005 10:23AM
Re: use Store proc from Delphi
5395
Daniel Altamira
November 23, 2005 07:31AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.