🚀 go-pugleaf

Here a simple example of using TADOStoredProc and retrieving the result.

    TADOStoredProc *query = new TADOStoredProc(NULL);

    query->Connection = DBConnection;

    query->ProcedureName = "up_mystoredproc";

    query->Parameters->CreateParameter("@Parm1", ftString, pdInput, 4,
str1);
    query->Parameters->CreateParameter("@Parm2", ftInteger, pdInput, 4,
int1);
    query->Parameters->CreateParameter("@Parm2", ftInteger, pdInput, 4,
int2);
    query->Parameters->CreateParameter("@Parm2", ftInteger, pdOutput, 4, 0);

    query->ExecProc();

    return (int) query->Parameters->FindParam("@Result")->Value;


"Stephane Baillargeon" <sbaillargeon@microids.com> wrote in message
news:3ddbb1b4@newsgroups.borland.com...
> I would Like to know how to use a stored procedure with the TADOStoredProc
> Component.  I am familliar with the use of TADOQuery and TADOConnection
but
> the thing that eludes me is the actual binding of parameters within the
> stored proc at runtime.
>
> This stored proc has 4 params:
> RETURN_VALUE
> @loginame
> @name_in_db
> @grpname
>
> I can't quite understand how to work with this stored proc although I have
> read the help files that come with the software (BCB 6 Ent).
>
> If someone would have examples or papers on using this component for sql
> server internal (master) stored procedures, please let me know.
>
> Regards,
>
> Stephane Baillargeon
> Video Game Programmer
> Microids Canada
>
>