Problems withftBCD type

Article View: borland.public.cppbuilder.database.ado

Article #908

Back to borland.public.cppbuilder.database.ado Previous Next

#908

From: Lionel
Date: Tue, 01 Mar 2005 08:54

17 lines
1257 bytes

Hi to all, I want to use this SP on a SQLServer (2000):

CREATE Procedure DICH_ANOM_ScanMlp
@JOB_ID		int,
@SCAN_TIME	numeric(17)	OUTPUT,
@PROD_PTYPE	varchar(3)	OUTPUT,
@ACC_TIMESTAMP	numeric(17)	OUTPUT,
@Error		int		OUTPUT,	
@Error_Descr	varchar(200)	OUTPUT

I'm using a TADOCommand in which the numeric parameters are
treated as ftBCD fields.
Calling this SP the program gives me this error:
"...EOleException with message 'Error converting data type
numeric to money'. Any advice??
TIA.

Technical Details

Message-ID: <42242dd8$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,7c0218fbfa6a3ad6,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Lionel" <nomail@all.fr>
Sender: "Lionel" <nomail@all.fr>
Reply-To: "Lionel" <nomail@all.fr>
Subject: Problems withftBCD type
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 213.156.53.163     
X-Forwarded-For: unknown
NNTP-Posting-Host: 207.105.83.66
Message-ID: <42242dd8$1@newsgroups.borland.com>
Date: 1 Mar 2005 00:54:48 -0800
X-Trace: newsgroups.borland.com 1109667288 207.105.83.66 (1 Mar 2005 00:54:48 -0800)
Lines: 17
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail