请教【delphi】TField的类型FMTBCD与BCD有什么区别？

liangcq 2014-06-27 10:26:16

如题，ADODataSet添加静态字段后，数值型的字段，有的是TFMTBCDField类型，有的是TBCDField类型，他们有何区别？
TFMTBCDField的效率会比TBCDField低吗？
先谢了。

...全文

334 回复打赏收藏转发到动态举报

写回复

回复

切换为时间正序

请发表友善的回复…

发表回复

Delphi 如何判断数据库指针记录是否被改变，测试需要连接SQLSERVER数据库，例子面向Delphi初学者，学习数据库指针的相关操作。主要的代码如下：　　procedure TFrmState.FormShow(Sender: TObject); 　　begin 　　 ADODataSet1.Active := false; 　　 ADODataSet1.Active := true; 　　end; 　　procedure TFrmState.BtnCloseClick(Sender: TObject); 　　begin 　　 Close; 　　end; 　　procedure TFrmState.DataSource1DataChange(Sender: TObject; 　　 Field: TField); 　　begin 　　 if DataSource1.State = dsBrowse then 　　 ShowMessage('指针位置发生改变'); 　　end;

delphi 下的数据库连接工具，UniDAC 7.4.11 For Delphi 10.3 RIO 破解版，示例代码： uses uni, Data.DB, SQLiteUniProvider; var conn: TUniConnection; q: TUniQuery; sqlString: string; field: TField; begin conn := TUniConnection.Create(nil); try conn.ProviderName := 'SQLite'; conn.Database := 'foo.db'; conn.SpecificOptions.Values['SQLite.ClientLibrary'] := 'sqlite3.dll'; conn.SpecificOptions.Values['UseUnicode'] := 'True'; conn.SpecificOptions.Values['ASCIIDataBase'] := 'False'; //conn.SpecificOptions.Values['EncryptionKey'] := 'secret'; conn.Open; sqlString := 'SELECT * FROM bar'; q := TUniQuery.Create(nil); try q.Options.TrimVarChar := True; q.Connection := conn; q.SQL.Text := sqlString; q.Open; while not q.Eof do begin for field in q.Fields do begin Winapi.Windows.OutputDebugString(PWideChar(field.Name + ': ' + field.AsString)); end; q.Next; end; finally q.Close; q.Free; end; finally conn.Close; conn.Free; end; end;

