[Firebird-net-provider] FbParameters

[MartinT <mar...@ya...>]

hello there

i am hitting an SP which contains 20 return parameters. for this particular
routine i only need to return data from 3 of the 20 return parameters. i can
achieve this by manually constructing an sql like this: "SELECT ColumnA,
ColumnB, ColumnC FROM sp_1(?)".

however i would much prefer to use the FbParameter objects instead. yet when
I use CommandType.StoredProcedure and only declare the 3 output parameters
that I want, the SP still returns a dataTable containing all 20 columns.

in Firebird 1.5 how is it possible for me to only return certain columns
from the SP using parameter objects and not a dynamic SQL?

thanks
-- 
View this message in context: http://www.nabble.com/FbParameters-tf3151544.html#a8738512
Sent from the firebird-net-provider mailing list archive at Nabble.com.