ViewVC Help

View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing

root/public/ibx/branches/journaling/fbintf/IB.pas

Comparing:
ibx/trunk/fbintf/IB.pas (file contents), Revision 309 by tony, Tue Jul 21 08:00:42 2020 UTC vs.
ibx/branches/journaling/fbintf/IB.pas (file contents), Revision 362 by tony, Tue Dec 7 13:27:39 2021 UTC

#	Line 129 | Line 129 | uses
129		Classes,
130		{$IFDEF WINDOWS}Windows, {$ENDIF}
131		{$IFDEF FPC} Dynlibs, {$ENDIF}
132	<	SysUtils, DB, FBMessages, IBExternals;
132	>	SysUtils, DB, FBMessages, IBExternals, FmtBcd;
133
134		const
135		{Interface version information}
136		FBIntf_Major = 1;
137	<	FBIntf_Minor = 1;
138	<	FBIntf_Release = 6;
139	<	FBIntf_Version = '1.1.6';
137	>	FBIntf_Minor = 3;
138	>	FBIntf_Release = 3;
139	>	FBIntf_Version = '1.3.3';
140	>
141	>	const
142	>	{DPB, TPB and SPB Parameter Block Name Prefixes}
143	>	DPBPrefix = 'isc_dpb_';
144	>	TPBPrefix = 'isc_tpb_';
145	>
146	>	const
147	>	{Time Zone ID constraint}
148	>	MaxOffsetTimeZoneID = 2879; {lower values represent a time zone offset between
149	>	-23:59 and 23:59. Higher values are keys to the
150	>	Time Zone database.}
151	>
152	>	TimeZoneID_GMT = 23*minsPerHour + 59;
153	>	decimillisecondsPerSecond = 10000;
154	>	TimeZoneDisplacementDelta = 60*23 + 59; {23:59 in minutes}
155
156		{These include files are converted from the 'C' originals in the Firebird API
157		and define the various constants used by the API}
158
159		{$I 'include/consts_pub.inc'}
160	+	{$I 'include/dyn_consts.inc'}
161		{$I 'include/inf_pub.inc'}
162		{$I 'include/configkeys.inc'}
163	+	{$I 'include/blr.inc'}
164
165		{The following constants define the values return by calls to the GetSQLType
166		methods provided by several of the interfaces defined below.}
#	Line 165 | Line 182 | const
182		SQL_TYPE_TIME                  =        560;
183		SQL_TYPE_DATE                  =        570;
184		SQL_INT64                      =        580;
185	+	SQL_TIMESTAMP_TZ_EX            =        32748;
186	+	SQL_TIME_TZ_EX                 =        32750;
187	+	SQL_INT128                     =        32752;
188		SQL_BOOLEAN                    =        32764;
189	+	SQL_TIMESTAMP_TZ               =        32754;
190	+	SQL_TIME_TZ                    =        32756;
191	+	SQL_DEC_FIXED                  =        32758;    {FB4 Beta 1 only}
192	+	SQL_DEC16                      =        32760;
193	+	SQL_DEC34                      =        32762;
194	+	SQL_NULL                       =        32766;
195		SQL_DATE                       =        SQL_TIMESTAMP;
196
197		type
#	Line 215 | Line 241 | type
241
242		TFBStatusCode = cardinal;
243		TByteArray = array of byte;
244	+	TFBTimeZoneID = ISC_USHORT;
245
246		IFirebirdAPI = interface;
247		IAttachment = interface;
#	Line 234 | Line 261 | type
261		property Items[index: integer]: _IItem read getItems; default;
262		end;
263
264	+	IParameterBlockWithTypeNames<_IItem> = interface(IParameterBlock<_IItem>)
265	+	function AddByTypeName(ParamTypeName: AnsiString): _IItem;
266	+	function GetDPBParamTypeName(ParamType: byte): Ansistring; deprecated 'Use Get ParamTypeName';
267	+	function GetParamTypeName(ParamType: byte): Ansistring;
268	+	end;
269	+
270		{IParameterBlockItem is not used on its own but instead provides a base type for
271		different parameter block items }
272
#	Line 251 | Line 284 | type
284		property AsInteger: integer read getAsInteger write SetAsInteger;
285		end;
286
287	+	IParameterBlockItemWithTypeName = interface(IParameterBlockItem)
288	+	function getParamTypeName: AnsiString;
289	+	end;
290
291		{The IStatus interface provides access to error information, if any, returned
292		by the last API call. It can also be used to customise the error message
#	Line 265 | Line 301 | type
301
302		TIBDataBaseErrorMessages   = set of TIBDataBaseErrorMessage;
303
304	+	TStatusCode = long;
305	+
306		IStatus = interface
307		['{34167722-af38-4831-b08a-93162d58ede3}']
308	<	function GetIBErrorCode: Long;
309	<	function Getsqlcode: Long;
308	>	function GetIBErrorCode: TStatusCode;
309	>	function Getsqlcode: TStatusCode;
310		function GetMessage: AnsiString;
311		function CheckStatusVector(ErrorCodes: array of TFBStatusCode): Boolean;
312		function GetIBDataBaseErrorMessages: TIBDataBaseErrorMessages;
#	Line 330 | Line 368 | type
368		function GetAsBoolean(index: array of integer): boolean;
369		function GetAsCurrency(index: array of integer): Currency;
370		function GetAsInt64(index: array of integer): Int64;
371	<	function GetAsDateTime(index: array of integer): TDateTime;
371	>	function GetAsDateTime(index: array of integer): TDateTime; overload;
372	>	procedure GetAsDateTime(index: array of integer; var aDateTime: TDateTime; var dstOffset: smallint; var aTimezoneID: TFBTimeZoneID); overload;
373	>	procedure GetAsDateTime(index: array of integer; var aDateTime: TDateTime; var dstOffset: smallint; var aTimezone: AnsiString); overload;
374	>	procedure GetAsTime(index: array of integer; var aTime: TDateTime; var dstOffset: smallint; var aTimezoneID: TFBTimeZoneID; OnDate: TDateTime); overload;
375	>	procedure GetAsTime(index: array of integer; var aTime: TDateTime; var dstOffset: smallint; var aTimezone: AnsiString; OnDate: TDateTime); overload;
376	>	function GetAsUTCDateTime(index: array of integer): TDateTime;
377		function GetAsDouble(index: array of integer): Double;
378		function GetAsFloat(index: array of integer): Float;
379		function GetAsLong(index: array of integer): Long;
380		function GetAsShort(index: array of integer): Short;
381		function GetAsString(index: array of integer): AnsiString;
382		function GetAsVariant(index: array of integer): Variant;
383	+	function GetAsBCD(index: array of integer): tBCD;
384		procedure SetAsInteger(index: array of integer; AValue: integer);
385		procedure SetAsBoolean(index: array of integer; AValue: boolean);
386		procedure SetAsCurrency(index: array of integer; Value: Currency);
387		procedure SetAsInt64(index: array of integer; Value: Int64);
388		procedure SetAsDate(index: array of integer; Value: TDateTime);
389	+	procedure SetAsDateTime(index: array of integer; Value: TDateTime); overload;
390	+	procedure SetAsDateTime(index: array of integer; aValue: TDateTime; aTimeZoneID: TFBTimeZoneID); overload;
391	+	procedure SetAsDateTime(index: array of integer; aValue: TDateTime; aTimeZone: AnsiString); overload;
392	+	procedure SetAsTime(index: array of integer; Value: TDateTime); overload;
393	+	procedure SetAsTime(index: array of integer; aValue: TDateTime; OnDate: TDateTime; aTimeZoneID: TFBTimeZoneID); overload;
394	+	procedure SetAsTime(index: array of integer; aValue: TDateTime; OnDate: TDateTime; aTimeZone: AnsiString); overload;
395	+	procedure SetAsUTCDateTime(index: array of integer; aUTCTime: TDateTime);
396		procedure SetAsLong(index: array of integer; Value: Long);
346	–	procedure SetAsTime(index: array of integer; Value: TDateTime);
347	–	procedure SetAsDateTime(index: array of integer; Value: TDateTime);
397		procedure SetAsDouble(index: array of integer; Value: Double);
398		procedure SetAsFloat(index: array of integer; Value: Float);
399		procedure SetAsShort(index: array of integer; Value: Short);
400		procedure SetAsString(index: array of integer; Value: AnsiString);
401		procedure SetAsVariant(index: array of integer; Value: Variant);
402	+	procedure SetAsBcd(index: array of integer; aValue: tBCD);
403		procedure SetBounds(dim, UpperBound, LowerBound: integer);
404		function GetAttachment: IAttachment;
405		function GetTransaction: ITransaction;
#	Line 422 | Line 472 | type
472
473		TIBDateTimeFormats = (dfTimestamp, {SQL TIMESTAMP}
474		dfDateTime,   {SQL DATETIME}
475	<	dfTime);      {SQL TIME}
475	>	dfTime,      {SQL TIME}
476	>	dfTimestampTZ, {SQL_TIMESTAMP_TZ}
477	>	dfTimeTZ);       {SQLTIME_TZ
478
479		{ IColumnMetaData }
480
#	Line 440 | Line 492 | type
492		function getScale: integer;
493		function getCharSetID: cardinal;
494		function getCodePage: TSystemCodePage;
495	+	function GetCharSetWidth: integer;
496		function getIsNullable: boolean;
497		function GetSize: cardinal;
498		function GetArrayMetaData: IArrayMetaData; {Valid only for Array SQL Type}
#	Line 492 | Line 545 | type
545		function GetAsBoolean: boolean;
546		function GetAsCurrency: Currency;
547		function GetAsInt64: Int64;
548	<	function GetAsDateTime: TDateTime;
548	>	function GetAsDateTime: TDateTime; overload;
549	>	procedure GetAsDateTime(var aDateTime: TDateTime; var dstOffset: smallint; var aTimezoneID: TFBTimeZoneID); overload;
550	>	procedure GetAsDateTime(var aDateTime: TDateTime; var dstOffset: smallint; var aTimezone: AnsiString); overload;
551	>	procedure GetAsTime(var aTime: TDateTime; var dstOffset: smallint; var aTimezoneID: TFBTimeZoneID; OnDate: TDateTime); overload;
552	>	procedure GetAsTime(var aTime: TDateTime; var dstOffset: smallint; var aTimezone: AnsiString; OnDate: TDateTime); overload;
553	>	procedure GetAsTime(var aTime: TDateTime; var dstOffset: smallint; var aTimezoneID: TFBTimeZoneID); overload;
554	>	procedure GetAsTime(var aTime: TDateTime; var dstOffset: smallint; var aTimezone: AnsiString); overload;
555	>	function GetAsUTCDateTime: TDateTime;
556		function GetAsDouble: Double;
557		function GetAsFloat: Float;
558		function GetAsLong: Long;
#	Line 505 | Line 565 | type
565		function GetAsBlob: IBlob; overload;
566		function GetAsBlob(BPB: IBPB): IBlob; overload;
567		function GetAsArray: IArray;
568	+	function GetAsBCD: tBCD;
569		property AsDate: TDateTime read GetAsDateTime;
570		property AsBoolean:boolean read GetAsBoolean;
571		property AsTime: TDateTime read GetAsDateTime;
#	Line 522 | Line 583 | type
583		property AsVariant: Variant read GetAsVariant ;
584		property AsBlob: IBlob read GetAsBlob;
585		property AsArray: IArray read GetAsArray;
586	+	property AsBCD: tBCD read GetAsBCD;
587		property IsNull: Boolean read GetIsNull;
588		property Value: Variant read GetAsVariant;
589		end;
#	Line 552 | Line 614 | type
614		}
615		IResultSet = interface(IResults)
616		['{0ae4979b-7857-4e8c-8918-ec6f155b51a0}']
617	<	function FetchNext: boolean;
617	>	function FetchNext: boolean; {fetch next record}
618	>	function FetchPrior: boolean; {fetch previous record}
619	>	function FetchFirst:boolean; {fetch first record}
620	>	function FetchLast: boolean; {fetch last record}
621	>	function FetchAbsolute(position: Integer): boolean; {fetch record by its absolute position in result set}
622	>	function FetchRelative(offset: Integer): boolean; {fetch record by position relative to current}
623		function GetCursorName: AnsiString;
624	+	function IsBof: boolean;
625		function IsEof: boolean;
626		procedure Close;
627		end;
628
629		{The ISQLParam interface is used to provide access to each parameter in a
630	<	parametised SQL Statement. It subclasses IColumnMetaData and this part of
563	<	the interface may be used to access information on the expected SQL Type, etc.
564	<
565	<	It also subclasses ISQLData and this part of the interface may be used to access
566	<	current values for each parameter.
567	<
568	<	Otherwise, the interface comprises the Setter Methods and properties used to
630	>	parametised SQL Statement. The interface comprises the Setter Methods and properties used to
631		set the value of each parameter.
632
633		Automatic conversion is provided to and from strings. That is GetAsString and
634		SetAsString are safe to use for sql types other than boolean - provided automatic
635		conversion is possible.
636	+
637	+	ISQLParam is subclassed from the IParamMetaData interface. This interface provides
638	+	access to the parameter metadata. This metadata is mutable and can change after
639	+	a parameter is set to a given value. This is acceptable as long as the parameter
640	+	metadata is type compatible with the underlying column metadata and hence the
641	+	parameter value can be converted by Firebird into a value acceptable by the
642	+	underlying column. The column metadata, which is unmutable, can be obtained
643	+	by the ISQLParam.getColMetadata interface. When a statement is prepared, the
644	+	parameter metadata is always initialised to the column metadata.
645		}
646
647	<	ISQLParam = interface
648	<	['{b22b4578-6d41-4807-a9a9-d2ec8d1d5a14}']
578	<	function GetIndex: integer;
647	>	IParamMetaData = interface
648	>	['{4e148c4e-2d48-4991-a263-f66eca05c6aa}']
649		function GetSQLType: cardinal;
650		function GetSQLTypeName: AnsiString;
651		function getSubtype: integer;
582	–	function getName: AnsiString;
652		function getScale: integer;
653		function getCharSetID: cardinal;
654		function getCodePage: TSystemCodePage;
655		function getIsNullable: boolean;
656		function GetSize: cardinal;
657	+	property SQLType: cardinal read GetSQLType;
658	+	end;
659	+
660	+	ISQLParam = interface(IParamMetaData)
661	+	['{b22b4578-6d41-4807-a9a9-d2ec8d1d5a14}']
662	+	function getColMetadata: IParamMetaData;
663	+	function GetIndex: integer;
664	+	function getName: AnsiString;
665		function GetAsBoolean: boolean;
666		function GetAsCurrency: Currency;
667		function GetAsInt64: Int64;
668	<	function GetAsDateTime: TDateTime;
668	>	function GetAsDateTime: TDateTime; overload;
669	>	procedure GetAsDateTime(var aDateTime: TDateTime; var dstOffset: smallint; var aTimezoneID: TFBTimeZoneID); overload;
670	>	procedure GetAsDateTime(var aDateTime: TDateTime; var dstOffset: smallint; var aTimezone: AnsiString); overload;
671	>	procedure GetAsTime(var aTime: TDateTime; var dstOffset: smallint; var aTimezoneID: TFBTimeZoneID; OnDate: TDateTime); overload;
672	>	procedure GetAsTime(var aTime: TDateTime; var dstOffset: smallint; var aTimezone: AnsiString; OnDate: TDateTime); overload;
673	>	procedure GetAsTime(var aTime: TDateTime; var dstOffset: smallint; var aTimezoneID: TFBTimeZoneID); overload;
674	>	procedure GetAsTime(var aTime: TDateTime; var dstOffset: smallint; var aTimezone: AnsiString); overload;
675	>	function GetAsUTCDateTime: TDateTime;
676		function GetAsDouble: Double;
677		function GetAsFloat: Float;
678		function GetAsLong: Long;
#	Line 600 | Line 684 | type
684		function GetAsVariant: Variant;
685		function GetAsBlob: IBlob;
686		function GetAsArray: IArray;
687	+	function GetAsBCD: tBCD;
688	+	function GetStatement: IStatement;
689	+	function GetTransaction: ITransaction;
690		procedure Clear;
691		function GetModified: boolean;
692		procedure SetAsBoolean(AValue: boolean);
#	Line 607 | Line 694 | type
694		procedure SetAsInt64(aValue: Int64);
695		procedure SetAsDate(aValue: TDateTime);
696		procedure SetAsLong(aValue: Long);
697	<	procedure SetAsTime(aValue: TDateTime);
698	<	procedure SetAsDateTime(aValue: TDateTime);
697	>	procedure SetAsTime(aValue: TDateTime); overload;
698	>	procedure SetAsTime(aValue: TDateTime; OnDate: TDateTime; aTimeZoneID: TFBTimeZoneID); overload;
699	>	procedure SetAsTime(aValue: TDateTime; OnDate: TDateTime; aTimeZone: AnsiString); overload;
700	>	procedure SetAsTime(aValue: TDateTime; aTimeZoneID: TFBTimeZoneID); overload;
701	>	procedure SetAsTime(aValue: TDateTime; aTimeZone: AnsiString); overload;
702	>	procedure SetAsDateTime(aValue: TDateTime); overload;
703	>	procedure SetAsDateTime(aValue: TDateTime; aTimeZoneID: TFBTimeZoneID); overload;
704	>	procedure SetAsDateTime(aValue: TDateTime; aTimeZone: AnsiString); overload;
705	>	procedure SetAsUTCDateTime(aUTCTime: TDateTime);
706		procedure SetAsDouble(aValue: Double);
707		procedure SetAsFloat(aValue: Float);
708		procedure SetAsPointer(aValue: Pointer);
#	Line 620 | Line 714 | type
714		procedure SetAsArray(anArray: IArray);
715		procedure SetAsQuad(aValue: TISC_QUAD);
716		procedure SetCharSetID(aValue: cardinal);
717	+	procedure SetAsBcd(aValue: tBCD);
718		property AsDate: TDateTime read GetAsDateTime write SetAsDate;
719		property AsBoolean:boolean read GetAsBoolean write SetAsBoolean;
720		property AsTime: TDateTime read GetAsDateTime write SetAsTime;
#	Line 636 | Line 731 | type
731		property AsVariant: Variant read GetAsVariant write SetAsVariant;
732		property AsBlob: IBlob read GetAsBlob write SetAsBlob;
733		property AsArray: IArray read GetAsArray write SetAsArray;
734	+	property AsBCD: tBCD read GetAsBCD write SetAsBCD;
735		property AsQuad: TISC_QUAD read GetAsQuad write SetAsQuad;
736		property Value: Variant read GetAsVariant write SetAsVariant;
737		property IsNull: Boolean read GetIsNull write SetIsNull;
738		property IsNullable: Boolean read GetIsNullable;
739		property Modified: Boolean read getModified;
740		property Name: AnsiString read GetName;
645	–	property SQLType: cardinal read GetSQLType;
741		end;
742
743		{
#	Line 669 | Line 764 | type
764
765		TPerfCounters = array[TPerfStats] of Int64;
766
767	+	{Batch Query Execution Support}
768	+
769	+	TBatchCompletionState = (bcExecuteFailed, bcSuccessNoInfo, bcNoMoreErrors);
770	+
771	+	IBatchCompletion = interface
772	+	['{9bc3d49d-16d9-4606-94e5-ee987103ad92}']
773	+	function getTotalProcessed: cardinal;
774	+	function getState(updateNo: cardinal): TBatchCompletionState;
775	+	function getStatusMessage(updateNo: cardinal): AnsiString;
776	+	function getUpdated: integer;
777	+	function getErrorStatus(var RowNo: integer; var status: IStatus): boolean;
778	+	end;
779	+
780		{The IStatement interface provides access to an SQL Statement once it has been
781		initially prepared. The interface is returned from the IAttachment interface.
782		}
783
784	+	TStatementFlag = (stHasCursor,stRepeatExecute,stScrollable);
785	+	TStatementFlags = set of TStatementFlag;
786	+
787		IStatement = interface
788		['{a260576d-a07d-4a66-b02d-1b72543fd7cf}']
789		function GetMetaData: IMetaData;  {Output Metadata}
#	Line 680 | Line 791 | type
791		function GetPlan: AnsiString;
792		function GetRowsAffected(var SelectCount, InsertCount, UpdateCount, DeleteCount: integer): boolean;
793		function GetSQLStatementType: TIBSQLStatementTypes;
794	+	function GetSQLStatementTypeName: AnsiString;
795		function GetSQLText: AnsiString;
796		function GetProcessedSQLText: AnsiString;
797		function GetSQLDialect: integer;
798	+	function GetFlags: TStatementFlags;
799		function IsPrepared: boolean;
800	<	procedure Prepare(aTransaction: ITransaction=nil);
800	>	function HasBatchMode: boolean;
801	>	function IsInBatchMode: boolean;
802	>	procedure Prepare(aTransaction: ITransaction=nil); overload;
803	>	procedure Prepare(CursorName: AnsiString; aTransaction: ITransaction=nil); overload;
804		function Execute(aTransaction: ITransaction=nil): IResults;
805	<	function OpenCursor(aTransaction: ITransaction=nil): IResultSet;
805	>	function OpenCursor(aTransaction: ITransaction=nil): IResultSet; overload;
806	>	function OpenCursor(Scrollable: boolean; aTransaction: ITransaction=nil): IResultSet; overload;
807		function GetAttachment: IAttachment;
808		function GetTransaction: ITransaction;
809		procedure SetRetainInterfaces(aValue: boolean);
810		procedure EnableStatistics(aValue: boolean);
811		function GetPerfStatistics(var stats: TPerfCounters): boolean;
812	+	{IBatch interface support}
813	+	procedure AddToBatch;
814	+	function ExecuteBatch(aTransaction: ITransaction=nil): IBatchCompletion;
815	+	procedure CancelBatch;
816	+	function GetBatchCompletion: IBatchCompletion;
817	+	function GetBatchRowLimit: integer;
818	+	procedure SetBatchRowLimit(aLimit: integer);
819	+	{Stale Reference Check}
820	+	procedure SetStaleReferenceChecks(Enable:boolean); {default true}
821	+	function GetStaleReferenceChecks: boolean;
822	+
823		property MetaData: IMetaData read GetMetaData;
824		property SQLParams: ISQLParams read GetSQLParams;
825		property SQLStatementType: TIBSQLStatementTypes read GetSQLStatementType;
826		end;
827
828	+	ITrInfoItem = interface
829	+	['{41455e1a-f84e-4e26-aff0-1a78e8b69cfe}']
830	+	function getItemType: byte;
831	+	function getSize: integer;
832	+	function getAsString: AnsiString;
833	+	function getAsInteger: int64;
834	+	procedure DecodeTraIsolation(var IsolationType, RecVersion: byte);
835	+	end;
836	+
837	+	{ ITrInformation }
838	+
839	+	ITrInformation = interface
840	+	['{e6ea4a52-c1a1-44ba-9609-c8bcc7cba7b2}']
841	+	function GetCount: integer;
842	+	function GetItem(index: integer): ITrInfoItem;
843	+	function Find(ItemType: byte): ITrInfoItem;
844	+	procedure PrintBuf; {can be used to print buffer in hex for debugging}
845	+	property Count: integer read GetCount;
846	+	property Items[index: integer]: ITrInfoItem read getItem; default;
847	+	end;
848	+
849		{Transaction Parameter Block: (TPB)
850
851		The TPB provides the parameters used when starting a transaction. It is allocated
#	Line 708 | Line 857 | type
857		found in the Interbase 6.0 API Guide.
858		}
859
860	<	ITPBItem = interface(IParameterBlockItem)
860	>	ITPBItem = interface(IParameterBlockItemWithTypeName)
861		['{544c1f2b-7c12-4a87-a4a5-face7ea72671}']
862	+	function getParamTypeName: AnsiString;
863		end;
864
865	<	ITPB = interface(IParameterBlock<ITPBItem>)
865	>	ITPB = interface(IParameterBlockWithTypeNames<ITPBItem>)
866		['{7369b0ff-defe-437b-81fe-19b211d42d25}']
867		end;
868
#	Line 732 | Line 882 | type
882		function getTPB: ITPB;
883		procedure Start(DefaultCompletion: TTransactionCompletion=taCommit);
884		function GetInTransaction: boolean;
885	+	function GetIsReadOnly: boolean;
886	+	function GetTransactionID: integer;
887		procedure PrepareForCommit; {Two phase commit - stage 1}
888		procedure Commit(Force: boolean=false);
889		procedure CommitRetaining;
#	Line 740 | Line 892 | type
892		procedure RollbackRetaining;
893		function GetAttachmentCount: integer;
894		function GetAttachment(index: integer): IAttachment;
895	+	function GetTrInformation(Requests: array of byte): ITrInformation; overload;
896	+	function GetTrInformation(Request: byte): ITrInformation; overload;
897		property InTransaction: boolean read GetInTransaction;
898		end;
899
#	Line 778 | Line 932 | type
932		function GetAttachment: IAttachment;
933		end;
934
935	+	TTZTextOptions = (tzOffset,      {Time Zone Rendered as an offset to GMT}
936	+	tzGMT,         {No Time Zone. Time part is always rendered in GMT}
937	+	tzOriginalID); {Time Zone shown as originally entered}
938	+
939	+	{The ITimeZoneServices interface provides access to the time zone database
940	+	used for the attachment. It may be used in support of TIMESTAMP WITH TIME ZONE
941	+	and TIME WITH TIME ZONE data types.}
942	+
943	+	ITimeZoneServices = interface
944	+	['{163821f5-ebef-42b9-ac60-8ac4b5c09954}']
945	+	{utility functions}
946	+	function TimeZoneID2TimeZoneName(aTimeZoneID: TFBTimeZoneID): AnsiString;
947	+	function TimeZoneName2TimeZoneID(aTimeZone: AnsiString): TFBTimeZoneID;
948	+	function LocalTimeToGMT(aLocalTime: TDateTime; aTimeZone: AnsiString): TDateTime; overload;
949	+	function LocalTimeToGMT(aLocalTime: TDateTime; aTimeZoneID: TFBTimeZoneID): TDateTime; overload;
950	+	function GMTToLocalTime(aGMTTime: TDateTime; aTimeZone: AnsiString): TDateTime; overload;
951	+	function GMTToLocalTime(aGMTTime: TDateTime; aTimeZoneID: TFBTimeZoneID): TDateTime; overload;
952	+	function GetEffectiveOffsetMins(aLocalTime: TDateTime; aTimeZone: AnsiString): integer; overload;
953	+	function GetEffectiveOffsetMins(aLocalTime: TDateTime; aTimeZoneID: TFBTimeZoneID): integer; overload;
954	+
955	+	{Time Zone DB Information}
956	+	function UsingRemoteTZDB: boolean;
957	+	procedure SetUseLocalTZDB(useLocalTZDB: boolean);
958	+	function GetLocalTimeZoneName: AnsiString;
959	+	function GetLocalTimeZoneID: TFBTimeZoneID;
960	+	procedure GetTimeZoneInfo(aTimeZone: AnsiString; OnDate: TDateTime;
961	+	var ZoneOffset, DSTOffset, EffectiveOffset: integer);
962	+	{Configurable Options}
963	+	function GetTimeTZDate: TDateTime;
964	+	procedure SetTimeTZDate(aDate: TDateTime);
965	+	function GetTZTextOption: TTZTextOptions;
966	+	procedure SetTZTextOption(aOptionValue: TTZTextOptions);
967	+	end;
968	+
969		{The IDBInformation Interface.
970
971		An IDBInformation interface is returned by the  IAttachment GetDBInformation
#	Line 806 | Line 994 | type
994		function getSize: integer;
995		procedure getRawBytes(var Buffer);
996		function getAsString: AnsiString;
997	<	function getAsInteger: integer;
997	>	function getAsInteger: int64;
998		procedure DecodeIDCluster(var ConnectionType: integer; var DBFileName, DBSiteName: AnsiString);
999		function getAsBytes: TByteArray;
1000		function getAsDateTime: TDateTime;
#	Line 818 | Line 1006 | type
1006		function GetCount: integer;
1007		function GetItem(index: integer): IDBInfoItem;
1008		function Find(ItemType: byte): IDBInfoItem;
1009	<	property AsInteger: integer read getAsInteger;
1009	>	property AsInteger: int64 read getAsInteger;
1010		property AsString: AnsiString read GetAsString;
1011		property Count: integer read GetCount;
1012		property Items[index: integer]: IDBInfoItem read getItem; default;
#	Line 861 | Line 1049 | type
1049		found in the Interbase 6.0 API Guide.
1050		}
1051
1052	<	IDPBItem = interface(IParameterBlockItem)
1052	>	IDPBItem = interface(IParameterBlockItemWithTypeName)
1053		['{123d4ad0-087a-4cd1-a344-1b3d03b30673}']
1054		end;
1055
1056	<	IDPB = interface(IParameterBlock<IDPBItem>)
1057	<	['{e676067b-1cf4-4eba-9256-9724f57e0d16}']
1058	<	end;
1056	>	IDPB = interface(IParameterBlockWithTypeNames<IDPBItem>)
1057	>	['{e676067b-1cf4-4eba-9256-9724f57e0d16}']
1058	>	end;
1059
1060		{The IAttachment interface provides access to a Database Connection. It may be
1061		used to:
#	Line 916 | Line 1104 | type
1104		function ExecuteSQL(transaction: ITransaction; sql: AnsiString; SQLDialect: integer; params: array of const): IResults; overload;
1105		function ExecuteSQL(TPB: array of byte; sql: AnsiString; params: array of const): IResults; overload;
1106		function ExecuteSQL(transaction: ITransaction; sql: AnsiString; params: array of const): IResults; overload;
919	–	function OpenCursor(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer): IResultSet; overload;
1107		function OpenCursor(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer;
1108	+	Scrollable: boolean=false): IResultSet; overload;
1109	+	function OpenCursor(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer;
1110	+	params: array of const): IResultSet; overload;
1111	+	function OpenCursor(transaction: ITransaction; sql: AnsiString; Scrollable: boolean=false): IResultSet; overload;
1112	+	function OpenCursor(transaction: ITransaction; sql: AnsiString; Scrollable: boolean;
1113		params: array of const): IResultSet; overload;
922	–	function OpenCursor(transaction: ITransaction; sql: AnsiString): IResultSet; overload;
1114		function OpenCursor(transaction: ITransaction; sql: AnsiString;
1115		params: array of const): IResultSet; overload;
1116	<	function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer): IResultSet; overload;
1116	>	function OpenCursor(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer; Scrollable: boolean;
1117	>	params: array of const): IResultSet; overload;
1118	>	function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer;
1119	>	Scrollable: boolean=false): IResultSet; overload;
1120		function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer;
1121		params: array of const): IResultSet; overload;
1122	<	function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString): IResultSet; overload;
1122	>	function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer; Scrollable: boolean;
1123	>	params: array of const): IResultSet; overload;
1124	>	function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString; Scrollable: boolean=false): IResultSet; overload;
1125		function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString;
1126		params: array of const): IResultSet; overload;
1127	<	function OpenCursorAtStart(sql: AnsiString): IResultSet; overload;
1127	>	function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString; Scrollable: boolean;
1128	>	params: array of const): IResultSet; overload;
1129	>	function OpenCursorAtStart(sql: AnsiString; Scrollable: boolean=false): IResultSet; overload;
1130	>	function OpenCursorAtStart(sql: AnsiString; Scrollable: boolean;
1131	>	params: array of const): IResultSet; overload;
1132		function OpenCursorAtStart(sql: AnsiString;
1133		params: array of const): IResultSet; overload;
1134	<	function Prepare(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer): IStatement; overload;
1135	<	function Prepare(transaction: ITransaction; sql: AnsiString): IStatement; overload;
1134	>	function Prepare(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer; CursorName: AnsiString=''): IStatement; overload;
1135	>	function Prepare(transaction: ITransaction; sql: AnsiString; CursorName: AnsiString=''): IStatement; overload;
1136		function PrepareWithNamedParameters(transaction: ITransaction; sql: AnsiString;
1137		aSQLDialect: integer; GenerateParamNames: boolean=false;
1138	<	CaseSensitiveParams: boolean = false): IStatement; overload;
1138	>	CaseSensitiveParams: boolean = false; CursorName: AnsiString=''): IStatement; overload;
1139		function PrepareWithNamedParameters(transaction: ITransaction; sql: AnsiString;
1140		GenerateParamNames: boolean=false;
1141	<	CaseSensitiveParams: boolean = false): IStatement; overload;
1141	>	CaseSensitiveParams: boolean = false; CursorName: AnsiString=''): IStatement; overload;
1142
1143		{Events}
1144		function GetEventHandler(Events: TStrings): IEvents; overload;
#	Line 951 | Line 1151 | type
1151		function CreateBlob(transaction: ITransaction; SubType: integer; CharSetID: cardinal=0; BPB: IBPB=nil): IBlob; overload;
1152		function OpenBlob(transaction: ITransaction; RelationName, ColumnName: AnsiString; BlobID: TISC_QUAD; BPB: IBPB=nil): IBlob; overload;
1153		function OpenBlob(transaction: ITransaction; BlobMetaData: IBlobMetaData; BlobID: TISC_QUAD; BPB: IBPB=nil): IBlob;  overload;
1154	+	function GetInlineBlobLimit: integer;
1155	+	procedure SetInlineBlobLimit(limit: integer);
1156
1157		{Array - may use to open existing arrays. However, ISQLData.AsArray is preferred}
1158
#	Line 977 | Line 1179 | type
1179		function GetODSMinorVersion: integer;
1180		procedure getFBVersion(version: TStrings);
1181		function HasActivity: boolean;
1182	+	function HasDecFloatSupport: boolean;
1183	+	function HasBatchMode: boolean;
1184	+	function HasScollableCursors: boolean;
1185
1186		{Character Sets}
1187		function HasDefaultCharSet: boolean;
#	Line 988 | Line 1193 | type
1193		function CharSetWidth(CharSetID: integer; var Width: integer): boolean;
1194		procedure RegisterCharSet(CharSetName: AnsiString; CodePage: TSystemCodePage;
1195		AllowReverseLookup:boolean; out CharSetID: integer);
1196	<	end;
1196	>
1197	>	{Time Zone Database}
1198	>	function GetTimeZoneServices: ITimeZoneServices;
1199	>	function HasTimeZoneSupport: boolean;
1200	>	end;
1201
1202		TProtocolAll = (TCP, SPX, NamedPipe, Local, inet, inet4, inet6, wnet, xnet, unknownProtocol);
1203		TProtocol = TCP..xnet;
#	Line 1005 | Line 1214 | type
1214
1215		}
1216
1217	<	ISPBItem = interface(IParameterBlockItem)
1217	>	ISPBItem = interface(IParameterBlockItemWithTypeName)
1218		['{5d08ae2b-4519-41bd-8b40-97cd451c3f6a}']
1219		end;
1220
1221	<	ISPB = interface(IParameterBlock<ISPBItem>)
1221	>	ISPB = interface(IParameterBlockWithTypeNames<ISPBItem>)
1222		['{2c5836fd-41ed-4426-9b7d-5af580ec2659}']
1223		end;
1224
#	Line 1069 | Line 1278 | type
1278		function getSize: integer;
1279		procedure getRawBytes(var Buffer);
1280		function getAsString: AnsiString;
1281	<	function getAsInteger: integer;
1281	>	function getAsInteger: int64;
1282		function getAsByte: byte;
1283		function CopyTo(stream: TStream; count: integer): integer;
1284		property AsString: AnsiString read getAsString;
1285	<	property AsInteger: integer read getAsInteger;
1285	>	property AsInteger: int64 read getAsInteger;
1286		property AsByte: byte read getAsByte;
1287		end;
1288
#	Line 1143 | Line 1352 | type
1352		The interface is returned by the FirebirdAPI function.
1353		}
1354
1355	+	{ IFirebirdAPI }
1356	+
1357		IFirebirdAPI = interface
1358		['{edeee691-c8d3-4dcf-a780-cd7e432821d5}']
1359		{Database connections}
#	Line 1171 | Line 1382 | type
1382		function GetImplementationVersion: AnsiString;
1383		function GetClientMajor: integer;
1384		function GetClientMinor: integer;
1385	+	function HasDecFloatSupport: boolean;
1386	+	function HasLocalTZDB: boolean;
1387	+	function HasTimeZoneSupport: boolean;
1388	+	function HasExtendedTZSupport: boolean;
1389
1390		{Firebird 3 API}
1391		function HasMasterIntf: boolean;
1392	<	function GetIMaster: TObject;
1392	>	function GetIMaster: TObject;  deprecated 'Use FirebirdAPI.QueryInterface and FBClientLib.pas IFBIMasterProvider instead';
1393		function GetFBLibrary: IFirebirdLibrary;
1394		end;
1395
#	Line 1210 | Line 1425 | type
1425		{IB Client Exceptions}
1426		EIBClientError = class(EIBError);
1427
1428	+	{Used to explicitly report a Batch Buffer overflow}
1429	+	EIBBatchBufferOverflow = class(EIBError);
1430	+
1431		{The Firebird API function is used to access the IFirebirdAPI interface.
1432
1433		It will load the Firebird Client Library if this is not already loaded and
#	Line 1219 | Line 1437 | type
1437		function FirebirdAPI: IFirebirdAPI;
1438
1439		{IBX support functions. Probably best ignored i.e. always used the FirebirdAPI
1440	<	functino to load the library and check if it's loaded.}
1440	>	function to load the library and check if it's loaded.}
1441
1442		function TryIBLoad: Boolean;
1443		procedure CheckIBLoaded;
#	Line 1230 | Line 1448 | procedure CheckIBLoaded;
1448
1449		function LoadFBLibrary(aLibPathName: string): IFirebirdLibrary;
1450
1451	+
1452		implementation
1453
1454		uses FBClientAPI

Diff Legend

–	Removed lines
+	Added lines
<	Changed lines
>	Changed lines