1 |
+ |
IBX Change Log version (2.6-2 Build 13992) Mon, 24 Jul 2023 09:26:32 +0100 |
2 |
+ |
|
3 |
+ |
1. Fixed repeated "type" keyword in IBBufferCursors. This may cause a compile error |
4 |
+ |
with later versions of fpc - later than 3.2.2. |
5 |
+ |
|
6 |
+ |
IBX Change Log version (2.6-1 Build 13985) Mon, 17 Jul 2023 14:16:41 +0100 |
7 |
+ |
|
8 |
+ |
1. Maintenance update of 2.6.0. This version is still at beta. |
9 |
+ |
|
10 |
+ |
2. Reverse out changes to DrawCellText signature in IBArrayGrid and IBDynamic Grid. |
11 |
+ |
See https://gitlab.com/freepascal.org/lazarus/lazarus/-/commit/53aaae9c5e2a5edac5b1d2f70739a8ef7b0a9623 |
12 |
+ |
|
13 |
+ |
3. ibxscript: When parsing a store procedure or function with a variable name |
14 |
+ |
enclosed in doublequotes, the double quotes are no longer removed. |
15 |
+ |
|
16 |
+ |
IBX Change Log version (2.6-0 Build 13976) Thu, 22 Jun 2023 13:49:22 +0100 |
17 |
+ |
|
18 |
+ |
NOTE: THIS VERSION RE-WRITES THE INTERNAL BUFFER MANAGER AND SHOULD BE CONSIDERED |
19 |
+ |
AS BETA SOFTWARE. EVEN THOUGH IT HAS PASSED ALL REGRESSION TESTS, IT CANNOT |
20 |
+ |
BE ASSUMED TO BE PRODUCTION READY UNTIL WIDER USE. PLEASE REPORT ANY |
21 |
+ |
ISSUES TO support@mwasoftware.co.uk |
22 |
+ |
|
23 |
+ |
1. Complete rewrite of internal buffer management in order to improve performance |
24 |
+ |
and maintainability. Highlights: |
25 |
+ |
|
26 |
+ |
* Extending the size of the buffer pool no longer has to copy the entire record |
27 |
+ |
cache. Instead, a new extent is simply added to the buffer pool. |
28 |
+ |
* A memory to memory copy of each display buffer now is avoided when scolling the |
29 |
+ |
dataset. |
30 |
+ |
* A separate set of buffers is now used for calculated fields. This avoids |
31 |
+ |
having to keep copies of calculated field values in the buffer cache. |
32 |
+ |
* Compact bitmaps are used to record null status and need to refresh in each |
33 |
+ |
buffer. |
34 |
+ |
* Display buffer type changed from PChar to TRecordBuffer in line with change of |
35 |
+ |
buffer type in FCL-DB. |
36 |
+ |
|
37 |
+ |
2. TIBUpdateSQL: changes to SQL text will close linked dataset if open. This is |
38 |
+ |
to ensure same behaviour as TIBDataset, TIBTable and TIBStoredProcedure. |
39 |
+ |
|
40 |
+ |
3. TField Provider Flags: pfRefreshOnInsert and pfRefreshOnUpdate are now supported. |
41 |
+ |
If either or both of these flags are set at design time (using the fields editor) |
42 |
+ |
then this forces a row refresh on respectively insert or update, or both, when the |
43 |
+ |
corresponding field is not present in an SQL RETURNING clause. |
44 |
+ |
|
45 |
+ |
4. TIBCustomDataset.FieldDefsFromQuery moved to a helper class (TFieldDefsMaker) in order to improve |
46 |
+ |
maintainability and readability and to add identification of primary key fields. |
47 |
+ |
|
48 |
+ |
5. TIBQuery, TIBDataset and TIBTable. Traditionally, IBX has implemented the Refresh method |
49 |
+ |
as a refresh of the current row. However, this is different behaviour to that described |
50 |
+ |
in the FPC documentation for TDataset.Refresh which is described as "refetches the data in |
51 |
+ |
the dataset from the underlying database, and attempts to reposition the cursor on |
52 |
+ |
the same record as it was". IBX now complies with the FPC definition of Refresh. |
53 |
+ |
|
54 |
+ |
6. A progammatic Row Refresh should no longer be required. |
55 |
+ |
Use Insert/Update... returning to refresh any fields that may change following an |
56 |
+ |
insert or update i.e. Identify fields on Insert only, Computed By, Blob and array fields |
57 |
+ |
on both. If there are any other fields (e.g. updated by triggers) set the appropriate ProviderFlag |
58 |
+ |
for the field at Design Time to force a row refresh if not in the returning clause. |
59 |
+ |
|
60 |
+ |
7. It should now be possible to insert a row into an empty unidirectional dataset. |
61 |
+ |
|
62 |
+ |
8. New TIBQuery, TIBDataSet and TIBTable property: BufferChunksInFirstBlock (default 50). |
63 |
+ |
This gives the number of buffers in the initial block for the buffer pool in |
64 |
+ |
bi-directional datasets. BufferChunks (default 1000) gives the number of buffers |
65 |
+ |
in subsequent buffer pool blocks. This avoids large and mostly unused memory allocations |
66 |
+ |
for small datasets. |
67 |
+ |
|
68 |
+ |
IBX Change Log version (2.5-1 Build 13927) Tue, 6 Dec 2022 23:13:00 +0000 |
69 |
+ |
|
70 |
+ |
1. IBCustomDataset: avoid problem with additions to TFieldType by using a subset instead. |
71 |
+ |
|
72 |
+ |
2. TIBDynamicGrid: change DrawCellText declaration to comply with laz 2.3.0 |
73 |
+ |
|
74 |
+ |
3. TIBArrayGrid: change DrawCellText declaration to comply with laz 2.3.0 |
75 |
+ |
|
76 |
+ |
IBX Change Log version (2.5-0 Build 13868) Fri, 29 Jul 2022 09:52:01 +0100 |
77 |
+ |
|
78 |
+ |
1. TIBTransaction: new properties |
79 |
+ |
property TransactionID: integer read GetTransactionID; |
80 |
+ |
property IsReadOnly: boolean read GetIsReadOnly; |
81 |
+ |
{published} |
82 |
+ |
property TransactionName: string read FTransactionName write SetTransactionName; |
83 |
+ |
|
84 |
+ |
2. IBCustomDataset: per row blob and array buffer cached clear before processing |
85 |
+ |
Insert or Update...Returning. This allows blobs and arrays to be returned |
86 |
+ |
by the statement. |
87 |
+ |
|
88 |
+ |
3. TSQLXMLReader moved from IBXScript to package fbintf unit IBUtils. |
89 |
+ |
|
90 |
+ |
4. TransactionName initialised to a newly generated GUID if empty. |
91 |
+ |
|
92 |
+ |
5. New unit: IBJournal. This provides the TIBJournal component which is a wrapper |
93 |
+ |
for the fbintf package's journaling capability. TIBJournal is used to set the |
94 |
+ |
file path and filename for the journal file and to Enabled (start journaling) and |
95 |
+ |
disable (stop journaling). See fbintf/doc/README.ClientSideJournaling.pdf for |
96 |
+ |
more information, and comments in IBJournal.pas. |
97 |
+ |
|
98 |
+ |
6. TIBDatabase.InternalTransaction is now a read only transaction. |
99 |
+ |
|
100 |
+ |
7. Bug fix: blob id no longer set to null on update when blob has not been |
101 |
+ |
retrieved. |
102 |
+ |
|
103 |
+ |
8. Row auto refreshed on update/insert if blob or array field updated and field |
104 |
+ |
not in a returning clause. |
105 |
+ |
|
106 |
+ |
9. ColumnCount moved from record buffer header to a single per dataset count. Reduces |
107 |
+ |
buffer overhead and avoids problem when refresh query has a different column |
108 |
+ |
count to select query i.e. incorrectly changing number of columns. |
109 |
+ |
|
110 |
+ |
10. IBExtract: support added for UDR Functions, Procedure and Trigger declarations. |
111 |
+ |
|
112 |
+ |
11. TIBDatabaseInfo. New property FirebirdVersion. This returns the current Firebird version |
113 |
+ |
string. Note that the Version property returns an InterBase compatible version string. |
114 |
+ |
|
115 |
+ |
12. IBExtract: ensure sql identifiers returned as a LIST are always quoted. |
116 |
+ |
|
117 |
+ |
IBX Change Log version (2.5-0 Build 12933) Mon, 29 Nov 2021 14:59:54 +0000 |
118 |
+ |
|
119 |
+ |
1. IBCustomDataset: Modify TISQL component now defaults to GoToFirstRecordOnExecute := true. |
120 |
+ |
This is for compatibility with Firebird 5 where Update...Returning can return |
121 |
+ |
a cursor. |
122 |
+ |
|
123 |
|
IBX Change Log version (2.4-3 Build 12886) Sat, 23 Oct 2021 14:58:30 +0100 |
124 |
|
|
125 |
|
1. Add try-..except check when initially loading library in IDE. This should |