Simon,

if ParamChar is ':' and ParamCheck is true (both defaults), I guess it
actually does expect an integer and that there's something wrong with the
definition of your procedure. Your coding seems fine (though I'm not
experienced with either BCB or stored procedures), except that you
interchangably use Transaction and Transaction1 (which I guess is just a
spelling mistake). Show us the definition of your procedure,

Set

At 10:59 29.03.2001 -0000, you wrote:

>the code that I'm using is this.
>
>
>String myString = "Simon";
>TIB_DSQL *Dsql = new TIB_DSQL(Application);
>Dsql->IB_Connection = Connection;
>Dsql->IB_Transaction = Transaction;
>Transaction1->StartTransaction ();
>Dsql->BeginBusy(true);
>Dsgl->SQL->Text = "execute procedure myproc(:Ret)";
>//Where ret is a varchar(20)
>Dsql->Prepare();
>Dsql->ParamByName("Ret" )->AsString = myString;
>Dsql->Execute();
>Transaction1->Commit();
>Dsql->EndBusy();
>delete Transaction;
>delete Dsql;
>
>And a warning message is shown "Simon is not an valid integer value"
>and then is the program killed.
>
>Any ideas?????
>
>thanks
>Simon