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. ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier. Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
