ViewVC Help

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

root/public/ibx/branches/udr/changelog

Comparing:
ibx/trunk/fbintf/changelog (file contents), Revision 347 by tony, Mon Sep 20 22:08:20 2021 UTC vs.
ibx/branches/udr/changelog (file contents), Revision 371 by tony, Wed Jan 5 15:21:22 2022 UTC

#	Line 1 | Line 1
1	<	FBINTF Change Log  version          (1.3-2 Build 12798) Mon, 20 Sep 2021 12:42:46 +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	>	function StartJournaling(S: TStream; Options: TJournalOptions): integer; overload;
10	>	procedure StopJournaling(RetainJournal: boolean);
11	>
12	>	2. Transactions may now be given a local transaction name:
13	>	IFirebirdAPI
14	>	function StartTransaction(Attachments: array of IAttachment;
15	>	TPB: array of byte; DefaultCompletion: TTransactionCompletion=taCommit): ITransaction; overload;
16	>	TPB: array of byte; DefaultCompletion: TTransactionCompletion=taCommit;
17	>	aName: AnsiString=''): ITransaction; overload;
18	>	function StartTransaction(Attachments: array of IAttachment;
19	>	TPB: ITPB; DefaultCompletion: TTransactionCompletion=taCommit): ITransaction; overload;
20	>	TPB: ITPB; DefaultCompletion: TTransactionCompletion=taCommit;
21	>	aName: AnsiString=''): ITransaction; overload;
22	>
23	>	IAttachment
24	>	function StartTransaction(TPB: array of byte; DefaultCompletion: TTransactionCompletion=taCommit): ITransaction; overload;
25	>	function StartTransaction(TPB: ITPB; DefaultCompletion: TTransactionCompletion=taCommit): ITransaction; overload;
26	>	function StartTransaction(TPB: array of byte;
27	>	DefaultCompletion: TTransactionCompletion=taCommit;
28	>	aName: AnsiString=''): ITransaction; overload;
29	>	function StartTransaction(TPB: ITPB;
30	>	DefaultCompletion: TTransactionCompletion=taCommit;
31	>	aName: AnsiString=''): ITransaction; overload;
32	>
33	>	ITransaction
34	>	function GetTransactionName: AnsiString;
35	>	procedure SetTransactionName(aValue: AnsiString);
36	>
37	>	3. Additional Transaction information
38	>	ITPB.function AsText: AnsiString; {Returns TPB as a text string}
39	>
40	>	ITransaction
41	>	function GetDefaultCompletion: TTransactionCompletion;
42	>	function GetJournalingActive(attachment: IAttachment): boolean; {attachment must be specified when multi-database transaction}
43	>
44	>	4. New IAttachment helper functions
45	>	function HasTable(aTableName: AnsiString): boolean;
46	>	function HasFunction(aFunctionName: AnsiString): boolean;
47	>	function HasProcedure(aProcName: AnsiString): boolean;
48	>	function GetAttachmentID: integer;
49	>	function GetCharSetID: integer;
50	>
51	>	5. IStatement: if the BatchRowLimit is set to maxint, the maximum possible buffer size
52	>	will be allocted for batch operations.
53	>
54	>	6. IStatement, IColumnMetaData and ISQLParam all now consistently provide:
55	>	function GetStatement: IStatement;
56	>	function GetTransaction: ITransaction;
57	>	function GetAttachment: IAttachment;
58	>
59	>	7. Internal: a more disciplined approach to the handling of Firebird.IReferenceCounted
60	>	interfaces.
61	>
62	>	8. New interface type: IFBNumeric. IFBNumeric is implemented in the unit FBNumeric
63	>	and concentrates all handling of Fixed Point numbers. New ISQLItem and ISQLParam
64	>	functions getAsNumeric and setAsNumeric allow for direct retrival and manipulation
65	>	of numerics without loss of precision.
66	>
67	>	9. TryStrToNumeric and NumericToDouble moved from IBUtils to FBNumeric.
68	>
69	>	10. ISQLParams new method "Clear"
70	>
71	>	11. Support package fbudr added for support of User Defined Routines (UDRs).
72	>
73	>	12. Package layout changed with introduction of udr support. IB*.pas files moved from
74	>	root directory to "client".
75	>
76	>
77	>	FBINTF Change Log  version          (1.3-3 Build 12935) Mon, 06 Dec 2021 23:17:13 +0000
78	>
79	>	1. Fix compile error with fpc trunk (3.3.1 and later), due to type change to tzname in "unix" unit.
80	>
81	>	2. Remove constraint in IAttachment.HasScollableCursors that returned false when
82	>	using remote protocol. Scrollable cursors with remote database expected to
83	>	be support for Firebird 4.0.1 onwards. Note: Firebird 4.0.0 will return
84	>	a not supported error.
85	>
86	>	3. IStatement: new function;
87	>	TStatementFlag = (stHasCursor,stRepeatExecute,stScrollable);
88	>	TStatementFlags = set of TStatementFlag;
89	>	function GetFlags: TStatementFlags;
90	>
91	>	4. Revised behaviour for IStatement.ExecuteQuery in order to preserve backwards
92	>	compatibility.
93	>	In Firebird 5, Update..Returning may returns multiple rows and hence the statemen
94	>	type changes from ExecProcedure to Select. So that ExecuteQuery can continue
95	>	to be used with Update...Retruning statements that return a singleton row,
96	>	instead of raising an exception when ExecuteQuery is used with a (SELECT) statement,
97	>	it will open the cursor and return the first row only.
98	>
99	>	5. ITransaction: new functions:
100	>	function GetIsReadOnly: boolean;
101	>	function GetTransactionID: integer;
102	>	function GetTrInformation(Requests: array of byte): ITrInformation; overload;
103	>	function GetTrInformation(Request: byte): ITrInformation; overload;
104	>
105	>	The latter two return the Transaction Information block. The first two extract
106	>	information the Transaction Information block
107	>
108	>	6. New function TSQLTokeniser.ReadCharacters
109	>	Used internally.
110	>
111	>	7. IStatement: GetProcessedSQL bug fix. No longer raises and error if SQL contains
112	>	parameter placeholders instead of named parameters.
113	>
114	>	8. ITransaction (Firebird 3 and later): An exception raised when freeing an underlying
115	>	transaction handle is now ignored if Rollback/Commit is called with Force=true
116	>
117	>	9. Tidy up of exception handling code. Under the legacy API, fb_interpret is now
118	>	used to get an IBError Message instead of isc_interprete.
119	>
120	>	10. Internal tidyup. Native code now used for decoding integers and the events
121	>	buffer. Avoids dependencies on fbclient functions isc_portable_integer,
122	>	isc_event_block and isc_event_counts.
123	>
124	>	11. New IAttachment function
125	>	function GetAttachmentID: integer;
126	>
127	>	12. Internal changes to TFBClientAPI, TFBAttachment and TFBTransaction and TFB30
128	>	subclasses to enable UDR support.
129	>
130	>	FBINTF Change Log  version          (1.3-2 Build 12889) Sun, 24 Oct 2021 13:49:28 +0100
131
132		1. TFBClientAPI.GetProcAddr. Add check for nil reference.
133
#	Line 10 | Line 139 | FBINTF Change Log  version          (1.3
139		user to disable them on a per statement basis. Note this can risk out-of-date
140		statement BLR. See User Guide.
141
142	+	3. IBUtils: TSQLwithNamedParamsTokeniser now recognises a CASE...END block within a
143	+	stored procedure and hence avoids replacing named parameters within a containing
144	+	BEGIN..END block.
145	+
146	+	4. ISQLParam: using a string value to set an integer field with a scale factor of
147	+	zero is now treated as a special case to avoid the risk of floating point
148	+	rounding errors affecting pure integers.
149	+
150	+	5. ISQLParam:  Review and tidy-up of SetAsString for numeric types.
151	+
152	+	6. ISQLParam is now subclassed from IParamMetaData, which provides access to the mutable
153	+	SQL Parameter metadata (methods moved from ISQLParam).
154	+
155	+	7. ISQLParam: new method
156	+	function getColMetadata: IParamMetaData;
157	+	This instance of IParamMetaData returns the original column metadata which is unmutable.
158	+	Note: ISQLParam metadata can change after a parameter value has been set e.g when
159	+	setting a VARCHAR column to an integer value.
160	+
161	+	8. IStatement: can now set cursor name when opening a cursor. New overloaded method:
162	+	procedure Prepare(CursorName: AnsiString; aTransaction: ITransaction=nil); overload;
163	+	also IAttachment:
164	+	function Prepare(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer; CursorName: AnsiString=''): IStatement; overload;
165	+	function Prepare(transaction: ITransaction; sql: AnsiString; CursorName: AnsiString=''): IStatement; overload;
166	+	function PrepareWithNamedParameters(transaction: ITransaction; sql: AnsiString;
167	+	aSQLDialect: integer; GenerateParamNames: boolean=false;
168	+	CaseSensitiveParams: boolean = false; CursorName: AnsiString=''): IStatement; overload;
169	+	function PrepareWithNamedParameters(transaction: ITransaction; sql: AnsiString;
170	+	GenerateParamNames: boolean=false;
171	+	CaseSensitiveParams: boolean = false; CursorName: AnsiString=''): IStatement; overload;
172	+
173	+	9. Support for scrollable cursors added. New/updated methods:
174	+	IAttachment:
175	+	function HasScollableCursors: boolean;
176	+	function OpenCursor(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer;
177	+	Scrollable: boolean=false): IResultSet; overload;
178	+	function OpenCursor(transaction: ITransaction; sql: AnsiString; Scrollable: boolean=false): IResultSet; overload;
179	+	function OpenCursor(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer; Scrollable: boolean;
180	+	params: array of const): IResultSet; overload;
181	+	function OpenCursor(transaction: ITransaction; sql: AnsiString; Scrollable: boolean=false;
182	+	params: array of const): IResultSet; overload;
183	+	function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer; Scrollable: boolean;
184	+	params: array of const): IResultSet; overload;
185	+	function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer;
186	+	Scrollable: boolean=false): IResultSet; overload;
187	+	function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString; Scrollable: boolean=false): IResultSet; overload;
188	+	function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString; Scrollable: boolean;
189	+	params: array of const): IResultSet; overload;
190	+	function OpenCursorAtStart(sql: AnsiString; Scrollable: boolean=false): IResultSet; overload;
191	+	function OpenCursorAtStart(sql: AnsiString; Scrollable: boolean;
192	+	params: array of const): IResultSet; overload;
193	+	IStatement:
194	+	function OpenCursor(Scrollable: boolean; CursorName: AnsiString =''; aTransaction: ITransaction=nil): IResultSet; overload;
195	+	IResultSet:
196	+	function FetchPrior: boolean; {fetch previous record}
197	+	function FetchFirst:boolean; {fetch first record}
198	+	function FetchLast: boolean; {fetch last record}
199	+	function FetchAbsolute(position: Integer): boolean; {fetch record by its absolute position in result set}
200	+	function FetchRelative(offset: Integer): boolean; {fetch record by position relative to current}
201	+	function IsBof: boolean;
202	+
203	+	10. IArray: tidyup of SetAsString method to ensure correct handling of fixed point numbers.
204	+
205	+	11. IBUtils: TSQLTokeniser. CRLF now combined by low level parser into sqltEOL token. This
206	+	may be noticeable when a line separator occurs inside quoted text. The quoted text
207	+	output by the tokeniser will now use the platform specific lineEnding regardless
208	+	of whether the input uses the CRLF or LF as a line separator.
209	+
210	+	12. IStatement, IResultsSet: Support for scrollable cursors added (note: local databases only)
211	+
212	+
213		FBINTF Change Log  version          (1.3-1 Build 12776) Mon, 23 Aug 2021 11:09:33 +0100
214
215		1. Integer decodes in information blocks (e.g. IDBInfoItem) widened from 32 bit to 64-bit integers.

Diff Legend

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