Borland Delphi 2005 Architect Update 3----------Report #: Short Description: Rating: Status12241 IntToHex returns lowercase letters0.00 of 5 Closed11881 TStringStream constructor for .NET sets Position incorrectly0.00 of 5 Closed11787 Access violation using Code Insight when editing the uses clause0.00 of 5 Closed11759 TList instance leaked in DBCommon.pas when using IN operator in Filter expression5.00 of 5 Closed11651 New EllipsisPosition property causes text to be invisible & process to hang5.00 of 5 Closed11471 Cannot manage StarTeam association since applying Update20.00 of 5 Closed11353 (strict) protected nested class become public3.67 of 5 Closed11314 Too much inlining yields unstable compiled code.0.00 of 5 Closed11266 Inline causes compile error : F2084 Internal Error SCR765.00 of 5 Closed11193 Inlined function affects working of the enclosing for loop0.00 of 5 Closed11184 [Fatal Error] F2084 Internal Error: ILLK26340.00 of 5 Closed11069 Compact the TApplication.ProcessMessage code fragment for Unicode handling5.00 of 5 Closed10918 TColorBox control custom color selection causes AV0.00 of 5 Closed10873 Internal error: URW 793 when using constant struct with enums2.00 of 5 Closed10861 Access Violation when compiling code with default index property0.00 of 5 Closed10772 Designer improperly handles controls tagged with [ToolboxItem]0.00 of 5 Closed10669 TWideStrings has no GetEnumerator method0.00 of 5 Closed10661 Switching between form and source view cause long delay4.67 of 5 Closed10567 Ability to create all VCL packages0.00 of 5 Closed10498 D2005: DataSet lots of methods missing in code completion0.00 of 5 Closed10450 The Ellipse is drawn over some of the caption text when a form is docked in IDE0.00 of 5 Closed10381 Constant array of procedural types crashes compiler5.00 of 5 Closed10376 The Delphi 2k5 IDE UpTime & project loading is very SLOW4.00 of 5 Closed10314 Error Insight fails to flag an error4.00 of 5 Closed10248 Alignment Palette in VCL form designer malfunctions5.00 of 5 Closed10190 List view selected item no longer selected5.00 of 5 Closed10009 Double-click in the Search Results window0.00 of 5 Closed9912 Press Enter on Component crashes Delphi 20050.00 of 5 Closed9847 Transactional Object Wizard Missing0.00 of 5 Closed9712 The XML documentation feature doesn't associate comments with the correct symbols5.00 of 5 Closed9690 "Cannot focus a disabled or invisible window" in IDE0.00 of 5 Closed9666 Code Completion doesn't show all available items when using overload5.00 of 5 Closed9639 Active Form wizard not available in Delphi 2005 but mentioned in online help5.00 of 5 Closed9634 IDE response too SLOW4.63 of 5 Closed9578 TXPManifest + TFrame + TLabel + TRadioGroup = bad5.00 of 5 Closed9477 Delphi .NET assembly references with strong names5.00 of 5 Closed9254 Incorrect reference public key token included into Delphi8 strong-named assembly metadata4.00 of 5 Closed9021 Memory Leak in TreeView0.00 of 5 Closed8866 Assigning long string values (greater than 8192 characters) to TStringFields results in access violation.5.00 of 5 Closed8785 Filter or Ranges on Nested Dataset's should restrict master as well.0.00 of 5 Closed8417 TCustomSQLDataSet.GetFieldData implementation0.00 of 5 Closed8229 Error in code when database doesn't support schema/owner names5.00 of 5 Closed8032 Show modified code in the scrollbar0.00 of 5 Closed8021 TIndexDef.Assign Doesn't copy DescFiels and CaseInsFields5.00 of 5 Closed8001 SQLDataset doesn't call .Close on dbExpress driver cursor when closing5.00 of 5 Closed7912 TCustomClientdataset: properties "IndexDefs" and "IndexName" should be public0.00 of 5 Closed7872 double exception in method TDataSetProvider.InternalGetRecords5.00 of 5 Closed7809 SetOptionalParam don't work0.00 of 5 Closed7768 An Easy Feature Request: TDataset.CopyFields4.00 of 5 Closed7290 Grid's functionality enhancement5.00 of 5 Closed7199 Class Completion erroneously adds fields to a complete class if the getter functions starts with F5.00 of 5 Closed7082 Add SSE3 / PNI instructions to the BASM5.00 of 5 Closed7005 New control request - TDBStaticText - Add possibility to have Edge Borders0.00 of 5 Closed6985 Add node for unit name in Find in Files results in Message Window0.00 of 5 Closed6803 WebToolBar problem with buttons0.00 of 5 Closed6558 AV in DBGrid when destroying DataSet0.00 of 5 Closed6428 Labels disappear with XPManifest5.00 of 5 Closed6368 Resolving lookup- & calculated fields to datafields4.00 of 5 Closed6238 DBNavigator and DBGrid compliant with Federal Section 5080.00 of 5 Closed6021 Labels not visible in Windows XP0.00 of 5 Closed5951 Internal error: SY5764.44 of 5 Closed5812 TComboBox.Focused method does not always return good results.1.00 of 5 Closed5803 Unable to delete component if code editor minimized in saved desktop5.00 of 5 Closed5763 Cannot debug datamodule containing many objects0.00 of 5 Closed5699 Apache shared modules do not work with Apache 2.0.4x5.00 of 5 Closed5592 New event OnValidate that is fired before applying updates2.00 of 5 Closed5336 fatal error: Internal Error: L6812.33 of 5 Closed5283 Cannot read complete compiler error message.0.00 of 5 Closed5280 MessageDlg returns mrNone instead of mrCancel when aborted5.00 of 5 Closed5248 Assert fails to break and leaves FPU invalid op exception set.4.50 of 5 Closed4627 Cannot assign -2147483648 into INTEGER Variable4.00 of 5 Closed4624 A way to set both Width and Height of TBitmap (speed reason)4.85 of 5 Closed4581 Field description and Label3.00 of 5 Closed4444 IncMilliSeconds...IncHour with DateTime<0 wrong0.00 of 5 Closed4343 Proposal of modification of the TDataSet.Post method in DB.pas unit1.00 of 5 Closed4184 Delphi DLL using sharemem called from VC++ exe AV on exit3.25 of 5 Closed4172 tFrames and XPMan hiding controls5.00 of 5 Closed3850 TGraphicControl descendants invisible in frames with XP Manifest4.60 of 5 Closed3792 TryEncodeDateTime not correct for dates before Dec. 30, 18995.00 of 5 Closed3776 Add full IDL support0.00 of 5 Closed3718 Automatic Required setting of TField not consistent with SQL3.71 of 5 Closed3542 Strange limits in property CommandText2.40 of 5 Closed2881 DBGrid doesn't repaint when Enabled changed.5.00 of 5 Closed2625 Impossible to open a .TLB into the TLB Editor if missing uses reference3.50 of 5 Closed2608 Compiler crashes, dcc70.dll Read of address 000000004.00 of 5 Closed2572 Unable to sort on columns in module view3.00 of 5 Closed2382 TListView doesn't update correctly in OwnerData mode.4.00 of 5 Closed2276 'deprecated' warning appears when it shouldn't4.31 of 5 Closed2258 Failure to parse/compile integer constant --2147483648 and lower4.86 of 5 Closed2236 Delphi converts Text DFM's to binary with these steps4.71 of 5 Closed1685 Compiler error message refers to HIGH when it should be LOW3.43 of 5 Closed1455 GetRange method3.38 of 5 Closed1209 Context help does not work for TComboboxEx3.67 of 5 Closed1177 ResourceString limitation of 1024 characters3.89 of 5 Closed（出处：www.borland.com）

