Article View: borland.public.cppbuilder.database.ado
Article #1690Re: Change default field type from TBCDField to TFMTBCDField when using dynamic fields
From: Viatcheslav V. Vassiliev
Date: Wed, 07 Apr 2004 06:55
Date: Wed, 07 Apr 2004 06:55
27 lines
2121 bytes
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-mailReferences:
<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