Subject | Re: [IBO] TIB_ROW |
---|---|
Author | Paul Vinkenoog |
Post date | 2003-11-16T13:46:48Z |
Hello Peter,
execute procedure MyProc :ThisParam :ThatParam
After preparation, you can set the params just like you do for any
dataset, with Params[i] or ParamByName( 'ThisOrThatParam' ).
BTW, if you use ParamByName a prepare will be done automatically if
necessary.
Then you call MyDSQL.Execute. If the SP returns any values, they will
be available via MyDSQL.Fields[i] and MyDSQL.FieldByName( 'Name' ).
Greetings,
Paul
> I believe I can assign the params to a TIB_DSQL , but how do I callIt works the same, just set the SQL property:
> my stored procedure from here ?, previously I have only used an
> TIB_Stored procedure ?
execute procedure MyProc :ThisParam :ThatParam
After preparation, you can set the params just like you do for any
dataset, with Params[i] or ParamByName( 'ThisOrThatParam' ).
BTW, if you use ParamByName a prepare will be done automatically if
necessary.
Then you call MyDSQL.Execute. If the SP returns any values, they will
be available via MyDSQL.Fields[i] and MyDSQL.FieldByName( 'Name' ).
Greetings,
Paul