Delphi 7.1 Update Release Notes=======================================================This file contains important supplemental and late-breakinginformation that may not appear in the main productdocumentation, and supersedes information contained in otherdocuments, including previously installed release notes.Borland recommends that you read this file in its entirety.NOTE: If you are updating a localized version of Delphi 7, visit the Borland Registered User web site to obtain a localized readme file that may contain important late- breaking information not included in this readme file.IMPORTANT: Delphi must be closed before installing this update. =====================================================CONTENTS * INSTALLING THIS UPDATE * UPDATING LOCALIZED VERSIONS OF DELPHI 7 * KNOWN ISSUES * ISSUES ADDRESSED BY THIS UPDATE - IDE - CORE DATABASE - DATASNAP - DBGO (ADO COMPONENTS) - dbExpress - dbExpress COMPONENTS AND DB VCL - dbExpress CORE DRIVER AND METADATA - dbExpress VENDOR ISSUES - dbExpress CERTIFICATION - WEB SNAP - ACTIVEX - COMPILER - RTL - VCL - THIRD PARTY - BOLD FOR DELPHI * VERIFYING THAT THE UPDATE WAS SUCCESSFUL * FILES INSTALLED BY THIS UPDATE =======================================================INSTALLING THIS UPDATE* This update can not be applied to Delphi 7 Architect Trial version. * This update can not be removed after it is installed.* You will need the original Delphi 7 installation CD available to install this update.* To install this update from the CD, insert the CD, and launch the d7_ent_upd1.exe file appropriate for your locale.* To install this update from the Web, double-click the self-executing installation file and follow the prompts. * The Delphi 7 documentation PDF files are available on the update CD.========================================================UPDATING LOCALIZED VERSIONS OF DELPHI 7* This update can be applied only to the English version of Delphi 7. There are separate updates for the German, French and Japanese ver

2003.11.26 V0.6.7 + [多语言版] 新增多语言支持，现支持简体、繁体中文及英文。 # [IDE 扩展] 新增 Object Inspector 扩展专家，实现非默认值属性粗体显示功能（暂时只支持 D5/BCB5）。 + [MSDN 专家] 增加对 MSDN.NET 的支持及新增工具栏。 + [辅助功能] 增加专家引导工具，可以在启动 IDE 时按下左 Shift 键来启动该工具，用于临时禁用/启动专家。 * [辅助功能] 增加带帮助的窗体用 F1 调出帮助的功能。 * [删除注释专家] 增加处理项目源文件的选项。 * [工程扩展专家] 修正窗体列表及单元列表导致编辑器失去光标的问题，以及其它的改进。 * [属性编辑器] 修正字符串属性编辑器全部替换可能死循环的错误及部分功能改进。 * [IDE 扩展] 修正按 F12 显示窗体时焦点在浮动面板上的问题。 * [IDE 扩展] 修正浮动面板导致 IDE 中其它窗体 Stay On Top 无效的问题。 * [IDE 扩展] 修正 Close All 可能导致异常的问题。 * [IDE 扩展] 修正当浮动工具条显示时 IDE Edit 中大部分菜单不可使用问题。 * [IDE 扩展] 修正组件面板扩展导致面板不接受鼠标滚轮事件的错误。 * [代码编辑器专家] 修正多个 IDE 同时退出时提示保存冲突的问题。 * [代码编辑器专家] 修正加入过程头时，对 Class methods 处理错误的问题。 * [源代码统计专家] 修正清空统计结果不完全的小错误。 * [属性修改器] 修正由于删除已经修改的控件，引起双击定位到该控件时触发异常的错误。 * [窗体设计专家] 修正不可视组件排列有时不能过滤掉 TField 等不可见组件的问题。 * [辅助功能] 修正部分对话框不能用 ESC 关闭的问题。 * [其它] 修正其它一些已发现的错误及部分专家的功能改进。 ^ [开发计划] 另有资源管理专家、代码编辑器扩展、Explorer 专家、收藏夹专家、MMC 框架向导、DUnit 框架向导等正在开发中。

数据库相关

2,497

社区成员

88,445

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章