Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Implicit conversion of NUMERIC and stored procedure

4 posts in Database Last posting was on 1999-10-12 13:25:59.0Z
Stéphane Le Guével Posted on 1999-10-06 13:37:24.0Z
Newsgroups: sybase.public.powerbuilder.database
Date: Wed, 06 Oct 1999 15:37:24 +0200
From: "Stéphane Le Guével" <sleguevel@peaktime.fr>
Organization: PeakTime
X-Sender: "Stéphane Le Guével" <sleguevel@cheer.peaktime.fr> (Unverified)
X-Mailer: Mozilla 4.04 [en] (WinNT; I)
MIME-Version: 1.0
Subject: Implicit conversion of NUMERIC and stored procedure
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 35
Message-ID: <356_37FB5094.773B4A20@peaktime.fr>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.database:11391
Article PK: 303798

Hi,

I'm running PB 6.5.1 under NT4 on the client side and Sybase Adaptive
Server 11.5 for NT on the server. When retrieving data in a crosstab
datawindow with a numeric retrieval argument and involving a stored
procedure, I sometimes receive the following error:
Select error: Scale error during implicit conversion of NUMERIC value
'<...>' to a NUMERIC field.

When I say it 'sometimes' happens, I mean it always gives an error with
the same passed values, otherwise it works fine.
I tried the stored procedure alone in SQL Advantage with the 'buggy'
retrieval argument values and it worked fine, so it doesn't come from
the sp itself.
I built a simpler datawindow with a quick select and the same stored
procedure, and it behaved exactly as the crosstab one.

For you to know, the retrieval argument is declared as a NUMBER in the
datawindow and the stored procedure expects a Numeric (10,2). If the
argument passed in the datawindow is, for instance, 1.5 it works fine,
but the value 2.2 gives each time:
Select error: Scale error during implicit conversion of NUMERIC value
'<2.200000000000000256>' to a NUMERIC field.
That's amazing!

I saw, in the Sybase Technical Bulletin, a similar reviewed case under
the issue #: 198840 but there is no given solution.
Can anyone help me with this?

Best regards,
Steph.


Steve Katz [TeamSybase] Posted on 1999-10-11 13:14:39.0Z
Newsgroups: sybase.public.powerbuilder.database
Date: Mon, 11 Oct 1999 09:14:39 -0400
From: "Steve Katz [TeamSybase]" <katz_s@jpmorgan.com>
Reply-To: katz_s@jpmorgan.com
Organization: Morgan Guaranty and Trust Company
X-Mailer: Mozilla 4.04 [en] (WinNT; U)
MIME-Version: 1.0
Subject: Re: Implicit conversion of NUMERIC and stored procedure
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Lines: 41
Message-ID: <356_3801E2BF.1CD350A5@jpmorgan.com>
References: <356_37FB5094.773B4A20@peaktime.fr>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.database:11332
Article PK: 303740

Is the variable in your PB code typed as a Decimal or as
Decimal{size}{precision}? If the former, try the latter.

HTH,

steve
[TeamSybase]

Stéphane Le Guével wrote:
>
> Hi,
>
> I'm running PB 6.5.1 under NT4 on the client side and Sybase Adaptive
> Server 11.5 for NT on the server. When retrieving data in a crosstab
> datawindow with a numeric retrieval argument and involving a stored
> procedure, I sometimes receive the following error:
> Select error: Scale error during implicit conversion of NUMERIC value
> '<...>' to a NUMERIC field.
>
> When I say it 'sometimes' happens, I mean it always gives an error with
> the same passed values, otherwise it works fine.
> I tried the stored procedure alone in SQL Advantage with the 'buggy'
> retrieval argument values and it worked fine, so it doesn't come from
> the sp itself.
> I built a simpler datawindow with a quick select and the same stored
> procedure, and it behaved exactly as the crosstab one.
>
> For you to know, the retrieval argument is declared as a NUMBER in the
> datawindow and the stored procedure expects a Numeric (10,2). If the
> argument passed in the datawindow is, for instance, 1.5 it works fine,
> but the value 2.2 gives each time:
> Select error: Scale error during implicit conversion of NUMERIC value
> '<2.200000000000000256>' to a NUMERIC field.
> That's amazing!
>
> I saw, in the Sybase Technical Bulletin, a similar reviewed case under
> the issue #: 198840 but there is no given solution.
> Can anyone help me with this?
>
> Best regards,
> Steph.


Stéphane Le Guével Posted on 1999-10-12 09:36:44.0Z
Newsgroups: sybase.public.powerbuilder.database
Date: Tue, 12 Oct 1999 11:36:44 +0200
From: "Stéphane Le Guével" <sleguevel@peaktime.fr>
Organization: PeakTime
X-Sender: "Stéphane Le Guével" <sleguevel@cheer.peaktime.fr> (Unverified)
X-Mailer: Mozilla 4.04 [en] (WinNT; I)
MIME-Version: 1.0
Subject: Re: Implicit conversion of NUMERIC and stored procedure
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Lines: 51
Message-ID: <356_3803012C.3AFD7BC2@peaktime.fr>
References: <356_37FB5094.773B4A20@peaktime.fr> <356_3801E2BF.1CD350A5@jpmorgan.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.database:11323
Article PK: 303732

