ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/trunk/fbintf/changelog
(Generate patch)

Comparing ibx/trunk/fbintf/changelog (file contents):
Revision 356 by tony, Sun Oct 24 14:00:52 2021 UTC vs.
Revision 402 by tony, Mon Aug 1 10:07:24 2022 UTC

# Line 1 | Line 1
1 + FBINTF Change Log  version          (1.4-0 Build 13871) Fri, 29 Jul 2022 23:29:51 +0100
2 +
3 + 1. Support package fbudr added for support of User Defined Routines (UDRs), and package
4 +   fbudrtestbed for client side debugging of UDR libraries.
5 +
6 + 2. Package layout changed with introduction of udr support. IB*.pas files moved from
7 +    root directory to "client". IBHeader moved to "Client".
8 +
9 + 3. Delphi packages: all packages now compile .dcp and .bpi files to either
10 +   fbintf\Win32\Debug or fbintf\Win64\Debug by default. Please remove any pre-existing
11 +   fbintf.dcp and fbintf.bpi files from other locations.
12 +
13 + 4. Client side journaling support added. Interface changes
14 +   IAttachment
15 +    function JournalingActive: boolean;
16 +    function GetJournalOptions: TJournalOptions;
17 +    function StartJournaling(aJournalLogFile: AnsiString): integer; overload;
18 +    function StartJournaling(aJournalLogFile: AnsiString; Options: TJournalOptions): integer; overload;
19 +    function StartJournaling(S: TStream; Options: TJournalOptions): integer; overload;
20 +    procedure StopJournaling(RetainJournal: boolean);
21 +
22 + 5. Transactions may now be given a local transaction name:
23 +   IFirebirdAPI
24 +     function StartTransaction(Attachments: array of IAttachment;
25 +             TPB: array of byte; DefaultCompletion: TTransactionCompletion=taCommit): ITransaction; overload;
26 +             TPB: array of byte; DefaultCompletion: TTransactionCompletion=taCommit;
27 +             aName: AnsiString=''): ITransaction; overload;
28 +     function StartTransaction(Attachments: array of IAttachment;
29 +             TPB: ITPB; DefaultCompletion: TTransactionCompletion=taCommit): ITransaction; overload;
30 +             TPB: ITPB; DefaultCompletion: TTransactionCompletion=taCommit;
31 +             aName: AnsiString=''): ITransaction; overload;
32 +
33 +   IAttachment
34 +    function StartTransaction(TPB: array of byte; DefaultCompletion: TTransactionCompletion=taCommit): ITransaction; overload;
35 +    function StartTransaction(TPB: ITPB; DefaultCompletion: TTransactionCompletion=taCommit): ITransaction; overload;
36 +    function StartTransaction(TPB: array of byte;
37 +                              DefaultCompletion: TTransactionCompletion=taCommit;
38 +                              aName: AnsiString=''): ITransaction; overload;
39 +    function StartTransaction(TPB: ITPB;
40 +                              DefaultCompletion: TTransactionCompletion=taCommit;
41 +                              aName: AnsiString=''): ITransaction; overload;
42 +
43 +  ITransaction
44 +    function GetTransactionName: AnsiString;
45 +    procedure SetTransactionName(aValue: AnsiString);
46 +
47 + 6. Additional Transaction information
48 +     ITPB.function AsText: AnsiString; {Returns TPB as a text string}
49 +
50 +   ITransaction
51 +     function GetDefaultCompletion: TTransactionCompletion;
52 +     function GetJournalingActive(attachment: IAttachment): boolean; {attachment must be specified when multi-database transaction}
53 +
54 + 7. New IAttachment helper functions
55 +     function HasTable(aTableName: AnsiString): boolean;
56 +     function HasFunction(aFunctionName: AnsiString): boolean;
57 +     function HasProcedure(aProcName: AnsiString): boolean;
58 +     function GetAttachmentID: integer;
59 +     function GetCharSetID: integer;
60 +
61 + 8. IStatement: if the BatchRowLimit is set to maxint, the maximum possible buffer size
62 +   will be allocated for batch operations.
63 +
64 + 9. IStatement, IColumnMetaData and ISQLParam all now consistently provide:
65 +    function GetStatement: IStatement;
66 +    function GetTransaction: ITransaction;
67 +    function GetAttachment: IAttachment;
68 +
69 + 10. Internal: a more disciplined approach to the handling of Firebird.IReferenceCounted
70 +    interfaces.
71 +
72 + 11. New interface type: IFBNumeric. IFBNumeric is implemented in the unit FBNumeric
73 +    and concentrates all handling of Fixed Point numbers. New ISQLItem and ISQLParam
74 +    functions getAsNumeric and setAsNumeric allow for direct retrival and manipulation
75 +    of numerics without loss of precision.
76 +
77 + 12. TryStrToNumeric and NumericToDouble moved from IBUtils to FBNumeric.
78 +
79 + 13. ISQLParams new method "Clear"
80 +
81 + 14. Connection Info (e.g. ODS Version, Remote Protocol) now retrieved on first
82 +    request rather than on attachment connect.
83 +
84 + 15. IStatus.IBDataBaseErrorMessages now defaults to [ShowIBMessage]. This reflects the
85 +    fact that SQLCodes are soon to be deprecated. In the future, the other options
86 +    will be silently ignored if SQLCode support is not present in the Firebird
87 +    Client library.
88 +
89 + 16. ITransaction changes Rollback and Commit from procedures to functions:
90 +      function Commit(Force: boolean=false): TTrCompletionState;
91 +      function Rollback(Force: boolean=false): TTrCompletionState;
92 +
93 +    Specifically, this is to allow the functions to report back a failed commit or
94 +    rollback when Force = true. In the case, the transaction handle has been
95 +    released, while the transaction remains in limbo.
96 +
97 + 17. IAttachment ExecImmediate.
98 +    When the transaction parameters are provided as an array of const and the
99 +    statement fails, the transaction is rolledback (forced) before the exception
100 +    is raised.
101 +
102 + 18. In Firebird 3 and later API: the status vector is now a thread var, as was
103 +    already the case with the legacy API. Avoids problems when calling underlying
104 +    Firebird API in multiple threads.
105 +
106 + 19. IBUtils: TSQLXMLReader: "string" type changed to "AnsiString" for compatibility
107 +    reasons.
108 +
109 + 20. IDBInformation.DecodeVersionString now supported isc_info_firebird_version.
110 +
111 + 21. TSQLXMLReader: handle 'blob' as a reserved word
112 +
113 + 22. ISQLParam.SetAsVariant now accepts a vartype of varUString (UnicodeString).
114 +
115 +
116 + FBINTF Change Log  version          (1.3-3 Build 12935) Mon, 06 Dec 2021 23:17:13 +0000
117 +
118 + 1. Fix compile error with fpc trunk (3.3.1 and later), due to type change to tzname in "unix" unit.
119 +
120 + 2. Remove constraint in IAttachment.HasScollableCursors that returned false when
121 +   using remote protocol. Scrollable cursors with remote database expected to
122 +   be support for Firebird 4.0.1 onwards. Note: Firebird 4.0.0 will return
123 +   a not supported error.
124 +
125 + 3. IStatement: new function;
126 +    TStatementFlag = (stHasCursor,stRepeatExecute,stScrollable);
127 +    TStatementFlags = set of TStatementFlag;
128 +    function GetFlags: TStatementFlags;
129 +
130 + 4. Revised behaviour for IStatement.ExecuteQuery in order to preserve backwards
131 +   compatibility.
132 +   In Firebird 5, Update..Returning may returns multiple rows and hence the statemen
133 +   type changes from ExecProcedure to Select. So that ExecuteQuery can continue
134 +   to be used with Update...Retruning statements that return a singleton row,
135 +   instead of raising an exception when ExecuteQuery is used with a (SELECT) statement,
136 +   it will open the cursor and return the first row only.
137 +
138 + 5. ITransaction: new functions:
139 +    function GetIsReadOnly: boolean;
140 +    function GetTransactionID: integer;
141 +    function GetTrInformation(Requests: array of byte): ITrInformation; overload;
142 +    function GetTrInformation(Request: byte): ITrInformation; overload;
143 +
144 +   The latter two return the Transaction Information block. The first two extract
145 +   information the Transaction Information block
146 +
147 + 6. New function TSQLTokeniser.ReadCharacters
148 +   Used internally.
149 +
150 + 7. IStatement: GetProcessedSQL bug fix. No longer raises and error if SQL contains
151 +   parameter placeholders instead of named parameters.
152 +
153 + 8. ITransaction (Firebird 3 and later): An exception raised when freeing an underlying
154 +   transaction handle is now ignored if Rollback/Commit is called with Force=true
155 +
156 + 9. Tidy up of exception handling code. Under the legacy API, fb_interpret is now
157 +   used to get an IBError Message instead of isc_interprete.
158 +
159 + 10. Internal tidyup. Native code now used for decoding integers and the events
160 +    buffer. Avoids dependencies on fbclient functions isc_portable_integer,
161 +    isc_event_block and isc_event_counts.
162 +
163 + 11. New IAttachment function
164 +     function GetAttachmentID: integer;
165 +
166 + 12. Internal changes to TFBClientAPI, TFBAttachment and TFBTransaction and TFB30
167 +    subclasses to enable UDR support.
168 +
169   FBINTF Change Log  version          (1.3-2 Build 12889) Sun, 24 Oct 2021 13:49:28 +0100
170  
171   1. TFBClientAPI.GetProcAddr. Add check for nil reference.

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines