StoredProcedure in DELPHI 7
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;
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.