ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/branches/udr/client/IB.pas
(Generate patch)

Comparing:
ibx/trunk/fbintf/IB.pas (file contents), Revision 270 by tony, Fri Jan 18 11:10:37 2019 UTC vs.
ibx/branches/udr/client/IB.pas (file contents), Revision 387 by tony, Wed Jan 19 13:34:42 2022 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 = 4;
139 <  FBIntf_Version = '1.1.4';
137 >  FBIntf_Minor = 4;
138 >  FBIntf_Release = 0;
139 >  FBIntf_Version = '1.4.0';
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 210 | Line 236 | type
236                    SQLGetSegment, SQLPutSegment,
237                    SQLExecProcedure, SQLStartTransaction,
238                    SQLCommit, SQLRollback,
239 <                  SQLSelectForUpdate, SQLSetGenerator);
239 >                  SQLSelectForUpdate, SQLSetGenerator,
240 >                  SQLSavePoint);
241  
242    TFBStatusCode = cardinal;
243    TByteArray = array of byte;
244 +  TFBTimeZoneID = ISC_USHORT;
245  
246    IFirebirdAPI = interface;
247    IAttachment = interface;
248    ITransaction = interface;
249 +  IStatement = interface;
250 +
251 +  {The IFBNumeric interface provides a managed type for Fixed Point integers
252 +   used to hold Firebird Numeric(m,n) types}
253 +
254 +  IFBNumeric = interface
255 +    ['{8bdccfe9-d552-446b-bd82-844ca264455d}']
256 +    function getRawValue: Int64;
257 +    function getScale: integer;
258 +    function AdjustScaleTo(aNewScale: integer): IFBNumeric;
259 +    function getAsString: AnsiString;
260 +    function getAsDouble: double;
261 +    function getAsBCD: TBCD;
262 +    function getAsInt64: Int64; {scaled}
263 +    function getAsInteger: integer; {scaled - may be truncated}
264 +    function getAsSmallInt: SmallInt; {scaled - may be truncated}
265 +    function getAsCurrency: Currency;
266 +  end;
267  
268    {The IParameterBlock interface provides the template for all parameter
269     block interfaces}
# Line 232 | Line 278 | type
278      property Items[index: integer]: _IItem read getItems; default;
279    end;
280  
281 +  IParameterBlockWithTypeNames<_IItem> = interface(IParameterBlock<_IItem>)
282 +    function AddByTypeName(ParamTypeName: AnsiString): _IItem;
283 +    function GetDPBParamTypeName(ParamType: byte): Ansistring; deprecated 'Use Get ParamTypeName';
284 +    function GetParamTypeName(ParamType: byte): Ansistring;
285 +  end;
286 +
287    {IParameterBlockItem is not used on its own but instead provides a base type for
288     different parameter block items }
289  
# Line 249 | Line 301 | type
301      property AsInteger: integer read getAsInteger write SetAsInteger;
302    end;
303  
304 +  IParameterBlockItemWithTypeName = interface(IParameterBlockItem)
305 +    function getParamTypeName: AnsiString;
306 +  end;
307  
308    {The IStatus interface provides access to error information, if any, returned
309     by the last API call. It can also be used to customise the error message
# Line 257 | Line 312 | type
312     This interface can be accessed from IFirebirdAPI.
313     }
314  
315 +   TIBDataBaseErrorMessage    = (ShowSQLCode,
316 +                                   ShowIBMessage,
317 +                                   ShowSQLMessage);
318 +
319 +   TIBDataBaseErrorMessages   = set of TIBDataBaseErrorMessage;
320 +
321 +   TStatusCode = long;
322 +
323    IStatus = interface
324      ['{34167722-af38-4831-b08a-93162d58ede3}']
325 <    function GetIBErrorCode: Long;
326 <    function Getsqlcode: Long;
325 >    function GetIBErrorCode: TStatusCode;
326 >    function Getsqlcode: TStatusCode;
327      function GetMessage: AnsiString;
328      function CheckStatusVector(ErrorCodes: array of TFBStatusCode): Boolean;
329      function GetIBDataBaseErrorMessages: TIBDataBaseErrorMessages;
330 +    function Clone: IStatus;
331      procedure SetIBDataBaseErrorMessages(Value: TIBDataBaseErrorMessages);
332    end;
333  
# Line 283 | Line 347 | type
347      function GetSQLTypeName: AnsiString;
348      function GetScale: integer;
349      function GetSize: cardinal;
350 +    function GetCharSetWidth: integer;
351      function GetCharSetID: cardinal;
352      function GetTableName: AnsiString;
353      function GetColumnName: AnsiString;
# Line 321 | Line 386 | type
386      function GetAsBoolean(index: array of integer): boolean;
387      function GetAsCurrency(index: array of integer): Currency;
388      function GetAsInt64(index: array of integer): Int64;
389 <    function GetAsDateTime(index: array of integer): TDateTime;
389 >    function GetAsDateTime(index: array of integer): TDateTime; overload;
390 >    procedure GetAsDateTime(index: array of integer; var aDateTime: TDateTime; var dstOffset: smallint; var aTimezoneID: TFBTimeZoneID); overload;
391 >    procedure GetAsDateTime(index: array of integer; var aDateTime: TDateTime; var dstOffset: smallint; var aTimezone: AnsiString); overload;
392 >    procedure GetAsTime(index: array of integer; var aTime: TDateTime; var dstOffset: smallint; var aTimezoneID: TFBTimeZoneID; OnDate: TDateTime); overload;
393 >    procedure GetAsTime(index: array of integer; var aTime: TDateTime; var dstOffset: smallint; var aTimezone: AnsiString; OnDate: TDateTime); overload;
394 >    function GetAsUTCDateTime(index: array of integer): TDateTime;
395      function GetAsDouble(index: array of integer): Double;
396      function GetAsFloat(index: array of integer): Float;
397      function GetAsLong(index: array of integer): Long;
398      function GetAsShort(index: array of integer): Short;
399      function GetAsString(index: array of integer): AnsiString;
400      function GetAsVariant(index: array of integer): Variant;
401 +    function GetAsBCD(index: array of integer): tBCD;
402      procedure SetAsInteger(index: array of integer; AValue: integer);
403      procedure SetAsBoolean(index: array of integer; AValue: boolean);
404      procedure SetAsCurrency(index: array of integer; Value: Currency);
405      procedure SetAsInt64(index: array of integer; Value: Int64);
406      procedure SetAsDate(index: array of integer; Value: TDateTime);
407 +    procedure SetAsDateTime(index: array of integer; Value: TDateTime); overload;
408 +    procedure SetAsDateTime(index: array of integer; aValue: TDateTime; aTimeZoneID: TFBTimeZoneID); overload;
409 +    procedure SetAsDateTime(index: array of integer; aValue: TDateTime; aTimeZone: AnsiString); overload;
410 +    procedure SetAsTime(index: array of integer; Value: TDateTime); overload;
411 +    procedure SetAsTime(index: array of integer; aValue: TDateTime; OnDate: TDateTime; aTimeZoneID: TFBTimeZoneID); overload;
412 +    procedure SetAsTime(index: array of integer; aValue: TDateTime; OnDate: TDateTime; aTimeZone: AnsiString); overload;
413 +    procedure SetAsUTCDateTime(index: array of integer; aUTCTime: TDateTime);
414      procedure SetAsLong(index: array of integer; Value: Long);
337    procedure SetAsTime(index: array of integer; Value: TDateTime);
338    procedure SetAsDateTime(index: array of integer; Value: TDateTime);
415      procedure SetAsDouble(index: array of integer; Value: Double);
416      procedure SetAsFloat(index: array of integer; Value: Float);
417      procedure SetAsShort(index: array of integer; Value: Short);
418      procedure SetAsString(index: array of integer; Value: AnsiString);
419      procedure SetAsVariant(index: array of integer; Value: Variant);
420 +    procedure SetAsBcd(index: array of integer; aValue: tBCD);
421      procedure SetBounds(dim, UpperBound, LowerBound: integer);
422      function GetAttachment: IAttachment;
423      function GetTransaction: ITransaction;
# Line 413 | Line 490 | type
490  
491    TIBDateTimeFormats = (dfTimestamp, {SQL TIMESTAMP}
492                          dfDateTime,   {SQL DATETIME}
493 <                        dfTime);      {SQL TIME}
493 >                        dfTime,      {SQL TIME}
494 >                        dfTimestampTZ, {SQL_TIMESTAMP_TZ}
495 >                        dfTimeTZ);       {SQLTIME_TZ
496  
497    { IColumnMetaData }
498  
# Line 431 | Line 510 | type
510      function getScale: integer;
511      function getCharSetID: cardinal;
512      function getCodePage: TSystemCodePage;
513 +    function GetCharSetWidth: integer;
514      function getIsNullable: boolean;
515      function GetSize: cardinal;
516      function GetArrayMetaData: IArrayMetaData; {Valid only for Array SQL Type}
517      function GetBlobMetaData: IBlobMetaData; {Valid only for Blob SQL Type}
518      function GetDateTimeStrLength(DateTimeFormat: TIBDateTimeFormats): integer;
519 +    function GetStatement: IStatement;
520 +    function GetTransaction: ITransaction;
521 +    function GetAttachment: IAttachment;
522      property Name: AnsiString read GetName;
523      property Size: cardinal read GetSize;
524      property SQLType: cardinal read GetSQLType;
# Line 477 | Line 560 | type
560  
561    ISQLData = interface(IColumnMetaData)
562      ['{3f493e31-7e3f-4606-a07c-b210b9e3619d}']
563 +    function GetStrDataLength: short;
564      function GetAsBoolean: boolean;
565      function GetAsCurrency: Currency;
566      function GetAsInt64: Int64;
567 <    function GetAsDateTime: TDateTime;
567 >    function GetAsDateTime: TDateTime; overload;
568 >    procedure GetAsDateTime(var aDateTime: TDateTime; var dstOffset: smallint; var aTimezoneID: TFBTimeZoneID); overload;
569 >    procedure GetAsDateTime(var aDateTime: TDateTime; var dstOffset: smallint; var aTimezone: AnsiString); overload;
570 >    procedure GetAsTime(var aTime: TDateTime; var dstOffset: smallint; var aTimezoneID: TFBTimeZoneID; OnDate: TDateTime); overload;
571 >    procedure GetAsTime(var aTime: TDateTime; var dstOffset: smallint; var aTimezone: AnsiString; OnDate: TDateTime); overload;
572 >    procedure GetAsTime(var aTime: TDateTime; var dstOffset: smallint; var aTimezoneID: TFBTimeZoneID); overload;
573 >    procedure GetAsTime(var aTime: TDateTime; var dstOffset: smallint; var aTimezone: AnsiString); overload;
574 >    function GetAsUTCDateTime: TDateTime;
575      function GetAsDouble: Double;
576      function GetAsFloat: Float;
577      function GetAsLong: Long;
# Line 493 | Line 584 | type
584      function GetAsBlob: IBlob; overload;
585      function GetAsBlob(BPB: IBPB): IBlob; overload;
586      function GetAsArray: IArray;
587 +    function GetAsBCD: tBCD;
588 +    function GetAsNumeric: IFBNumeric;
589      property AsDate: TDateTime read GetAsDateTime;
590      property AsBoolean:boolean read GetAsBoolean;
591      property AsTime: TDateTime read GetAsDateTime;
# Line 510 | Line 603 | type
603      property AsVariant: Variant read GetAsVariant ;
604      property AsBlob: IBlob read GetAsBlob;
605      property AsArray: IArray read GetAsArray;
606 +    property AsBCD: tBCD read GetAsBCD;
607 +    property AsNumeric: IFBNumeric read GetAsNumeric;
608      property IsNull: Boolean read GetIsNull;
609      property Value: Variant read GetAsVariant;
610    end;
# Line 523 | Line 618 | type
618    IResults = interface
619      ['{e836b2bb-93d1-4bbf-a8eb-7ce535de3bb5}']
620     function getCount: integer;
621 +   function GetStatement: IStatement;
622     function GetTransaction: ITransaction;
623 +   function GetAttachment: IAttachment;
624     function ByName(Idx: AnsiString): ISQLData;
625     function getSQLData(index: integer): ISQLData;
626     procedure GetData(index: integer; var IsNull:boolean; var len: short; var data: PByte);
# Line 539 | Line 636 | type
636    }
637    IResultSet = interface(IResults)
638      ['{0ae4979b-7857-4e8c-8918-ec6f155b51a0}']
639 <    function FetchNext: boolean;
639 >    function FetchNext: boolean; {fetch next record}
640 >    function FetchPrior: boolean; {fetch previous record}
641 >    function FetchFirst:boolean; {fetch first record}
642 >    function FetchLast: boolean; {fetch last record}
643 >    function FetchAbsolute(position: Integer): boolean; {fetch record by its absolute position in result set}
644 >    function FetchRelative(offset: Integer): boolean; {fetch record by position relative to current}
645      function GetCursorName: AnsiString;
646 +    function IsBof: boolean;
647      function IsEof: boolean;
648      procedure Close;
649    end;
650  
651    {The ISQLParam interface is used to provide access to each parameter in a
652 <   parametised SQL Statement. It subclasses IColumnMetaData and this part of
550 <   the interface may be used to access information on the expected SQL Type, etc.
551 <
552 <   It also subclasses ISQLData and this part of the interface may be used to access
553 <   current values for each parameter.
554 <
555 <   Otherwise, the interface comprises the Setter Methods and properties used to
652 >   parametised SQL Statement. The interface comprises the Setter Methods and properties used to
653     set the value of each parameter.
654  
655     Automatic conversion is provided to and from strings. That is GetAsString and
656     SetAsString are safe to use for sql types other than boolean - provided automatic
657     conversion is possible.
658 +
659 +   ISQLParam is subclassed from the IParamMetaData interface. This interface provides
660 +   access to the parameter metadata. This metadata is mutable and can change after
661 +   a parameter is set to a given value. This is acceptable as long as the parameter
662 +   metadata is type compatible with the underlying column metadata and hence the
663 +   parameter value can be converted by Firebird into a value acceptable by the
664 +   underlying column. The column metadata, which is unmutable, can be obtained
665 +   by the ISQLParam.getColMetadata interface. When a statement is prepared, the
666 +   parameter metadata is always initialised to the column metadata.
667    }
668  
669 <  ISQLParam = interface
670 <    ['{b22b4578-6d41-4807-a9a9-d2ec8d1d5a14}']
565 <    function GetIndex: integer;
669 >  IParamMetaData = interface
670 >  ['{4e148c4e-2d48-4991-a263-f66eca05c6aa}']
671      function GetSQLType: cardinal;
672      function GetSQLTypeName: AnsiString;
673      function getSubtype: integer;
569    function getName: AnsiString;
674      function getScale: integer;
675      function getCharSetID: cardinal;
676      function getCodePage: TSystemCodePage;
677      function getIsNullable: boolean;
678      function GetSize: cardinal;
679 +    property SQLType: cardinal read GetSQLType;
680 +  end;
681 +
682 +  ISQLParam = interface(IParamMetaData)
683 +    ['{b22b4578-6d41-4807-a9a9-d2ec8d1d5a14}']
684 +    function getColMetadata: IParamMetaData;
685 +    function GetStatement: IStatement;
686 +    function GetTransaction: ITransaction;
687 +    function GetAttachment: IAttachment;
688 +    function GetIndex: integer;
689 +    function getName: AnsiString;
690      function GetAsBoolean: boolean;
691      function GetAsCurrency: Currency;
692      function GetAsInt64: Int64;
693 <    function GetAsDateTime: TDateTime;
693 >    function GetAsDateTime: TDateTime; overload;
694 >    procedure GetAsDateTime(var aDateTime: TDateTime; var dstOffset: smallint; var aTimezoneID: TFBTimeZoneID); overload;
695 >    procedure GetAsDateTime(var aDateTime: TDateTime; var dstOffset: smallint; var aTimezone: AnsiString); overload;
696 >    procedure GetAsTime(var aTime: TDateTime; var dstOffset: smallint; var aTimezoneID: TFBTimeZoneID; OnDate: TDateTime); overload;
697 >    procedure GetAsTime(var aTime: TDateTime; var dstOffset: smallint; var aTimezone: AnsiString; OnDate: TDateTime); overload;
698 >    procedure GetAsTime(var aTime: TDateTime; var dstOffset: smallint; var aTimezoneID: TFBTimeZoneID); overload;
699 >    procedure GetAsTime(var aTime: TDateTime; var dstOffset: smallint; var aTimezone: AnsiString); overload;
700 >    function GetAsUTCDateTime: TDateTime;
701      function GetAsDouble: Double;
702      function GetAsFloat: Float;
703      function GetAsLong: Long;
# Line 587 | Line 709 | type
709      function GetAsVariant: Variant;
710      function GetAsBlob: IBlob;
711      function GetAsArray: IArray;
712 +    function GetAsBCD: tBCD;
713 +    function GetAsNumeric: IFBNumeric;
714      procedure Clear;
715      function GetModified: boolean;
716      procedure SetAsBoolean(AValue: boolean);
# Line 594 | Line 718 | type
718      procedure SetAsInt64(aValue: Int64);
719      procedure SetAsDate(aValue: TDateTime);
720      procedure SetAsLong(aValue: Long);
721 <    procedure SetAsTime(aValue: TDateTime);
722 <    procedure SetAsDateTime(aValue: TDateTime);
721 >    procedure SetAsTime(aValue: TDateTime); overload;
722 >    procedure SetAsTime(aValue: TDateTime; OnDate: TDateTime; aTimeZoneID: TFBTimeZoneID); overload;
723 >    procedure SetAsTime(aValue: TDateTime; OnDate: TDateTime; aTimeZone: AnsiString); overload;
724 >    procedure SetAsTime(aValue: TDateTime; aTimeZoneID: TFBTimeZoneID); overload;
725 >    procedure SetAsTime(aValue: TDateTime; aTimeZone: AnsiString); overload;
726 >    procedure SetAsDateTime(aValue: TDateTime); overload;
727 >    procedure SetAsDateTime(aValue: TDateTime; aTimeZoneID: TFBTimeZoneID); overload;
728 >    procedure SetAsDateTime(aValue: TDateTime; aTimeZone: AnsiString); overload;
729 >    procedure SetAsUTCDateTime(aUTCTime: TDateTime);
730      procedure SetAsDouble(aValue: Double);
731      procedure SetAsFloat(aValue: Float);
732      procedure SetAsPointer(aValue: Pointer);
# Line 607 | Line 738 | type
738      procedure SetAsArray(anArray: IArray);
739      procedure SetAsQuad(aValue: TISC_QUAD);
740      procedure SetCharSetID(aValue: cardinal);
741 +    procedure SetAsBcd(aValue: tBCD);
742 +    procedure SetAsNumeric(Value: IFBNumeric);
743      property AsDate: TDateTime read GetAsDateTime write SetAsDate;
744      property AsBoolean:boolean read GetAsBoolean write SetAsBoolean;
745      property AsTime: TDateTime read GetAsDateTime write SetAsTime;
# Line 623 | Line 756 | type
756      property AsVariant: Variant read GetAsVariant write SetAsVariant;
757      property AsBlob: IBlob read GetAsBlob write SetAsBlob;
758      property AsArray: IArray read GetAsArray write SetAsArray;
759 +    property AsBCD: tBCD read GetAsBCD write SetAsBCD;
760 +    property AsNumeric: IFBNumeric read GetAsNumeric write SetAsNumeric;
761      property AsQuad: TISC_QUAD read GetAsQuad write SetAsQuad;
762      property Value: Variant read GetAsVariant write SetAsVariant;
763      property IsNull: Boolean read GetIsNull write SetIsNull;
764      property IsNullable: Boolean read GetIsNullable;
765      property Modified: Boolean read getModified;
766      property Name: AnsiString read GetName;
632    property SQLType: cardinal read GetSQLType;
767    end;
768  
769     {
# Line 643 | Line 777 | type
777      function getSQLParam(index: integer): ISQLParam;
778      function ByName(Idx: AnsiString): ISQLParam ;
779      function GetModified: Boolean;
780 +    function GetHasCaseSensitiveParams: Boolean;
781 +    function GetStatement: IStatement;
782 +    function GetTransaction: ITransaction;
783 +    function GetAttachment: IAttachment;
784 +    procedure Clear;
785      property Modified: Boolean read GetModified;
786      property Params[index: integer]: ISQLParam read getSQLParam; default;
787      property Count: integer read getCount;
# Line 655 | Line 794 | type
794  
795    TPerfCounters = array[TPerfStats] of Int64;
796  
797 +  {Batch Query Execution Support}
798 +
799 +  TBatchCompletionState = (bcExecuteFailed, bcSuccessNoInfo, bcNoMoreErrors);
800 +
801 +  IBatchCompletion = interface
802 +  ['{9bc3d49d-16d9-4606-94e5-ee987103ad92}']
803 +    function getTotalProcessed: cardinal;
804 +    function getState(updateNo: cardinal): TBatchCompletionState;
805 +    function getStatusMessage(updateNo: cardinal): AnsiString;
806 +    function getUpdated: integer;
807 +    function getErrorStatus(var RowNo: integer; var status: IStatus): boolean;
808 +    end;
809 +
810    {The IStatement interface provides access to an SQL Statement once it has been
811     initially prepared. The interface is returned from the IAttachment interface.
812     }
813  
814 +  TStatementFlag = (stHasCursor,stRepeatExecute,stScrollable);
815 +  TStatementFlags = set of TStatementFlag;
816 +
817    IStatement = interface
818      ['{a260576d-a07d-4a66-b02d-1b72543fd7cf}']
819      function GetMetaData: IMetaData;  {Output Metadata}
# Line 666 | Line 821 | type
821      function GetPlan: AnsiString;
822      function GetRowsAffected(var SelectCount, InsertCount, UpdateCount, DeleteCount: integer): boolean;
823      function GetSQLStatementType: TIBSQLStatementTypes;
824 +    function GetSQLStatementTypeName: AnsiString;
825      function GetSQLText: AnsiString;
826      function GetProcessedSQLText: AnsiString;
827      function GetSQLDialect: integer;
828 +    function GetFlags: TStatementFlags;
829      function IsPrepared: boolean;
830 <    procedure Prepare(aTransaction: ITransaction=nil);
830 >    function HasBatchMode: boolean;
831 >    function IsInBatchMode: boolean;
832 >    procedure Prepare(aTransaction: ITransaction=nil); overload;
833 >    procedure Prepare(CursorName: AnsiString; aTransaction: ITransaction=nil); overload;
834      function Execute(aTransaction: ITransaction=nil): IResults;
835 <    function OpenCursor(aTransaction: ITransaction=nil): IResultSet;
835 >    function OpenCursor(aTransaction: ITransaction=nil): IResultSet; overload;
836 >    function OpenCursor(Scrollable: boolean; aTransaction: ITransaction=nil): IResultSet; overload;
837      function GetAttachment: IAttachment;
838      function GetTransaction: ITransaction;
839      procedure SetRetainInterfaces(aValue: boolean);
840      procedure EnableStatistics(aValue: boolean);
841      function GetPerfStatistics(var stats: TPerfCounters): boolean;
842 +    {IBatch interface support}
843 +    procedure AddToBatch;
844 +    function ExecuteBatch(aTransaction: ITransaction=nil): IBatchCompletion;
845 +    procedure CancelBatch;
846 +    function GetBatchCompletion: IBatchCompletion;
847 +    function GetBatchRowLimit: integer;
848 +    procedure SetBatchRowLimit(aLimit: integer);
849 +    {Stale Reference Check}
850 +    procedure SetStaleReferenceChecks(Enable:boolean); {default true}
851 +    function GetStaleReferenceChecks: boolean;
852 +
853      property MetaData: IMetaData read GetMetaData;
854      property SQLParams: ISQLParams read GetSQLParams;
855      property SQLStatementType: TIBSQLStatementTypes read GetSQLStatementType;
856    end;
857  
858 +  ITrInfoItem = interface
859 +    ['{41455e1a-f84e-4e26-aff0-1a78e8b69cfe}']
860 +    function getItemType: byte;
861 +    function getSize: integer;
862 +    function getAsString: AnsiString;
863 +    function getAsInteger: int64;
864 +    procedure DecodeTraIsolation(var IsolationType, RecVersion: byte);
865 +  end;
866 +
867 +  { ITrInformation }
868 +
869 +  ITrInformation = interface
870 +    ['{e6ea4a52-c1a1-44ba-9609-c8bcc7cba7b2}']
871 +    function GetCount: integer;
872 +    function GetItem(index: integer): ITrInfoItem;
873 +    function Find(ItemType: byte): ITrInfoItem;
874 +    procedure PrintBuf; {can be used to print buffer in hex for debugging}
875 +    property Count: integer read GetCount;
876 +    property Items[index: integer]: ITrInfoItem read getItem; default;
877 +  end;
878 +
879    {Transaction Parameter Block: (TPB)
880  
881     The TPB provides the parameters used when starting a transaction. It is allocated
# Line 694 | Line 887 | type
887     found in the Interbase 6.0 API Guide.
888    }
889  
890 <  ITPBItem = interface(IParameterBlockItem)
890 >  ITPBItem = interface(IParameterBlockItemWithTypeName)
891      ['{544c1f2b-7c12-4a87-a4a5-face7ea72671}']
892    end;
893  
894 <  ITPB = interface(IParameterBlock<ITPBItem>)
894 >  ITPB = interface(IParameterBlockWithTypeNames<ITPBItem>)
895      ['{7369b0ff-defe-437b-81fe-19b211d42d25}']
896 +    function AsText: AnsiString;
897    end;
898  
899    {The ITransactionAction interface provides access to a Transaction once it
# Line 712 | Line 906 | type
906  
907    TTransactionAction  = (TARollback, TACommit, TACommitRetaining, TARollbackRetaining);
908    TTransactionCompletion = TARollback.. TACommit;
909 +  TTrCompletionState = (trCommitted, trRolledback, trCommitFailed, trRollbackFailed);
910 +
911  
912    ITransaction = interface
913      ['{30928d0e-a9d7-4c61-b7cf-14f4f38abe2a}']
914      function getTPB: ITPB;
915      procedure Start(DefaultCompletion: TTransactionCompletion=taCommit);
916      function GetInTransaction: boolean;
917 +    function GetIsReadOnly: boolean;
918 +    function GetTransactionID: integer;
919 +    function GetJournalingActive(attachment: IAttachment): boolean;
920 +    function GetDefaultCompletion: TTransactionCompletion;
921      procedure PrepareForCommit; {Two phase commit - stage 1}
922 <    procedure Commit(Force: boolean=false);
922 >    function Commit(Force: boolean=false): TTrCompletionState;
923      procedure CommitRetaining;
924      function HasActivity: boolean;
925 <    procedure Rollback(Force: boolean=false);
925 >    function Rollback(Force: boolean=false): TTrCompletionState;
926      procedure RollbackRetaining;
927      function GetAttachmentCount: integer;
928      function GetAttachment(index: integer): IAttachment;
929 +    function GetTrInformation(Requests: array of byte): ITrInformation; overload;
930 +    function GetTrInformation(Request: byte): ITrInformation; overload;
931 +    function GetTransactionName: AnsiString;
932 +    procedure SetTransactionName(aValue: AnsiString);
933      property InTransaction: boolean read GetInTransaction;
934 +    property TransactionName: AnsiString read GetTransactionName write SetTransactionName;
935    end;
936  
937    { The IEvents Interface is used to handle events from a single database. The
# Line 756 | Line 961 | type
961      ['{6a0be233-ed08-4524-889c-2e45d0c20e5f}']
962      procedure GetEvents(EventNames: TStrings);
963      procedure SetEvents(EventNames: TStrings); overload;
964 <    procedure SetEvents(EventName: AnsiString); overload;
964 >    procedure SetEvents(EventName: string); overload;
965      procedure Cancel;
966      function ExtractEventCounts: TEventCounts;
967      procedure WaitForEvent;
# Line 764 | Line 969 | type
969      function GetAttachment: IAttachment;
970    end;
971  
972 +  TTZTextOptions = (tzOffset,      {Time Zone Rendered as an offset to GMT}
973 +                    tzGMT,         {No Time Zone. Time part is always rendered in GMT}
974 +                    tzOriginalID); {Time Zone shown as originally entered}
975 +
976 +  {The ITimeZoneServices interface provides access to the time zone database
977 +   used for the attachment. It may be used in support of TIMESTAMP WITH TIME ZONE
978 +   and TIME WITH TIME ZONE data types.}
979 +
980 +  ITimeZoneServices = interface
981 +    ['{163821f5-ebef-42b9-ac60-8ac4b5c09954}']
982 +    {utility functions}
983 +    function TimeZoneID2TimeZoneName(aTimeZoneID: TFBTimeZoneID): AnsiString;
984 +    function TimeZoneName2TimeZoneID(aTimeZone: AnsiString): TFBTimeZoneID;
985 +    function LocalTimeToGMT(aLocalTime: TDateTime; aTimeZone: AnsiString): TDateTime; overload;
986 +    function LocalTimeToGMT(aLocalTime: TDateTime; aTimeZoneID: TFBTimeZoneID): TDateTime; overload;
987 +    function GMTToLocalTime(aGMTTime: TDateTime; aTimeZone: AnsiString): TDateTime; overload;
988 +    function GMTToLocalTime(aGMTTime: TDateTime; aTimeZoneID: TFBTimeZoneID): TDateTime; overload;
989 +    function GetEffectiveOffsetMins(aLocalTime: TDateTime; aTimeZone: AnsiString): integer; overload;
990 +    function GetEffectiveOffsetMins(aLocalTime: TDateTime; aTimeZoneID: TFBTimeZoneID): integer; overload;
991 +
992 +    {Time Zone DB Information}
993 +    function UsingRemoteTZDB: boolean;
994 +    procedure SetUseLocalTZDB(useLocalTZDB: boolean);
995 +    function GetLocalTimeZoneName: AnsiString;
996 +    function GetLocalTimeZoneID: TFBTimeZoneID;
997 +    procedure GetTimeZoneInfo(aTimeZone: AnsiString; OnDate: TDateTime;
998 +                           var ZoneOffset, DSTOffset, EffectiveOffset: integer);
999 +    {Configurable Options}
1000 +    function GetTimeTZDate: TDateTime;
1001 +    procedure SetTimeTZDate(aDate: TDateTime);
1002 +    function GetTZTextOption: TTZTextOptions;
1003 +    procedure SetTZTextOption(aOptionValue: TTZTextOptions);
1004 +  end;
1005 +
1006    {The IDBInformation Interface.
1007  
1008     An IDBInformation interface is returned by the  IAttachment GetDBInformation
# Line 792 | Line 1031 | type
1031      function getSize: integer;
1032      procedure getRawBytes(var Buffer);
1033      function getAsString: AnsiString;
1034 <    function getAsInteger: integer;
1034 >    function getAsInteger: int64;
1035      procedure DecodeIDCluster(var ConnectionType: integer; var DBFileName, DBSiteName: AnsiString);
1036      function getAsBytes: TByteArray;
1037      function getAsDateTime: TDateTime;
# Line 804 | Line 1043 | type
1043      function GetCount: integer;
1044      function GetItem(index: integer): IDBInfoItem;
1045      function Find(ItemType: byte): IDBInfoItem;
1046 <    property AsInteger: integer read getAsInteger;
1046 >    property AsInteger: int64 read getAsInteger;
1047      property AsString: AnsiString read GetAsString;
1048      property Count: integer read GetCount;
1049      property Items[index: integer]: IDBInfoItem read getItem; default;
# Line 847 | Line 1086 | type
1086     found in the Interbase 6.0 API Guide.
1087     }
1088  
1089 <  IDPBItem = interface(IParameterBlockItem)
1089 >  IDPBItem = interface(IParameterBlockItemWithTypeName)
1090      ['{123d4ad0-087a-4cd1-a344-1b3d03b30673}']
1091    end;
1092  
1093 <  IDPB = interface(IParameterBlock<IDPBItem>)
1094 <    ['{e676067b-1cf4-4eba-9256-9724f57e0d16}']
1095 <  end;
1093 >   IDPB = interface(IParameterBlockWithTypeNames<IDPBItem>)
1094 >     ['{e676067b-1cf4-4eba-9256-9724f57e0d16}']
1095 >   end;
1096 >
1097 >   {Journaling options. Default is [joReadWriteTransactions,joModifyQueries] }
1098 >
1099 >   TJournalOption = (joReadOnlyTransactions, joReadWriteTransactions,
1100 >                     joModifyQueries, joReadOnlyQueries,joNoServerTable);
1101 >
1102 >   TJournalOptions = set of TJournalOption;
1103  
1104    {The IAttachment interface provides access to a Database Connection. It may be
1105     used to:
# Line 892 | Line 1138 | type
1138      procedure Disconnect(Force: boolean=false);
1139      function IsConnected: boolean;
1140      procedure DropDatabase;
1141 <    function StartTransaction(TPB: array of byte; DefaultCompletion: TTransactionCompletion=taCommit): ITransaction; overload;
1142 <    function StartTransaction(TPB: ITPB; DefaultCompletion: TTransactionCompletion=taCommit): ITransaction; overload;
1141 >    function StartTransaction(TPB: array of byte;
1142 >                              DefaultCompletion: TTransactionCompletion=taCommit;
1143 >                              aName: AnsiString=''): ITransaction; overload;
1144 >    function StartTransaction(TPB: ITPB;
1145 >                              DefaultCompletion: TTransactionCompletion=taCommit;
1146 >                              aName: AnsiString=''): ITransaction; overload;
1147      procedure ExecImmediate(transaction: ITransaction; sql: AnsiString; SQLDialect: integer); overload;
1148      procedure ExecImmediate(TPB: array of byte; sql: AnsiString; SQLDialect: integer); overload;
1149      procedure ExecImmediate(transaction: ITransaction; sql: AnsiString); overload;
# Line 902 | Line 1152 | type
1152      function ExecuteSQL(transaction: ITransaction; sql: AnsiString; SQLDialect: integer; params: array of const): IResults; overload;
1153      function ExecuteSQL(TPB: array of byte; sql: AnsiString; params: array of const): IResults; overload;
1154      function ExecuteSQL(transaction: ITransaction; sql: AnsiString; params: array of const): IResults; overload;
1155 <    function OpenCursor(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer): IResultSet; overload;
1155 >    function OpenCursor(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer;
1156 >                             Scrollable: boolean=false): IResultSet; overload;
1157      function OpenCursor(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer;
1158                               params: array of const): IResultSet; overload;
1159 <    function OpenCursor(transaction: ITransaction; sql: AnsiString): IResultSet; overload;
1159 >    function OpenCursor(transaction: ITransaction; sql: AnsiString; Scrollable: boolean=false): IResultSet; overload;
1160 >    function OpenCursor(transaction: ITransaction; sql: AnsiString; Scrollable: boolean;
1161 >                             params: array of const): IResultSet; overload;
1162      function OpenCursor(transaction: ITransaction; sql: AnsiString;
1163                               params: array of const): IResultSet; overload;
1164 <    function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer): IResultSet; overload;
1164 >    function OpenCursor(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer; Scrollable: boolean;
1165 >                             params: array of const): IResultSet; overload;
1166      function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer;
1167 +                             Scrollable: boolean=false): IResultSet; overload;
1168 +    function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer;
1169 +                             params: array of const): IResultSet; overload;
1170 +    function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer; Scrollable: boolean;
1171                               params: array of const): IResultSet; overload;
1172 <    function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString): IResultSet; overload;
1172 >    function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString; Scrollable: boolean=false): IResultSet; overload;
1173      function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString;
1174                               params: array of const): IResultSet; overload;
1175 <    function OpenCursorAtStart(sql: AnsiString): IResultSet; overload;
1175 >    function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString; Scrollable: boolean;
1176 >                             params: array of const): IResultSet; overload;
1177 >    function OpenCursorAtStart(sql: AnsiString; Scrollable: boolean=false): IResultSet; overload;
1178 >    function OpenCursorAtStart(sql: AnsiString; Scrollable: boolean;
1179 >                             params: array of const): IResultSet; overload;
1180      function OpenCursorAtStart(sql: AnsiString;
1181                               params: array of const): IResultSet; overload;
1182 <    function Prepare(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer): IStatement; overload;
1183 <    function Prepare(transaction: ITransaction; sql: AnsiString): IStatement; overload;
1182 >    function Prepare(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer; CursorName: AnsiString=''): IStatement; overload;
1183 >    function Prepare(transaction: ITransaction; sql: AnsiString; CursorName: AnsiString=''): IStatement; overload;
1184      function PrepareWithNamedParameters(transaction: ITransaction; sql: AnsiString;
1185                         aSQLDialect: integer; GenerateParamNames: boolean=false;
1186 <                       CaseSensitiveParams: boolean = false): IStatement; overload;
1186 >                       CaseSensitiveParams: boolean = false; CursorName: AnsiString=''): IStatement; overload;
1187      function PrepareWithNamedParameters(transaction: ITransaction; sql: AnsiString;
1188                         GenerateParamNames: boolean=false;
1189 <                       CaseSensitiveParams: boolean = false): IStatement; overload;
1189 >                       CaseSensitiveParams: boolean = false; CursorName: AnsiString=''): IStatement; overload;
1190  
1191      {Events}
1192      function GetEventHandler(Events: TStrings): IEvents; overload;
# Line 935 | Line 1197 | type
1197      function CreateBlob(transaction: ITransaction; RelationName, ColumnName: AnsiString; BPB: IBPB=nil): IBlob; overload;
1198      function CreateBlob(transaction: ITransaction; BlobMetaData: IBlobMetaData; BPB: IBPB=nil): IBlob; overload;
1199      function CreateBlob(transaction: ITransaction; SubType: integer; CharSetID: cardinal=0; BPB: IBPB=nil): IBlob; overload;
1200 <    function OpenBlob(transaction: ITransaction; RelationName, ColumnName: AnsiString; BlobID: TISC_QUAD; BPB: IBPB=nil): IBlob;
1200 >    function OpenBlob(transaction: ITransaction; RelationName, ColumnName: AnsiString; BlobID: TISC_QUAD; BPB: IBPB=nil): IBlob; overload;
1201 >    function OpenBlob(transaction: ITransaction; BlobMetaData: IBlobMetaData; BlobID: TISC_QUAD; BPB: IBPB=nil): IBlob;  overload;
1202 >    function GetInlineBlobLimit: integer;
1203 >    procedure SetInlineBlobLimit(limit: integer);
1204  
1205      {Array - may use to open existing arrays. However, ISQLData.AsArray is preferred}
1206  
1207 <    function OpenArray(transaction: ITransaction; RelationName, ColumnName: AnsiString; ArrayID: TISC_QUAD): IArray;
1207 >    function OpenArray(transaction: ITransaction; RelationName, ColumnName: AnsiString; ArrayID: TISC_QUAD): IArray; overload;
1208 >    function OpenArray(transaction: ITransaction; ArrayMetaData: IArrayMetaData; ArrayID: TISC_QUAD): IArray; overload;
1209      function CreateArray(transaction: ITransaction; RelationName, ColumnName: AnsiString): IArray; overload;
1210      function CreateArray(transaction: ITransaction; ArrayMetaData: IArrayMetaData): IArray; overload;
1211      function CreateArrayMetaData(SQLType: cardinal; tableName: AnsiString; columnName: AnsiString;
# Line 948 | Line 1214 | type
1214  
1215      {Database Information}
1216      function GetSQLDialect: integer;
1217 +    function GetAttachmentID: integer;
1218      function GetBlobMetaData(Transaction: ITransaction; tableName, columnName: AnsiString): IBlobMetaData;
1219      function GetArrayMetaData(Transaction: ITransaction; tableName, columnName: AnsiString): IArrayMetaData;
1220      function GetDBInformation(Requests: array of byte): IDBInformation; overload;
# Line 961 | Line 1228 | type
1228      function GetODSMinorVersion: integer;
1229      procedure getFBVersion(version: TStrings);
1230      function HasActivity: boolean;
1231 +    function HasDecFloatSupport: boolean;
1232 +    function HasBatchMode: boolean;
1233 +    function HasScollableCursors: boolean;
1234 +    function HasTable(aTableName: AnsiString): boolean;  {case sensitive}
1235 +    function HasFunction(aFunctionName: AnsiString): boolean; {case sensitive}
1236 +    function HasProcedure(aProcName: AnsiString): boolean; {case sensitive}
1237  
1238      {Character Sets}
1239 +    function GetCharSetID: integer; {connection character set}
1240      function HasDefaultCharSet: boolean;
1241      function GetDefaultCharSetID: integer;
1242      function GetCharsetName(CharSetID: integer): AnsiString;
# Line 972 | Line 1246 | type
1246      function CharSetWidth(CharSetID: integer; var Width: integer): boolean;
1247      procedure RegisterCharSet(CharSetName: AnsiString; CodePage: TSystemCodePage;
1248        AllowReverseLookup:boolean; out CharSetID: integer);
1249 <  end;
1249 >
1250 >    {Time Zone Database}
1251 >    function GetTimeZoneServices: ITimeZoneServices;
1252 >    function HasTimeZoneSupport: boolean;
1253 >
1254 >    {Client side Journaling}
1255 >    function JournalingActive: boolean;
1256 >    function GetJournalOptions: TJournalOptions;
1257 >    function StartJournaling(aJournalLogFile: AnsiString): integer; overload;
1258 >    function StartJournaling(aJournalLogFile: AnsiString; Options: TJournalOptions): integer; overload;
1259 >    function StartJournaling(S: TStream; Options: TJournalOptions): integer; overload;
1260 >    procedure StopJournaling(RetainJournal: boolean);
1261 > end;
1262  
1263    TProtocolAll = (TCP, SPX, NamedPipe, Local, inet, inet4, inet6, wnet, xnet, unknownProtocol);
1264    TProtocol = TCP..xnet;
# Line 989 | Line 1275 | type
1275  
1276    }
1277  
1278 <  ISPBItem = interface(IParameterBlockItem)
1278 >  ISPBItem = interface(IParameterBlockItemWithTypeName)
1279      ['{5d08ae2b-4519-41bd-8b40-97cd451c3f6a}']
1280    end;
1281  
1282 <  ISPB = interface(IParameterBlock<ISPBItem>)
1282 >  ISPB = interface(IParameterBlockWithTypeNames<ISPBItem>)
1283      ['{2c5836fd-41ed-4426-9b7d-5af580ec2659}']
1284    end;
1285  
# Line 1053 | Line 1339 | type
1339      function getSize: integer;
1340      procedure getRawBytes(var Buffer);
1341      function getAsString: AnsiString;
1342 <    function getAsInteger: integer;
1342 >    function getAsInteger: int64;
1343      function getAsByte: byte;
1344      function CopyTo(stream: TStream; count: integer): integer;
1345      property AsString: AnsiString read getAsString;
1346 <    property AsInteger: integer read getAsInteger;
1346 >    property AsInteger: int64 read getAsInteger;
1347      property AsByte: byte read getAsByte;
1348    end;
1349  
# Line 1127 | Line 1413 | type
1413     The interface is returned by the FirebirdAPI function.
1414    }
1415  
1416 +  { IFirebirdAPI }
1417 +
1418    IFirebirdAPI = interface
1419      ['{edeee691-c8d3-4dcf-a780-cd7e432821d5}']
1420      {Database connections}
# Line 1138 | Line 1426 | type
1426      {Start Transaction against multiple databases}
1427      function AllocateTPB: ITPB;
1428      function StartTransaction(Attachments: array of IAttachment;
1429 <             TPB: array of byte; DefaultCompletion: TTransactionCompletion=taCommit): ITransaction; overload;
1429 >             TPB: array of byte; DefaultCompletion: TTransactionCompletion=taCommit;
1430 >             aName: AnsiString=''): ITransaction; overload;
1431      function StartTransaction(Attachments: array of IAttachment;
1432 <             TPB: ITPB; DefaultCompletion: TTransactionCompletion=taCommit): ITransaction; overload;
1432 >             TPB: ITPB; DefaultCompletion: TTransactionCompletion=taCommit;
1433 >             aName: AnsiString=''): ITransaction; overload;
1434  
1435      {Service Manager}
1436      function HasServiceAPI: boolean;
# Line 1153 | Line 1443 | type
1443      function HasRollbackRetaining: boolean;
1444      function IsEmbeddedServer: boolean;
1445      function GetImplementationVersion: AnsiString;
1446 +    function GetClientMajor: integer;
1447 +    function GetClientMinor: integer;
1448 +    function HasDecFloatSupport: boolean;
1449 +    function HasLocalTZDB: boolean;
1450 +    function HasTimeZoneSupport: boolean;
1451 +    function HasExtendedTZSupport: boolean;
1452  
1453      {Firebird 3 API}
1454      function HasMasterIntf: boolean;
1455 <    function GetIMaster: TObject;
1455 >    function GetIMaster: TObject;  deprecated 'Use FirebirdAPI.QueryInterface and FBClientLib.pas IFBIMasterProvider instead';
1456      function GetFBLibrary: IFirebirdLibrary;
1457   end;
1458  
# Line 1183 | Line 1479 | type
1479     EIBInterBaseError = class(EIBError)
1480     private
1481       FIBErrorCode: Long;
1482 +     FStatus: IStatus;
1483     public
1484 <     constructor Create(Status: IStatus); overload;
1484 >     constructor Create(aStatus: IStatus); overload;
1485       constructor Create(ASQLCode: Long; AIBErrorCode: Long; Msg: AnsiString); overload;
1486       property IBErrorCode: Long read FIBErrorCode;
1487 +     property Status: IStatus read FStatus;
1488     end;
1489  
1490     {IB Client Exceptions}
1491     EIBClientError = class(EIBError);
1492  
1493 < {IBError is used internally and by IBX to throw an EIBClientError}
1494 <
1197 < procedure IBError(ErrMess: TIBClientError; const Args: array of const);
1493 >   {Used to explicitly report a Batch Buffer overflow}
1494 >   EIBBatchBufferOverflow = class(EIBError);
1495  
1496   {The Firebird API function is used to access the IFirebirdAPI interface.
1497  
# Line 1205 | Line 1502 | procedure IBError(ErrMess: TIBClientErro
1502   function FirebirdAPI: IFirebirdAPI;
1503  
1504   {IBX support functions. Probably best ignored i.e. always used the FirebirdAPI
1505 < functino to load the library and check if it's loaded.}
1505 > function to load the library and check if it's loaded.}
1506  
1507   function TryIBLoad: Boolean;
1508   procedure CheckIBLoaded;
# Line 1216 | Line 1513 | procedure CheckIBLoaded;
1513  
1514   function LoadFBLibrary(aLibPathName: string): IFirebirdLibrary;
1515  
1516 + {$if not declared(Null)} {Needed for Delphi}
1517 + function Null: Variant;       // Null standard constant
1518 + {$define NEEDNULLFUNCTION}
1519 + {$ifend}
1520 +
1521   implementation
1522  
1523 < uses FBClientAPI
1523 > uses FBClientAPI {$if not declared(NULL)}, Variants {$ifend}
1524    {$IFDEF USELEGACYFIREBIRDAPI}, FB25ClientAPI {$ENDIF}
1525    {$IFDEF USEFIREBIRD3API}, FB30ClientAPI {$ENDIF};
1526  
# Line 1310 | Line 1612 | end;
1612  
1613   { EIBInterBaseError }
1614  
1615 < constructor EIBInterBaseError.Create(Status: IStatus);
1615 > constructor EIBInterBaseError.Create(aStatus: IStatus);
1616   begin
1617 <  inherited Create(Status.Getsqlcode,Status.GetMessage);
1618 <  FIBErrorCode := Status.GetIBErrorCode;
1617 >  inherited Create(aStatus.Getsqlcode,aStatus.GetMessage);
1618 >  FIBErrorCode := aStatus.GetIBErrorCode;
1619 >  FStatus := aStatus.Clone;
1620   end;
1621  
1622   constructor EIBInterBaseError.Create(ASQLCode: Long; AIBErrorCode: Long;
# Line 1323 | Line 1626 | begin
1626    FIBErrorCode := AIBErrorCode;
1627   end;
1628  
1629 < procedure IBError(ErrMess: TIBClientError; const Args: array of const);
1630 < begin
1631 <  raise EIBClientError.Create(Ord(ErrMess),
1632 <                              Format(GetErrorMessage(ErrMess), Args));
1633 < end;
1629 > {$ifdef NEEDNULLFUNCTION}
1630 > function Null: Variant;       // Null standard constant
1631 >   begin
1632 >     VarClearProc(TVarData(Result));
1633 >     TVarData(Result).VType := varnull;
1634 >   end;
1635 > {$endif}
1636  
1637   initialization
1638    FDefaultFBLibrary := nil;

Comparing:
ibx/trunk/fbintf/IB.pas (property svn:eol-style), Revision 270 by tony, Fri Jan 18 11:10:37 2019 UTC vs.
ibx/branches/udr/client/IB.pas (property svn:eol-style), Revision 387 by tony, Wed Jan 19 13:34:42 2022 UTC

# Line 0 | Line 1
1 + native

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines