请教怎样用 ODAC 联接 ORACLE 8.0.5 的问题 |
尚未結案
|
Dot.com
一般會員 發表:19 回覆:18 積分:7 註冊:2003-07-03 發送簡訊給我 |
|
conundrum
尊榮會員 發表:893 回覆:1272 積分:643 註冊:2004-01-06 發送簡訊給我 |
http://crlab.com/odac/history.html 08-Oct-03 New features in ODAC 4.50 - XMLTYPE datatype support added - WideString support added to work with Unicode character data - Transparent Application Failover support added TOraXML TOraXMLField TOraParam property AsXML: TOraXML; TBlob property IsUnicode: boolean; TOraSessionOptions property UseUnicode: boolean; TFailoverState TFailoverType TFailoverEvent TOraSession property OnFailover; TLobType TOraLob procedure CreateTemporary(LobType: TLobType); TOraTable procedure EmptyTable; 05-Jun-03 New features in ODAC 4.15 - Support for Oracle internal NUMBER datatype added. Allows to work with high precision numbers without accuracy losses. - new class TOraNumber - new class TOraNumberField - new class TDAParam 30-Jan-03 New features in ODAC 4.10 - Support for Oracle 9i NOT FINAL objects added - TIMESTAMP and INTERVAL support for Oracle objects added - TOraSmartQuery.OptionsDS.QuoteNames 25-Dec-02 New features in ODAC 4.05 - Transaction control schema changed. Now TOraSession.InTransaction shows actual user transaction state on server (implicit commit and rollback are considered). - DBMonitor client implementation moved to COM server. Now ODAC is incompatible with DBMonitor 2.02 or lower. - LOB attributes support for object fields added - Temporary LOBs support added - Constants ftTimeStampTZ and ftTimeStampLTZ added. Used in TOraTimeStampField. - UROWID support for index organized tables added - Option ConvertEOL added - TOraDataSet.BeforeFetch - TOraDataSet.AfterFetch - TOraTimeStampField.Format - TOraIntervalField.LeadPrecision - TOraIntervalField.FracPrecision - TOraRef.AsHex - TCustomDADataset.FetchingAll - TOraSessionOption.ConvertEOL 30-Sep-02 New features in ODAC 4.00 - Delphi 7 support - Kylix 3 for C support - Oracle 9 scrollable cursors support - New memory management model for ftString and ftVarBytes types. Allows significantly decrease memory usage on large tables fetch. Controlled by FlatBuffers dataset option. - RAW datatype support (as ftVarBytes) - Support for complex fields (blobs, objects etc.) in CachedUpdates mode - New 'Prepare' schema 30-Aug-02 New features in ODAC 3.90 - Kylix 3 support 09-Aug-02 New features in ODAC 3.85 - DBMonitor support - New version of OraTools support 18-Jul-02 New features in ODAC 3.80 - Oracle9 timestamp and interval datatypes support - Performance optimization for queries with many fields, especially for TSmartQuery and TOraTable - Runtime packages division for Delphi6, C Builder6, Kylix, Kylix2, see manual - TOraSession.InLocalTransaction - TOraSession.InternalName - TOraAlerter.PurgePipe - Auto generation RETURNING clause for LOBs added to design-time component editor 21-Mar-02 New features in ODAC 3.60 - supports C Builder 6 14-Dec-01 New features in ODAC 3.50 - supports Kylix 2 - multibytes charsets support - direct lob access support - using OraTools Add-in TOraSession property Options.CharLength: TCharLength; TOraDataSet property OptionsDS.CacheLobs: Boolean; TOraLob property Cached: Boolean; 12-Oct-01 New features in ODAC 3.30 - supports Oracle 9i - Net edition for Kylix TOraSession property ConnectMode: TConnectMode; property Options.DateFormat: String; property Options.DateLanguage: String; TOraDataSet property OptionsDS.FieldsAsString: Boolean; property OptionsDS.DeferredLobRead: Boolean; TOraDataSet property SequenceMode: TSequenceMode; 08-Aug-01 New features in ODAC 3.20 - supports Delphi 6 - new version of OraDesigner - OraExplorer - printed documentation - BDE Migration Wizard 20-Feb-01 New features in ODAC 3.00 - using standard TParam object - separate run- and design-time packages - get original name of fields - retrieve field's default value - support Net option - Kylix ready TOraSession property Options.Charset: String; property Options.Net: Boolean; TOraDataSet property OptionsDS.FieldsOrigin: Boolean; property OptionsDS.DefaultValues: Boolean; TOraTable property MasterFields: String; property DetailFields: String; TOraObject AttrAsLob[Name: string]: TOraLob; TOraParam TOraParams 11-Jul-00 New features in ODAC 2.50 - support multiple Oracle Homes - support Borland's SQL Monitor - TOraSQLMonitor component - default session - customizable connect dialog TOraSession property Home: TOracleHome; property LDA: PLDA; property OnError: TOraErrorEvent; procedure AssignConnect(Source: TOraSession); TMemDataSet procedure DeferredPost; procedure RestoreUpdates; procedure RevertRecord; TOraDataset function GetFieldPrecision(const FieldName: String): Integer; function GetFieldScale(const FieldName: String): Integer; TOraTable property MasterSource: TDataSource; TConnectDialog property DialogClass: String; property ReadAliases: Boolean; procedure GetServerList(List:TStrings); 30-Mar-00 New features in ODAC 2.20 - support C Builder 5 - macros in update SQL TOraSession property Options; TOraDataSet property Options; doAutoClose doQueryRecCount function Fetched: Boolean; TOraStoredProc property Overload: Integer; TBlob property AsString: String; procedure Assign(Source: TBlob); 10-Jan-00 New features in ODAC 2.10 - customized TSmartQuery data updating - supports DML array operations - macros in TOraSQL and TOraScript - TOraLoader component - supports Oracle 8 Lite - easy installation TOraSession property ConnectString: String; property OCICallStyle: TOCIVersion; property OCISvcCtx: pOCISvcCtx; property Options: TOraSessionOptions; TMemDataSet function LocateEx(const KeyFields: String; const KeyValues: Variant; Options: TLocateExOptions): Boolean; TOraDataSet procedure CreateProcCall(Name: String; Overload: Integer = 0); procedure GetErrorPos(var Row,Col: Integer); function ErrorOffset: Integer; function Executing: Boolean; function Fetching: Boolean; property BaseSQL: String; property FinalSQL: String; property Options: TOraDataSetOptions default [doRequiredFields, doStrictUpdate, doLongString, doNumberRange]; property RefreshOptions: TRefreshOptions default []; // obsolete property RefreshMode: TRefreshMode; property StrictUpdate: Boolean; property LocalConstraints: Boolean; TOraQuery procedure ExecSQL; TSmartQuery property SQLInsert: TSrings; property SQLDelete: TSrings; property SQLUpdate: TSrings; property SQLLock: TSrings; property SQLRefresh: TSrings; TOraStoredProc procedure ExecProc; TOraSQL procedure Prepare; procedure UnPrepare; function Executing: Boolean; procedure WaitExecuting; property ArrayLength: Integer; property Prepared: Boolean; TOraScript function FindMacro(Name: String): TMacro; function MacroByName(Name: String): TMacro; property Macros: TMacros; property BeforeExecute: TBeforeExecuteEvent; 14-Oct-99 New features in ODAC 2.00 - supports Oracle8 Objects - supports Oracle8 REFs - supports Oracle8 Arrays - supports Oracle8 Nested tables - supports Oracle8 BFiles - using RETURNING with Oracle8 - smart refreshing - TOraNestedTable component - TOraScript component - TOraAlerter component - TBFileField component - TOraFile class - TOraLob class - TOraType class - TOraObject class - TOraRef class - TOraArray class - TOraNestTable class TOraSession property ConnectPrompt: Boolean; TOraDataSet function Executing: Boolean; function Fetching: Boolean; function ErrorOffset: Integer; function GetFile(const FieldName: String): TOraFile; function GetObject(const FieldName: String): TOraObject; function GetRef(const FieldName: String): TOraRef; function GetArray(const FieldName: String): TOraArray; function GetTable(const FieldName: String): TOraNestTable; property RefreshMode: TRefreshMode; TSmartQuery property DMLRefresh: Boolean; property SmartRefresh: Boolean; TOraSQL function Executing: Boolean; procedure WaitExecuting; function ErrorOffset: Integer; property ParamValues[const ParamName: String]: Variant TOraCursor function CanFetch: Boolean; TParam property AsBFile: TOraFile; property AsObject: TOraObject; property AsRef: TOraRef; property AsArray: TOraArray; property AsTable: TOraTable; TMacro property AsDateTime: TDateTime; property AsFloat: Double; property AsInteger: Integer; property AsString: String; function AddWhere(SQL: String; Condition: String): String; function SetOrderBy(SQL: String; Fields: String): String; function GetOrderBy(SQL: String): String; 26-May-99 New features in ODAC 1.85 - TOraProvider component - TBDESession component - Support Oracle 8i - C Builder 4 package TOraDataSet procedure Unlock; procedure RefreshRecord; property Filter: String; property FilterSQL: String; property StrictUpdate: Boolean; property OnUpdateError: TUpdateErrorEvent; property OnUpdateRecord: TUpdateRecordEvent; property OnFilterRecord: TFilterRecordEvent; TOraQuery property SQLRefresh: TStrings; TSmartQuery property FullRefresh: Boolean; property KeySequence: String; TConnectDialog property SavePasword: Boolean; TMacro property Active: Boolean; 12-Mar-99 New features in ODAC 1.75 - TOraTable component - TStoredProc component TOraDataSet procedure Break; property AfterExecute:TAfterExecuteEvent TVirtualTable function AddField(Name: String; FieldType: TFieldType; Size: Word): TField; 01-Mar-99 New features in ODAC 1.70 - Supports BLOB and CLOB data types Oracle 8 - Supports nested tables - TVirtualTable component - Embeded SQL Designer with PL/SQL debugger - C Builder version TOraSession function ExecSQL(Text: String; Params: array of Variant): Variant; function ExecProc(Name: String; Params: array of Variant): Variant; function ExecSQLEx(Text: String; Params: array of Variant): Variant; function ExecProcEx(Name: String; Params: array of Variant): Variant; property OraSQL:TOraSQL; property OracleVersion: String; property OnConnectChange: TOnConnectChangeEvent; TOraDataSet property IsQuery: Boolean; property IsPLSQL: Boolean; property LocalConstraints: Boolean; property ParamCount: Word; property ReturnParams: Boolean; procedure Execute; function FindParam(Name: String): TParam; function GetDataType(const FieldName: String): Integer; function GetBlobRef(const FieldName: String): TBlob; function GetLobLocator(const FieldName: String): TLobLocator; TOraQuery property ReturnParams: Boolean; TSmartQuery property KeyFields: String; TOraSQL property ParamCount: Word; function FindParam(Name:string):TParam; 22-Oct-98 New features in ODAC 1.50 - Supports native interface Oracle 8.0 - Supports PL/SQL tables - TOraErrorHandler TOraDataSet procedure Prepare; procedure UnPrepare; property AutoCommit; property Prepared; TOraSQL procedure CreateProcCall(Name: String); property AutoCommit; 17-May-98 New features in ODAC 1.20 TOraSession property Username; property Server; TOraDataSet procedure Execute; function MacroByName(Name: String): TMacro; procedure ApplyUpdates; procedure CommitUpdates; procedure CancelUpdates; function UpdateStatus: TUpdateStatus; property RowsProcessed; property UniDirectional; property Macros; property CachedUpdates; property UpdatesPending; TOraQuery procedure Lock; property SQLLock: TStrings; TOraSQL property RowsProcessed; 05-Feb-98 First release of ODAC 1.00 |
本站聲明 |
1. 本論壇為無營利行為之開放平台,所有文章都是由網友自行張貼,如牽涉到法律糾紛一切與本站無關。 2. 假如網友發表之內容涉及侵權,而損及您的利益,請立即通知版主刪除。 3. 請勿批評中華民國元首及政府或批評各政黨,是藍是綠本站無權干涉,但這裡不是政治性論壇! |