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 338 by tony, Wed Jun 9 12:07:56 2021 UTC vs.
Revision 359 by tony, Tue Dec 7 09:37:32 2021 UTC

#	Line 1 | Line 1
1	<	FBINTF Change Log  version          (1.2-1 Build 12546) Wed, 09 Jun 2021 11:57:29 +0100
1	>	FBINTF Change Log  version          (1.3-3 Build 12935) Mon, 06 Dec 2021 23:17:13 +0000
2	>
3	>	1. Fix compile error with fpc trunk (3.3.1 and later), due to type change to tzname in "unix" unit.
4	>
5	>	2. Remove constraint in IAttachment.HasScollableCursors that returned false when
6	>	using remote protocol. Scrollable cursors with remote database expected to
7	>	be support for Firebird 4.0.1 onwards. Note: Firebird 4.0.0 will return
8	>	a not supported error.
9	>
10	>	3. IStatement: new function;
11	>	TStatementFlag = (stHasCursor,stRepeatExecute,stScrollable);
12	>	TStatementFlags = set of TStatementFlag;
13	>	function GetFlags: TStatementFlags;
14	>
15	>	4. Revised behaviour for IStatement.ExecuteQuery in order to preserve backwards
16	>	compatibility.
17	>	In Firebird 5, Update..Returning may returns multiple rows and hence the statemen
18	>	type changes from ExecProcedure to Select. So that ExecuteQuery can continue
19	>	to be used with Update...Retruning statements that return a singleton row,
20	>	instead of raising an exception when ExecuteQuery is used with a (SELECT) statement,
21	>	it will open the cursor and return the first row only.
22	>
23	>	5. ITransaction: new functions:
24	>	function GetIsReadOnly: boolean;
25	>	function GetTransactionID: integer;
26	>	function GetTrInformation(Requests: array of byte): ITrInformation; overload;
27	>	function GetTrInformation(Request: byte): ITrInformation; overload;
28	>
29	>	The latter two return the Transaction Information block. The first two extract
30	>	information the Transaction Information block
31	>
32	>	6. New function TSQLTokeniser.ReadCharacters
33	>	Used internally.
34	>
35	>	7. IStatement: GetProcessedSQL bug fix. No longer raises and error if SQL contains
36	>	parameter placeholders instead of named parameters.
37	>
38	>	8. ITransaction (Firebird 3 and later): An exception raised when freeing an underlying
39	>	transaction handle is now ignored if Rollback/Commit is called with Force=true
40	>
41	>	FBINTF Change Log  version          (1.3-2 Build 12889) Sun, 24 Oct 2021 13:49:28 +0100
42	>
43	>	1. TFBClientAPI.GetProcAddr. Add check for nil reference.
44	>
45	>	2. IStatement: new methods:
46	>	procedure SetStaleReferenceChecks(Enable:boolean); {default true}
47	>	function GetStaleReferenceChecks: boolean;
48	>
49	>	In previous versions, stale reference checks were always enabled. This allows the
50	>	user to disable them on a per statement basis. Note this can risk out-of-date
51	>	statement BLR. See User Guide.
52	>
53	>	3. IBUtils: TSQLwithNamedParamsTokeniser now recognises a CASE...END block within a
54	>	stored procedure and hence avoids replacing named parameters within a containing
55	>	BEGIN..END block.
56	>
57	>	4. ISQLParam: using a string value to set an integer field with a scale factor of
58	>	zero is now treated as a special case to avoid the risk of floating point
59	>	rounding errors affecting pure integers.
60	>
61	>	5. ISQLParam:  Review and tidy-up of SetAsString for numeric types.
62	>
63	>	6. ISQLParam is now subclassed from IParamMetaData, which provides access to the mutable
64	>	SQL Parameter metadata (methods moved from ISQLParam).
65	>
66	>	7. ISQLParam: new method
67	>	function getColMetadata: IParamMetaData;
68	>	This instance of IParamMetaData returns the original column metadata which is unmutable.
69	>	Note: ISQLParam metadata can change after a parameter value has been set e.g when
70	>	setting a VARCHAR column to an integer value.
71	>
72	>	8. IStatement: can now set cursor name when opening a cursor. New overloaded method:
73	>	procedure Prepare(CursorName: AnsiString; aTransaction: ITransaction=nil); overload;
74	>	also IAttachment:
75	>	function Prepare(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer; CursorName: AnsiString=''): IStatement; overload;
76	>	function Prepare(transaction: ITransaction; sql: AnsiString; CursorName: AnsiString=''): IStatement; overload;
77	>	function PrepareWithNamedParameters(transaction: ITransaction; sql: AnsiString;
78	>	aSQLDialect: integer; GenerateParamNames: boolean=false;
79	>	CaseSensitiveParams: boolean = false; CursorName: AnsiString=''): IStatement; overload;
80	>	function PrepareWithNamedParameters(transaction: ITransaction; sql: AnsiString;
81	>	GenerateParamNames: boolean=false;
82	>	CaseSensitiveParams: boolean = false; CursorName: AnsiString=''): IStatement; overload;
83	>
84	>	9. Support for scrollable cursors added. New/updated methods:
85	>	IAttachment:
86	>	function HasScollableCursors: boolean;
87	>	function OpenCursor(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer;
88	>	Scrollable: boolean=false): IResultSet; overload;
89	>	function OpenCursor(transaction: ITransaction; sql: AnsiString; Scrollable: boolean=false): IResultSet; overload;
90	>	function OpenCursor(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer; Scrollable: boolean;
91	>	params: array of const): IResultSet; overload;
92	>	function OpenCursor(transaction: ITransaction; sql: AnsiString; Scrollable: boolean=false;
93	>	params: array of const): IResultSet; overload;
94	>	function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer; Scrollable: boolean;
95	>	params: array of const): IResultSet; overload;
96	>	function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer;
97	>	Scrollable: boolean=false): IResultSet; overload;
98	>	function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString; Scrollable: boolean=false): IResultSet; overload;
99	>	function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString; Scrollable: boolean;
100	>	params: array of const): IResultSet; overload;
101	>	function OpenCursorAtStart(sql: AnsiString; Scrollable: boolean=false): IResultSet; overload;
102	>	function OpenCursorAtStart(sql: AnsiString; Scrollable: boolean;
103	>	params: array of const): IResultSet; overload;
104	>	IStatement:
105	>	function OpenCursor(Scrollable: boolean; CursorName: AnsiString =''; aTransaction: ITransaction=nil): IResultSet; overload;
106	>	IResultSet:
107	>	function FetchPrior: boolean; {fetch previous record}
108	>	function FetchFirst:boolean; {fetch first record}
109	>	function FetchLast: boolean; {fetch last record}
110	>	function FetchAbsolute(position: Integer): boolean; {fetch record by its absolute position in result set}
111	>	function FetchRelative(offset: Integer): boolean; {fetch record by position relative to current}
112	>	function IsBof: boolean;
113	>
114	>	10. IArray: tidyup of SetAsString method to ensure correct handling of fixed point numbers.
115	>
116	>	11. IBUtils: TSQLTokeniser. CRLF now combined by low level parser into sqltEOL token. This
117	>	may be noticeable when a line separator occurs inside quoted text. The quoted text
118	>	output by the tokeniser will now use the platform specific lineEnding regardless
119	>	of whether the input uses the CRLF or LF as a line separator.
120	>
121	>	12. IStatement, IResultsSet: Support for scrollable cursors added (note: local databases only)
122	>
123	>
124	>	FBINTF Change Log  version          (1.3-1 Build 12776) Mon, 23 Aug 2021 11:09:33 +0100
125	>
126	>	1. Integer decodes in information blocks (e.g. IDBInfoItem) widened from 32 bit to 64-bit integers.
127	>
128	>	2. Support for inline blob encoding. Blob values pass using the "SetAsString" method
129	>	will now be encoded inline (i.e. as part of the parameter buffer) if they are
130	>	shorter than a pre-set limit. Longer values continue to be saved as blobs as a
131	>	separate server interaction. This is intended as a performance optimisation.
132	>
133	>	The pre-set limit defaults to 8192 bytes and can be inspected/modified using the new
134	>	IAttachment interface functions:
135	>
136	>	function GetInlineBlobLimit: integer;
137	>	procedure SetInlineBlobLimit(limit: integer);
138	>
139	>	3. Support for Firebird 4 IBatch interface added. This is largely transparent to the API
140	>	user as the functionality is embedded in the implementation of the IStatement
141	>	interface. Three new functions are defined:
142	>
143	>	procedure AddToBatch;
144	>	function ExecuteBatch(aTransaction: ITransaction=nil): IBatchCompletion;
145	>	procedure CancelBatch;
146	>	function GetBatchCompletion: IBatchCompletion;
147	>	function GetBatchRowLimit: integer;
148	>	procedure SetBatchRowLimit(aLimit: integer);
149	>
150	>	Also
151	>
152	>	function IsInBatchMode: boolean;        {true after call to execute(eaDefer)}
153	>	function HasBatchMode: boolean;         {true if and only if IBatch Supported}
154	>
155	>	For more information see the User Guide.
156	>
157	>	4. Default error message contents. Now aligned with User Guide section 10.2 i.e. error messages
158	>	provided with the EIBInterBaseError now include all three parts.
159	>
160	>	5. Firebird.pas and include files updated to Firebird 4.0.0
161	>
162	>	6. New IStatement method: function GetSQLStatementTypeName: AnsiString;
163	>	Returns SQL Statement type as a text string;
164	>
165	>	7. ISQLData.AsInteger and AsInt64 now use "Round" to convert a float field to
166	>	an integer instead of "trunc". This is for compatibility with TFloatField.AsInteger.
167	>
168	>	FBINTF Change Log  version          (1.2-1 Build 12552) Wed, 09 Jun 2021 13:05:40 +0100
169
170		1. Big fix for Firebird 4.0. A internal change in Firebird 4.0.0 from RC1 flushed out a
171		typo in FB30Statement.pas that caused an unknown parameter error.

Diff Legend

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