freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] Specify decimal scale/precision for output parameter

From: Konrad J Hambrick <konrad AT payplus.com>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Specify decimal scale/precision for output parameter
Date: Thu, 27 Aug 2009 09:58:24 -0500

Damien Churchill wrote:

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??

Damien --

Maybe use COALESCE( TheField, CAST( 0 as DECIMAL( L,P ))) ?

HTH

-- kjh

[freetds] Specify decimal scale/precision for output parameter, Damien Churchill, 08/27/2009
- Re: [freetds] Specify decimal scale/precision for output parameter, Konrad J Hambrick, 08/27/2009
- Re: [freetds] Specify decimal scale/precision for output parameter, Frediano Ziglio, 08/27/2009
  - Re: [freetds] Specify decimal scale/precision for output parameter, Damien Churchill, 08/27/2009
    - Re: [freetds] Specify decimal scale/precision for output parameter, Frediano Ziglio, 08/27/2009
      - Re: [freetds] Specify decimal scale/precision for output parameter, Damien Churchill, 08/27/2009
        
        Re: [freetds] Specify decimal scale/precision for output parameter, Frediano Ziglio, 08/31/2009