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

Comparing:
ibx/trunk/fbintf/changelog (file contents), Revision 349 by tony, Mon Oct 18 08:39:40 2021 UTC vs.
ibx/branches/journaling/fbintf/changelog (file contents), Revision 364 by tony, Tue Dec 7 13:30:09 2021 UTC

# Line 1 | Line 1
1 < FBINTF Change Log  version          (1.3-2 Build 12832) Fri, 15 Oct 2021 12:03:18 +0100
1 > FBINTF Change Log  version          (1.4-0 Build 12952) Tue, 07 Dec 2021 11:53:46 +0000
2 >
3 > 1. Client side journaling support added. Interface changes
4 >   IAttachment
5 >    function JournalingActive: boolean;
6 >    function GetJournalOptions: TJournalOptions;
7 >    function StartJournaling(aJournalLogFile: AnsiString): integer; overload;
8 >    function StartJournaling(aJournalLogFile: AnsiString; Options: TJournalOptions): integer; overload;
9 >    procedure StopJournaling(RetainJournal: boolean);
10 >
11 > 2. Transactions may now be given a local transaction name:
12 >   IFirebirdAPI
13 >     function StartTransaction(Attachments: array of IAttachment;
14 >             TPB: array of byte; DefaultCompletion: TTransactionCompletion=taCommit): ITransaction; overload;
15 >             TPB: array of byte; DefaultCompletion: TTransactionCompletion=taCommit;
16 >             aName: AnsiString=''): ITransaction; overload;
17 >     function StartTransaction(Attachments: array of IAttachment;
18 >             TPB: ITPB; DefaultCompletion: TTransactionCompletion=taCommit): ITransaction; overload;
19 >             TPB: ITPB; DefaultCompletion: TTransactionCompletion=taCommit;
20 >             aName: AnsiString=''): ITransaction; overload;
21 >
22 >   IAttachment
23 >    function StartTransaction(TPB: array of byte; DefaultCompletion: TTransactionCompletion=taCommit): ITransaction; overload;
24 >    function StartTransaction(TPB: ITPB; DefaultCompletion: TTransactionCompletion=taCommit): ITransaction; overload;
25 >    function StartTransaction(TPB: array of byte;
26 >                              DefaultCompletion: TTransactionCompletion=taCommit;
27 >                              aName: AnsiString=''): ITransaction; overload;
28 >    function StartTransaction(TPB: ITPB;
29 >                              DefaultCompletion: TTransactionCompletion=taCommit;
30 >                              aName: AnsiString=''): ITransaction; overload;
31 >
32 >  ITransaction
33 >    function GetTransactionName: AnsiString;
34 >    procedure SetTransactionName(aValue: AnsiString);
35 >
36 > 3. Additional Transaction information
37 >     ITPB.function AsText: AnsiString; {Returns TPB as a text string}
38 >
39 >   ITransaction
40 >     function GetDefaultCompletion: TTransactionCompletion;
41 >     function GetJournalingActive(attachment: IAttachment): boolean; {attachment must be specified when multi-database transaction}
42 >
43 > 4. New IAttachment helper functions
44 >     function HasTable(aTableName: AnsiString): boolean;
45 >     function GetAttachmentID: integer;
46 >
47 > FBINTF Change Log  version          (1.3-3 Build 12935) Mon, 06 Dec 2021 23:17:13 +0000
48 >
49 > 1. Fix compile error with fpc trunk (3.3.1 and later), due to type change to tzname in "unix" unit.
50 >
51 > 2. Remove constraint in IAttachment.HasScollableCursors that returned false when
52 >   using remote protocol. Scrollable cursors with remote database expected to
53 >   be support for Firebird 4.0.1 onwards. Note: Firebird 4.0.0 will return
54 >   a not supported error.
55 >
56 > 3. IStatement: new function;
57 >    TStatementFlag = (stHasCursor,stRepeatExecute,stScrollable);
58 >    TStatementFlags = set of TStatementFlag;
59 >    function GetFlags: TStatementFlags;
60 >
61 > 4. Revised behaviour for IStatement.ExecuteQuery in order to preserve backwards
62 >   compatibility.
63 >   In Firebird 5, Update..Returning may returns multiple rows and hence the statemen
64 >   type changes from ExecProcedure to Select. So that ExecuteQuery can continue
65 >   to be used with Update...Retruning statements that return a singleton row,
66 >   instead of raising an exception when ExecuteQuery is used with a (SELECT) statement,
67 >   it will open the cursor and return the first row only.
68 >
69 > 5. ITransaction: new functions:
70 >    function GetIsReadOnly: boolean;
71 >    function GetTransactionID: integer;
72 >    function GetTrInformation(Requests: array of byte): ITrInformation; overload;
73 >    function GetTrInformation(Request: byte): ITrInformation; overload;
74 >
75 >   The latter two return the Transaction Information block. The first two extract
76 >   information the Transaction Information block
77 >
78 > 6. New function TSQLTokeniser.ReadCharacters
79 >   Used internally.
80 >
81 > 7. IStatement: GetProcessedSQL bug fix. No longer raises and error if SQL contains
82 >   parameter placeholders instead of named parameters.
83 >
84 > 8. ITransaction (Firebird 3 and later): An exception raised when freeing an underlying
85 >   transaction handle is now ignored if Rollback/Commit is called with Force=true
86 >
87 > FBINTF Change Log  version          (1.3-2 Build 12889) Sun, 24 Oct 2021 13:49:28 +0100
88  
89   1. TFBClientAPI.GetProcAddr. Add check for nil reference.
90  
# Line 29 | Line 115 | FBINTF Change Log  version          (1.3
115     Note: ISQLParam metadata can change after a parameter value has been set e.g when
116     setting a VARCHAR column to an integer value.
117  
118 + 8. IStatement: can now set cursor name when opening a cursor. New overloaded method:
119 +    procedure Prepare(CursorName: AnsiString; aTransaction: ITransaction=nil); overload;
120 +   also IAttachment:
121 +    function Prepare(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer; CursorName: AnsiString=''): IStatement; overload;
122 +    function Prepare(transaction: ITransaction; sql: AnsiString; CursorName: AnsiString=''): IStatement; overload;
123 +    function PrepareWithNamedParameters(transaction: ITransaction; sql: AnsiString;
124 +                       aSQLDialect: integer; GenerateParamNames: boolean=false;
125 +                       CaseSensitiveParams: boolean = false; CursorName: AnsiString=''): IStatement; overload;
126 +    function PrepareWithNamedParameters(transaction: ITransaction; sql: AnsiString;
127 +                       GenerateParamNames: boolean=false;
128 +                       CaseSensitiveParams: boolean = false; CursorName: AnsiString=''): IStatement; overload;
129 +
130 + 9. Support for scrollable cursors added. New/updated methods:
131 +   IAttachment:
132 +    function HasScollableCursors: boolean;
133 +    function OpenCursor(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer;
134 +                             Scrollable: boolean=false): IResultSet; overload;
135 +    function OpenCursor(transaction: ITransaction; sql: AnsiString; Scrollable: boolean=false): IResultSet; overload;
136 +    function OpenCursor(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer; Scrollable: boolean;
137 +                             params: array of const): IResultSet; overload;
138 +    function OpenCursor(transaction: ITransaction; sql: AnsiString; Scrollable: boolean=false;
139 +                             params: array of const): IResultSet; overload;
140 +    function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer; Scrollable: boolean;
141 +                             params: array of const): IResultSet; overload;
142 +    function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer;
143 +                             Scrollable: boolean=false): IResultSet; overload;
144 +    function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString; Scrollable: boolean=false): IResultSet; overload;
145 +    function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString; Scrollable: boolean;
146 +                             params: array of const): IResultSet; overload;
147 +    function OpenCursorAtStart(sql: AnsiString; Scrollable: boolean=false): IResultSet; overload;
148 +    function OpenCursorAtStart(sql: AnsiString; Scrollable: boolean;
149 +                             params: array of const): IResultSet; overload;
150 +   IStatement:
151 +     function OpenCursor(Scrollable: boolean; CursorName: AnsiString =''; aTransaction: ITransaction=nil): IResultSet; overload;
152 +   IResultSet:
153 +    function FetchPrior: boolean; {fetch previous record}
154 +    function FetchFirst:boolean; {fetch first record}
155 +    function FetchLast: boolean; {fetch last record}
156 +    function FetchAbsolute(position: Integer): boolean; {fetch record by its absolute position in result set}
157 +    function FetchRelative(offset: Integer): boolean; {fetch record by position relative to current}
158 +    function IsBof: boolean;
159 +
160 + 10. IArray: tidyup of SetAsString method to ensure correct handling of fixed point numbers.
161 +
162 + 11. IBUtils: TSQLTokeniser. CRLF now combined by low level parser into sqltEOL token. This
163 +    may be noticeable when a line separator occurs inside quoted text. The quoted text
164 +    output by the tokeniser will now use the platform specific lineEnding regardless
165 +    of whether the input uses the CRLF or LF as a line separator.
166 +
167 + 12. IStatement, IResultsSet: Support for scrollable cursors added (note: local databases only)
168 +
169  
170   FBINTF Change Log  version          (1.3-1 Build 12776) Mon, 23 Aug 2021 11:09:33 +0100
171  

Diff Legend

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