Subject Re: [IBO] TIB_DSQL???
Author simpor81@hotmail.com
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



Dsql->SQL->Text = "EXECUTE PROCEDURE SetL
(:FromNodeCode, :ToNodeCode, :LUTypeCode, :Ret,"
" :ModeCode, :NumberOfUnits, :CUGCode, :CLCode, :LUCatCode, :Fr
omX,"
" :FromY, :ToX, :ToY)";

Dsql->Prepare();




--- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> > >I have a little question. Can't the TIB_DSQL component handle
strings.
> >
> > Yes, it can handle strings into char and varchar columns. You
can't plug
> a string into a blob, though.
>
> MyDSQL.ParamByName( <param> ).AsString := <some string>;
>
> This will work with a Blob column.
>
> HTH,
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com