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 419 by tony, Sat Aug 5 12:42:00 2023 UTC

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

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines