🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Change default field type from TBCDField to TFMTBCDField when using dynamic fields

#1690
From: Viatcheslav V. Vassiliev
Date: Wed, 07 Apr 2004 06:55
27 lines
2121 bytes
Set TADODataSet.EnableBCD to False and your field will be mapped to ftFloat.
For more options you may change ADOTypeToFieldType() procedure in ADODB
unit.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Yangkai Liu" <yangkai.liu@burkelee.com> �������/�������� � ��������
���������: news:40737e76$1@newsgroups.borland.com...
>
> Hi,
>
> I am writing console program which can access MS SQL server and I need
precision more than 4 digits after the decimal point.  The database field
type is decimal and there is no way for me to change that.  The dynamic
field generated has type TBCDField, which has only 4 digits precision after
the decimal point.  According to document, there is no way to change data
type for a dynamic field.  Is there any way to make the default data type to
be TFMTBCDField? Or is there any better soulution?
>
>
> YangKai Liu
Technical Details
Message-ID: <4073a5d4$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail
References: <40737e76$1@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,894c32b4470ce710
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2004-04-07 00:09:27 PST
From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <40737e76$1@newsgroups.borland.com>
Subject: Re: Change default field type from TBCDField to TFMTBCDField when using dynamic fields
Date: Wed, 7 Apr 2004 10:55:10 +0400
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 213.234.218.42
Message-ID: <4073a5d4$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1081320916 213.234.218.42 (6 Apr 2004 23:55:16 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail