Re: Specify decimal scale/precision for output parameter
Frediano Ziglio <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
2009/8/31 Frediano Ziglio <[email protected]>: > 2009/8/27 Damien Churchill <[email protected]>: >> 2009/8/27 Frediano Ziglio <[email protected]>: >>> 2009/8/27 Damien Churchill <[email protected]>: >>>> 2009/8/27 Frediano Ziglio <[email protected]>: >>>>> 2009/8/27 Damien Churchill <[email protected]>: >>>>>> I was wondering how you would specify the scale/precision for an >>>>>> output parameter of a RPC call that is null to begin with, since if >>>>>> you don't currently it just uses decimal(38,0) which looses everything >>>>>> trailing the decimal point. >>>>>> >>>>>> Any one know how?? >>>>>> >>>>>> Thanks, >>>>>> >>>>>> Damien >>>>> >>>>> Using which library ?? >>>>> >>>> >>>> Using db-lib and the dbrpcparam etc functions. >>> >>> In theory you should pass in value a DBDECIMAL initialized with >>> precision/scale even for NULLs. Currently I think this does not works >>> that fine (although I have a small patch). >>> >> >> Is there any chance I would be able to test/experiment with this patch? > > Here you are. > Applied updated patch. Also applied a small fix for numeric -> numeric conversions (just some minutes ago). Note however (as stated in previous mail) that ABI for DBNUMERIC/DBDECIMAL structure is different from MS ABI. Hope to get this fixed ASAP. freddy77