沒有找到合適的產(chǎn)品?
聯(lián)系客服協(xié)助選型:023-68661681
提供3000多款全球軟件/控件產(chǎn)品
針對(duì)軟件研發(fā)的各個(gè)階段提供專業(yè)培訓(xùn)與技術(shù)咨詢
根據(jù)客戶需求提供定制化的軟件開發(fā)服務(wù)
全球知名設(shè)計(jì)軟件,顯著提升設(shè)計(jì)質(zhì)量
打造以經(jīng)營為中心,實(shí)現(xiàn)生產(chǎn)過程透明化管理
幫助企業(yè)合理產(chǎn)能分配,提高資源利用率
快速打造數(shù)字化生產(chǎn)線,實(shí)現(xiàn)全流程追溯
生產(chǎn)過程精準(zhǔn)追溯,滿足企業(yè)合規(guī)要求
以六西格瑪為理論基礎(chǔ),實(shí)現(xiàn)產(chǎn)品質(zhì)量全數(shù)字化管理
通過大屏電子看板,實(shí)現(xiàn)車間透明化管理
對(duì)設(shè)備進(jìn)行全生命周期管理,提高設(shè)備綜合利用率
實(shí)現(xiàn)設(shè)備數(shù)據(jù)的實(shí)時(shí)采集與監(jiān)控
打通數(shù)據(jù)孤島 實(shí)現(xiàn)生產(chǎn)過程全透明化
實(shí)現(xiàn)產(chǎn)品全生命周期的質(zhì)量管理與追溯
精準(zhǔn)制定生產(chǎn)計(jì)劃 合理配置生產(chǎn)資源
全面可視的生產(chǎn)質(zhì)量統(tǒng)計(jì)與追溯
一鍵生成排產(chǎn)計(jì)劃,有效提升資源利用率
打通生產(chǎn)過程數(shù)字化全鏈路,提高生產(chǎn)效率
幫助企業(yè)大幅降低因改裝質(zhì)量問題帶來的損失
打造數(shù)字化工廠,全面提升產(chǎn)品質(zhì)量
快速應(yīng)對(duì)訂單變化,大幅減少企業(yè)資源浪費(fèi)
實(shí)現(xiàn)產(chǎn)品報(bào)價(jià)快速精準(zhǔn),全面實(shí)現(xiàn)生產(chǎn)透明化
打造生產(chǎn)計(jì)劃自動(dòng)排產(chǎn)信息化平臺(tái)
FIBPlus是一款使用方便、用途廣泛的庫文件,可用于Delphi, C++ Builder, Kylix組件開發(fā)
標(biāo)簽:開發(fā)商: Devrace
當(dāng)前版本: 7.5
產(chǎn)品類型:控件
產(chǎn)品功能:數(shù)據(jù)庫管理工具
平臺(tái)語言:VCL|C++/ MFC|其他
開源水平:不提供源碼
本產(chǎn)品的分類與介紹僅供參考,具體以商家網(wǎng)站介紹為準(zhǔn),如有疑問請(qǐng)來電 023-68661681 咨詢。
New features and enhancements:
1. A new TpFIBScripter component has been added.
It has the following properties:
property Script:TStrings ; - stores a text of the script.
property Database: TpFIBDatabase; - stores the connection, where the script will be executed. You should not define this property if the script has the CREATE DATABASE command.
property Transaction: TpFIBTransaction ; - stores the transaction where the script will be executed. As the TpFIBScripter component can control transactions, you should not always define the Transaction: TpFIBTransaction property value.
property AutoDDL: boolean – defines whether to call Commit automatically after each DDL command when the script is being executed.
property Paused: Boolean – enables the developer to stop the script execution in TpFIBScripter event handlers.
property StopStatementNo – returns the number of the command where the user stopped the script execution.
TpFIBScripter methods:
Procedure Parse(Terminator: Char = ';') – parses the script, defined in the Script: TStrings property. The argument is the command separator (by default it is a semicolon “;”).
procedure ExecuteScript (FromStmt: integer = 1); - executes the script defined in the Script: TStrings property. The argument is the number of the command which starts the execution.
procedure ExecuteFromFile (const FileName: string;Terminator: Char = ';'); - executes the script stored in the external file FileName. The full script text is not loaded in memory, the file is read line by line before the complete command is formed. When the command is ready, it’s executed and it’s text is deleted from memory. This approach enables you to execute very huge scripts.
function GetStatement (StmtNo: integer; Text: TStrings): PStatementDesc – enables you to get information about the command by its number позволяет (you should call the Parse method before it). The function returns a pointer to the PStatementDesc structure, which stores information about the command.
TpFIBScripter events:
property BeforeStatementExecute: TOnStatementExecute;
property AfterStatementExecute: TOnStatementExecute;
where
TOnStatementExecute = procedure(Sender: TObject; Line: Integer; StatementNo: Integer; Desc: TStatementDesc; Statement: TStrings);
The events are called before/after the every command execution.
property OnExecuteError: TOnSQLScriptExecError;
where
TOnSQLScriptExecError = procedure(Sender: TObject; StatementNo: Integer; Line: Integer; Statement: TStrings; SQLCode: Integer; const Msg: string; var doRollBack: boolean; var Stop: Boolean) of object;
The event happens if the current command was executed with errors.
An example.
var scr: TpFIBScripter;
begin
scr := TpFIBScripter.Create(nil);
try
Scr.Script.Text := MyScriptText;
Scr.ExecuteScript;
finally
scr.Free;
end;
end;
2. Now TpFIBDataSet has new methods:
procedure DisableMasterSource;
procedure EnableMasterSource;
function MasterSourceDisabled:boolean;
They are used to activate/deactivate the master-detail mode temporarily. For example:
DetailDataSet.DisableMasterSource;
try
MasterDataSet.Edit;
MasterDataSet.FieldByName('ID').asInteger:=NewValue;
MasterDataSet.Post;
ChangeDetailDataSetLinkField(NewValue);
finally
DetailDataSet.EnableMasterSource;
end;
and the detail dataset won’t reopen.
3. TpFIBDataSet has a new AutoUpdateOptions.UseExecuteBlock: Boolean property. It works only if CachedUpdates = True. If UseExecuteBlock is equal to True, then calling of ApplyUpdates and ApplyUpdToBase will generate queries with EXECUTE BLOCK. In other words changes made in the CachedUpdates mode will be sent to the database not for each record separately but in packages of 255 records.
4. Now FIBPlus supports CsMonitor (implemented by Yury Plotnikov). To use it you should activate the directive "CSMonitor" in FIBPlus.inc (only for the full FIBPlus version).
5. TpFIBDatabase has a new method: procedure ClearQueryCacheList.
6. The TFIBDataTimeField and TFIBTimeField fields have the ShowMsec: Boolean property. If it is set to True, time values with milliseconds will be shown in visual DB components.
7. The Locate method works significantly faster. To use this feature you should deactivate the directive {$DEFINE FAST_LOCATE} in FIBPlus.inc (only for the full FIBPlus version).
8. If the data is sorted, the Lookup method uses sorting to search for necessary values in TpFIBDateset.
9. Now if you use Select from procedure in Firebird 2.1 and input parameters are boolean or GUID, fields with corresponding types are created in TpFIBdataSet.
Bugs fixed:
1. Now UTF8 fields correctly work with InterBase 2007.
2. The CancelUpdates logic of TpFIBDataSet has been changed. When you called the CancelUpdates method in the CachedUpdates mode, FIBPlus restored field values which remained just before canceling. For example, if you first edited the record and then deleted it, you got changed field values instead of the original ones after calling CancelUpdates.
3. Unicode lookup-fields work correctly now.
4. An error in the TpFIBDataSet.CloneRecord method appeared if there were deleted records. Fixed.
5. The current record was positioned in the wrong place if the Refresh method was called automatically after record deleting (if the poRefreshDeleted option was active). Fixed.
6. Now internal transaction parameters work correctly for Firebird 2.1.
7. Now TSIBfibEventAlerter correctly registers events. This component operated improperly when TSIBfibEventAlerter and TpFIBDatabase were placed on different forms.
8. Now the procedure TFIBLargeIntField.SetVarValue(const Value: Variant) method operates rightly. It worked incorrectly when it had an input NULL value.
新特性和改進(jìn):
1. 增加了新的 TpFIBScripter 組件。
它有下列屬性:
屬性 Script:TStrings ; ——存儲(chǔ)腳本的文本。
屬性 Database: TpFIBDatabase; ——存儲(chǔ)腳本執(zhí)行的連接。如果腳本有 CREATE DATABASE 命令,應(yīng)該定義該屬性。
屬性 Transaction: TpFIBTransaction ; ——存儲(chǔ)腳本執(zhí)行的事務(wù)。由于 TpFIBScripter 組件可以控制事務(wù),不應(yīng)該總是定義該 Transaction: TpFIBTransaction 屬性值。
屬性 AutoDDL: boolean ——定義是否當(dāng)腳本被執(zhí)行時(shí),在每個(gè) DLL 命令后自動(dòng)調(diào)用 Commit。
屬性 Paused: Boolean ——使開發(fā)者在 TpFIBScripter 事件句柄中停止腳本執(zhí)行。
屬性 StopStatementNo ——在用戶停止腳本執(zhí)行處返回命令數(shù)。
TpFIBScripter 方法:
過程 Parse(Terminator: Char = ';') ——解析腳本,該腳本在 Script: TStrings 屬性中定義。參數(shù)是命令分隔符(默認(rèn)為分號(hào)“;”)。
過程 ExecuteScript (FromStmt: integer = 1); ——執(zhí)行腳本,該腳本在 Script: TStrings 屬性中定義。參數(shù)是開始執(zhí)行的命令數(shù)。
過程 ExecuteFromFile (const FileName: string;Terminator: Char = ';'); ——執(zhí)行腳本,該腳本存儲(chǔ)在外部文件 FileName。完整腳本不載入內(nèi)存,在完整命令形成前,文件逐行讀出。當(dāng)命令準(zhǔn)備完畢,它被執(zhí)行,然后命令文本從內(nèi)存中被刪除。該方法使你可以運(yùn)行十分大的腳本。
函數(shù) GetStatement (StmtNo: integer; Text: TStrings): PStatementDesc ——使你通過它的數(shù)字 позволяет 獲得關(guān)于命令的信息(你應(yīng)該在其之前調(diào)用 Parse 方法)。該函數(shù)返回一個(gè)指向 PStatementDesc 結(jié)構(gòu)的指針,存儲(chǔ)關(guān)于命令的信息。
TpFIBScripter 事件:
屬性 BeforeStatementExecute: TOnStatementExecute;
屬性 AfterStatementExecute: TOnStatementExecute;
where
TOnStatementExecute = procedure(Sender: TObject; Line: Integer; StatementNo: Integer; Desc: TStatementDesc; Statement: TStrings);
這些事件在每個(gè)命令執(zhí)行前/后調(diào)用。
屬性 OnExecuteError: TOnSQLScriptExecError;
where
TOnSQLScriptExecError = procedure(Sender: TObject; StatementNo: Integer; Line: Integer; Statement: TStrings; SQLCode: Integer; const Msg: string; var doRollBack: boolean; var Stop: Boolean) of object;
如果當(dāng)前命令執(zhí)行帶有錯(cuò)誤,該事件產(chǎn)生。
一個(gè)例子。
var scr: TpFIBScripter;
begin
scr := TpFIBScripter.Create(nil);
try
Scr.Script.Text := MyScriptText;
Scr.ExecuteScript;
finally
scr.Free;
end;
end;
2. TpFIBDataSet 有新的方法:
過程 DisableMasterSource;
過程 EnableMasterSource;
函數(shù) MasterSourceDisabled:boolean;
它們被用來暫時(shí)激活/解除激活 master-detail 模式。例如:
DetailDataSet.DisableMasterSource;
try
MasterDataSet.Edit;
MasterDataSet.FieldByName('ID').asInteger:=NewValue;
MasterDataSet.Post;
ChangeDetailDataSetLinkField(NewValue);
finally
DetailDataSet.EnableMasterSource;
end;
細(xì)節(jié)數(shù)據(jù)集不會(huì)重復(fù)打開。
3. TpFIBDataSet 有新的 AutoUpdateOptions.UseExecuteBlock: Boolean 屬性。它僅當(dāng)CachedUpdates = True 時(shí)工作。如果 UseExecuteBlock 等于 True,調(diào)用 ApplyUpdates 和 ApplyUpdToBase 將會(huì)產(chǎn)生帶有 EXECUTE BLOCK 的查詢。也就是說,CachedUpdates 模式下做的改變將會(huì)發(fā)送到數(shù)據(jù)庫,不是單獨(dú)給每個(gè)記錄,而是給包含255個(gè)記錄的包。
4. FIBPlus 支持 CsMonitor (由Yury Plotnikov 實(shí)現(xiàn))。要使用它,應(yīng)當(dāng)激活 FIBPlus.inc 中的“CSMonitor”指示(僅適用于完整的 FIBPlus 版本)。
5. TpFIBDatabase 有新的方法:過程 ClearQueryCacheList。
6. TFIBDataTimeField 和 TFIBTimeField 域有 ShowMsec: Boolean 屬性。如果設(shè)置為 True,帶有毫秒的時(shí)間值將會(huì)在視覺 DB 組件中顯示。
7. Locate 方法運(yùn)行顯著加快。使用該特性,你應(yīng)該取消激活 FIBPlus.inc 中的指示 {$DEFINE FAST_LOCATE} (僅適用于完整的 FIBPlus 版本)。
8. 如果數(shù)據(jù)被存儲(chǔ),Lookup 方法使用排序在 TpFIBDateset 中尋找所需值。
9. 現(xiàn)在,如果你在 Firebird 2.1 中使用 Select from 過程,輸入布爾或 GUID 參數(shù),對(duì)應(yīng)類型的域?qū)⒃?/span> TpFIBdataSet 中創(chuàng)建。
錯(cuò)誤修正:
1. UTF8 域在 InterBase 2007 中正常運(yùn)行。
2. TpFIBDataSet 的 CancelUpdates 邏輯被改變。當(dāng)在 CachedUpdates 模式中調(diào)用 CancelUpdates 方法時(shí),FIBPlus 恢復(fù)取消前的域值。例如,如果你先編輯記錄之后刪除,你在調(diào)用 CancelUpdates 后獲得修改的值而不是原始值。
3. Unicode lookup-fields 正常工作。
4. 修正了 TpFIBDataSet.CloneRecord 方法中在有刪除的記錄時(shí)出現(xiàn)的錯(cuò)誤。
5. 如果在刪除記錄后(如果 poRefreshDeleted 選項(xiàng)被激活)Refresh 方法自動(dòng)調(diào)用,當(dāng)前記錄被放置在錯(cuò)誤位置 。已修正。
6. 內(nèi)部事務(wù)參數(shù)在 Firebird 2.1 正常工作。
7. TSIBfibEventAlerter 正確注冊(cè)事件。當(dāng) TSIBfibEventAlerter 和 TpFIBDatabase 被放置到不同表單時(shí),該組件曾不能正常運(yùn)行。
8. 過程 TFIBLargeIntField.SetVarValue(const Value: Variant) 方法正確運(yùn)行。當(dāng)有 NULL 值輸入時(shí),它曾不能正常工作。
更新時(shí)間:2013-12-11 13:10:05.000 | 錄入時(shí)間:2007-07-03 09:52:00.000 | 責(zé)任編輯:
dbForge Studio for SQL Server是用于SQL Server的終極管理工具。
軟件Navicat Premium 是一套數(shù)據(jù)庫管理工具,讓你使用一個(gè)程序即可同時(shí)連接到 MySQL、MariaDB、SQL Server、SQLite、Oracle 和 PostgreSQL 數(shù)據(jù)庫。
軟件一套專用于管理和開發(fā)MongoDB數(shù)據(jù)庫的開發(fā)工具。
軟件一套專用于可視化和優(yōu)化 Redis 數(shù)據(jù)的開發(fā)工具。
軟件跨平臺(tái)開源 Redis ? 管理工具
官方微信
官方微博
服務(wù)電話
重慶/ 023-68661681
華東/ 13452821722
華南/ 18100878085
華北/ 17382392642
客戶支持
技術(shù)支持咨詢服務(wù)
服務(wù)熱線:400-700-1020
郵箱:sales@evget.com
關(guān)注我們
地址 : 重慶市九龍坡區(qū)火炬大道69號(hào)6幢
慧都科技 版權(quán)所有 Copyright 2003- 2024 渝ICP備12000582號(hào)-13 渝公網(wǎng)安備 50010702500608號(hào)