Hi Steve,
unfortunately, the variable is already declared as Decimal {2} in the PB
script. And, by the way, this same script works perfectly with PB 5.0.4.

I hope you have an other idea :)

Thank you for trying to help me.

Steph.

Steve Katz [TeamSybase] wrote:

> Is the variable in your PB code typed as a Decimal or as
> Decimal{size}{precision}? If the former, try the latter.
>
> HTH,
>
> steve
> [TeamSybase]
>
> Stéphane Le Guével wrote:
> >
> > Hi,
> >
> > I'm running PB 6.5.1 under NT4 on the client side and Sybase Adaptive
> > Server 11.5 for NT on the server. When retrieving data in a crosstab
> > datawindow with a numeric retrieval argument and involving a stored
> > procedure, I sometimes receive the following error:
> > Select error: Scale error during implicit conversion of NUMERIC value
> > '<...>' to a NUMERIC field.
> >
> > When I say it 'sometimes' happens, I mean it always gives an error with
> > the same passed values, otherwise it works fine.
> > I tried the stored procedure alone in SQL Advantage with the 'buggy'
> > retrieval argument values and it worked fine, so it doesn't come from
> > the sp itself.
> > I built a simpler datawindow with a quick select and the same stored
> > procedure, and it behaved exactly as the crosstab one.
> >
> > For you to know, the retrieval argument is declared as a NUMBER in the
> > datawindow and the stored procedure expects a Numeric (10,2). If the
> > argument passed in the datawindow is, for instance, 1.5 it works fine,
> > but the value 2.2 gives each time:
> > Select error: Scale error during implicit conversion of NUMERIC value
> > '<2.200000000000000256>' to a NUMERIC field.
> > That's amazing!
> >
> > I saw, in the Sybase Technical Bulletin, a similar reviewed case under
> > the issue #: 198840 but there is no given solution.
> > Can anyone help me with this?
> >
> > Best regards,
> > Steph.


Steve Katz [TeamSybase] Posted on 1999-10-12 13:25:59.0Z
Newsgroups: sybase.public.powerbuilder.database
Date: Tue, 12 Oct 1999 09:25:59 -0400
From: "Steve Katz [TeamSybase]" <katz_s@jpmorgan.com>
Reply-To: katz_s@jpmorgan.com
Organization: Morgan Guaranty and Trust Company
X-Mailer: Mozilla 4.04 [en] (WinNT; U)
MIME-Version: 1.0
Subject: Re: Implicit conversion of NUMERIC and stored procedure
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Lines: 64
Message-ID: <356_380336E7.8094C603@jpmorgan.com>
References: <356_37FB5094.773B4A20@peaktime.fr> <356_3801E2BF.1CD350A5@jpmorgan.com> <356_3803012C.3AFD7BC2@peaktime.fr>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.database:11320
Article PK: 303729

I did some digging and found this to be an open issue (#41044373) in PB
6.5.1. I was able to duplicate the problem with PB 7.0.1. The issue
indicates that this should be fixed in PB7 so I will try to escalate
this. If you decide to call Sybase to report this, reference the issue
number above as well. Perhaps there is an EBF that addresses this
issue.

SICBMH,

steve
[TeamSybase]

Stéphane Le Guével wrote:
>
> Hi Steve,
> unfortunately, the variable is already declared as Decimal {2} in the PB
> script. And, by the way, this same script works perfectly with PB 5.0.4.
>
> I hope you have an other idea :)
>
> Thank you for trying to help me.
>
> Steph.
>
> Steve Katz [TeamSybase] wrote:
>
> > Is the variable in your PB code typed as a Decimal or as
> > Decimal{size}{precision}? If the former, try the latter.
> >
> > HTH,
> >
> > steve
> > [TeamSybase]
> >
> > Stéphane Le Guével wrote:
> > >
> > > Hi,
> > >
> > > I'm running PB 6.5.1 under NT4 on the client side and Sybase Adaptive
> > > Server 11.5 for NT on the server. When retrieving data in a crosstab
> > > datawindow with a numeric retrieval argument and involving a stored
> > > procedure, I sometimes receive the following error:
> > > Select error: Scale error during implicit conversion of NUMERIC value
> > > '<...>' to a NUMERIC field.
> > >
> > > When I say it 'sometimes' happens, I mean it always gives an error with
> > > the same passed values, otherwise it works fine.
> > > I tried the stored procedure alone in SQL Advantage with the 'buggy'
> > > retrieval argument values and it worked fine, so it doesn't come from
> > > the sp itself.
> > > I built a simpler datawindow with a quick select and the same stored
> > > procedure, and it behaved exactly as the crosstab one.
> > >
> > > For you to know, the retrieval argument is declared as a NUMBER in the
> > > datawindow and the stored procedure expects a Numeric (10,2). If the
> > > argument passed in the datawindow is, for instance, 1.5 it works fine,
> > > but the value 2.2 gives each time:
> > > Select error: Scale error during implicit conversion of NUMERIC value
> > > '<2.200000000000000256>' to a NUMERIC field.
> > > That's amazing!
> > >
> > > I saw, in the Sybase Technical Bulletin, a similar reviewed case under
> > > the issue #: 198840 but there is no given solution.
> > > Can anyone help me with this?
> > >
> > > Best regards,
> > > Steph.