MySQL Forums
Forum List  »  Delphi

StoredProcedure in DELPHI 7
Posted by: Alptelkin AKAT
Date: May 08, 2006 01:28AM

Hi;

I am use Delphi7 and TADOStroredProc component.
But I dont run StroredProcedure.
Dont gets paraneters automatic or I am insert to parameters
but dont work.

Please not bla bla bla only sample.

MySql 5.xxx
////
CREATE PROCEDURE proc_Test (IN param1 INT,OUT param2 INT)
BEGIN
SET param2=param1*10;
END;

ADOConnection1.ConnectionString := 'DRIVER={MySQL ODBC 3.51 Driver};' +
'SERVER=xserver;' +
'DATABASE=test;' +
'UID=root;PWD=****;OPTION=3;';

ADOConnection1.Open;
ADOStoredProc1.Connection := ADOConnection1;
ADOStoredProc1.ProcedureName := 'proc_Test';
ADOStoredProc1.Parameters.CreateParameter('param1',ftInteger,pdInput,0,10);
ADOStoredProc1.Parameters.CreateParameter('param2',ftInteger,pdOutput,0,NULL);
ADOStoredProc1.ExecProc; // Error in line any errors;

Options: ReplyQuote


Subject
Written By
Posted
StoredProcedure in DELPHI 7
May 08, 2006 01:28AM


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.