thanks Helen, it works !

Helen Borrie wrote:

>At 04:53 PM 9/11/2004 +0200, you wrote:
>
>
>
>>(FB 1.5, Delphi7 )
>>how must be declared output parameters calling stored procedure with
>>select clause ?
>>the procedure has one input and 7 output parameters.
>>
>>select * from _stored_procedure ( parameters )
>>
>>
>
>select * from stored_proc (:param1, :param2, :param3....)
>
>Make sure the input parameters are in the correct order (same as the
>declaration order in the SP). You can use any names you like for the input
>parameters. Often in Delphi apps you will want to use parameter names that
>match those of corresponding fields in a linked dataset.
>
>You need to refer to the output parameters by their names as declared in
>the SP's RETURNS clause.
>
>Also make sure it is the type of SP that can return a dataset (uses
>FOR..SELECT...DO...SUSPEND )
>
>./heLen
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>