1 |
< |
IBX Change Log version (2.2-0) Wed, 28 Feb 2018 10:57:45 +0000 |
1 |
> |
IBX Change Log version (2.3-1) Thu, 25 Oct 2018 14:39:45 +0100 |
2 |
> |
|
3 |
> |
1. IBCustomDataset: replace deprecated function ValidUTF8String with call to |
4 |
> |
Utf8EscapeControlChars |
5 |
> |
|
6 |
> |
|
7 |
> |
IBX Change Log version (2.3-0) Mon, 16 Apr 2018 09:48:06 +0100 |
8 |
> |
|
9 |
> |
IMPORTANT: the source code tree has been re-organised for IBX 2.3. Please remove |
10 |
> |
all previous copies of the IBX source code tree before installing this release. |
11 |
> |
|
12 |
> |
The IBX packages used by most users have not changed, with one exception. The |
13 |
> |
IBServices unit has been moved to the package iblegacyServices.lpk. To continue |
14 |
> |
to use the IBServices unit in your applications, please add the iblegacyServices |
15 |
> |
to the list of dependencies. To do this, open the Project Inspector and select |
16 |
> |
Add->New Requirement and select "ibLegacyServices" from the list of available |
17 |
> |
packages. |
18 |
> |
|
19 |
> |
1. New unit IBXServices. The IBXServices unit is a re-architectured update of |
20 |
> |
the IBServices unit providing what is intended to be a clearer and easier to |
21 |
> |
use set of IB Services components. See Chapter 10 of the IBX User Guide for |
22 |
> |
more information and the guide to "Firebird Service Management Using IBX". |
23 |
> |
As indicated above, the legacy services components are still available and |
24 |
> |
provided in a separate package. There is no need to update working applications |
25 |
> |
using the older versions except for an additional package dependency. |
26 |
> |
|
27 |
> |
2. The IBX packages and source code tree have been re-organised in an attempt to |
28 |
> |
finally get rid of the "duplicate ppu" warnings. This re-organisation should |
29 |
> |
not affect existing users. Section 2.3 of the IBX User Guide describes the |
30 |
> |
new set of IBX packages. |
31 |
> |
|
32 |
> |
3. The ibx/examples/DBAdmin and the ibx/examples/services example have been |
33 |
> |
updated to use the new Services API components. |
34 |
> |
|
35 |
> |
4. The iblocal package has been updated to use the new Services API components. |
36 |
> |
|
37 |
> |
5. procedure SetAutoAdmin; in the new IBX Services this method is now a member of |
38 |
> |
TIBXSecurityService. It had been wrongly classified in the previous version |
39 |
> |
as a per database configuration item. It is global to a server and hence |
40 |
> |
correctly positioned as part of the Security Package. In the DBAdmin example, |
41 |
> |
the setting has moved to the mappings page. |
42 |
> |
|
43 |
> |
6. TIBXScript: IgnoreCreateDatabase added. If true then CREATE DATABASE statements |
44 |
> |
are ignored. |
45 |
> |
|
46 |
> |
7. TIBDatabase: DropDatabase now ensures that all transactions have been properly |
47 |
> |
closed before the database is dropped. Before and After Disconnect event handlers |
48 |
> |
are also fired. |
49 |
> |
|
50 |
> |
8. TIBTransaction: OnStartTransaction event now fires every time the transaction |
51 |
> |
is started and not just the first time. |
52 |
> |
|
53 |
> |
9. IBDataOutput: Use FormatFloat for all performance statistics to avoid platform |
54 |
> |
depenendency with comp type. |
55 |
> |
|
56 |
> |
10. IBDataOutput: select query data output is now sent to stdout instead of stderr. |
57 |
> |
|
58 |
> |
11. TIBDatabase: Remove regression. If a user login dialog changes the DatabaseName |
59 |
> |
then this is recognised and not ignored. |
60 |
> |
|
61 |
> |
12. TIBDataSet, TIBQuery, TIBTable: additions: |
62 |
> |
function GetRowsAffected(var SelectCount, InsertCount, UpdateCount, DeleteCount: integer): boolean; |
63 |
> |
function GetPerfStatistics(var stats: TPerfCounters): boolean; |
64 |
> |
property EnableStatistics: boolean read FEnableStatistics write SetEnableStatistics; |
65 |
> |
|
66 |
> |
GetRowsAffected returns the affected row counts from the last insert/update/delete |
67 |
> |
if EnableStatistics = true then GetPerfStatistics returns the current stats |
68 |
> |
counters for the select query. Note: stats accumulate after each fetch from |
69 |
> |
the database. To get total query cost after open, call the "Last" method |
70 |
> |
and then GetPerfStatistics. |
71 |
> |
|
72 |
> |
See ibx/examples/consolemode for an example of the use of GetPerfStatistics |
73 |
> |
|
74 |
> |
13. TIBExtract: Identity columns DDL. "Start with clause" now correctly encapsulated |
75 |
> |
in parenthesises. |
76 |
> |
|
77 |
> |
14. TIBExtract: new published property "AlwaysQuoteIdentifiers". If true then in dialect 3 |
78 |
> |
SQL identifiers are always delimited by double quotes. If false, then they are |
79 |
> |
only delimited if the identifier is a reserved word, contains lower case or special |
80 |
> |
characters. Set this property to true to retain previous behaviour. |
81 |
> |
|
82 |
> |
15. Insert SQL Property Editor. In Insert Returning Clause, Identity column names |
83 |
> |
are now inserted in double quotes if not Reserved Words or valid SQL Identifiers. |
84 |
> |
|
85 |
> |
16. TIBDataSet, TIBQuery, TIBTable: addition: |
86 |
> |
property MasterDetailDelay: integer {defaults to zero} |
87 |
> |
|
88 |
> |
When non-zero and the dataset is a detail table referencing a master table |
89 |
> |
through either a MasterSource (TIBTable) or a DataSource (TIBDataSet, TIBQuery) |
90 |
> |
then a synchronisation delay is added (in milliseconds) between the master |
91 |
> |
row changing and the detail dataset being re-opened. If the master dataset |
92 |
> |
is scrolled before the delay expires then the delay is reset. This can be used |
93 |
> |
to avoid performance overheads when scrolling through a large master dataset. |
94 |
> |
|
95 |
> |
Note: uses fptimer and hence requires a thread manager. Under Linux the |
96 |
> |
chreads unit must be included in your project. TTimer is not used in order |
97 |
> |
to avoid an LCL dependency. Requires FPC 3.0.2 or later. |
98 |
> |
|
99 |
> |
17. TIBExtract: User role grants now excluded when etGrantsToUser not specified |
100 |
> |
with Extract Option eoDatabase. |
101 |
> |
|
102 |
> |
18. TIBLookupComboEditBox: Workaround added for https://bugs.freepascal.org/view.php?id=33428 |
103 |
> |
When a deLayoutChanged event is reported on the ListSource dataset, the |
104 |
> |
combobox text is updated. This allows a listsource (detail) to be in a Master/Detail |
105 |
> |
relationship with the control's datasource (master). |
106 |
> |
|
107 |
> |
19. TIBExtract: Full BigInt value range now supported for Generators/Sequences. |
108 |
> |
|
109 |
> |
20. TIBExtract: Select Procedures (Procedure type 1) now include "SUSPEND;" clause in their |
110 |
> |
stubs. Pedantic fix really, as procedures output in dependency order anyway. |
111 |
> |
|
112 |
> |
21. TIBExtract: Package Headers and Package Bodies are now included in the extracted |
113 |
> |
DDL (Firebird 3 and later only). |
114 |
> |
|
115 |
> |
22. TIBLookupComboBox Autocomplete Fixes: |
116 |
> |
i. Only appended text is now selected after autocomplete. |
117 |
> |
ii. Uppercase keys no longer ignored for autocomplete. |
118 |
> |
iii. Retain Prefix case is now honoured correctly. |
119 |
> |
iv. When a DataSource is assigned, typing after autocomplete now extends prefix |
120 |
> |
before autocomplete performed. i.e. behaviour now the same as when |
121 |
> |
no DataSource assigned. |
122 |
> |
|
123 |
> |
23. TIBXScript: Single Line Comments starting with '--' are now ignored when occurring |
124 |
> |
between SQL statements. |
125 |
> |
|
126 |
> |
24. TIBExtract: New published property CaseSensitiveObjectNames. If false (default) then |
127 |
> |
ObjectNames are converted to upper case before matching against metadata object |
128 |
> |
names, unless the objectname is delimited by double quotes, in which case, the |
129 |
> |
double quotes are removed and the remaining string is used (unmodified) to match |
130 |
> |
against the metadata object name. |
131 |
> |
|
132 |
> |
If true then the ObjectName is used as is without modification and matched |
133 |
> |
against the metadata object name. No attempt is made to remove double quotes. |
134 |
> |
|
135 |
> |
25. TIBExtract: New Extract Types: etDatabaseTriggers and etDDLTriggers. When used |
136 |
> |
with eoTrigger, these extract types can be used to select only Database Triggers, |
137 |
> |
or DDL Triggers or both. Ignored when etTable or etTrigger included in Extract Types. |
138 |
> |
|
139 |
> |
26. TIBXScript: If an exception occurs during the processing of a statement, the |
140 |
> |
statement separate character is now reset to the default (';'). |
141 |
> |
|
142 |
> |
27. TIBDatabase: Reconnect method added and used by TIBXScript for reconnect. |
143 |
> |
|
144 |
> |
28. TIBXScript: Transaction is no longer automatically reactivated immediately processing |
145 |
> |
a commit or reconnect statement and instead activated only when next SQL statement |
146 |
> |
is executed. |
147 |
> |
|
148 |
> |
29. TIBSQL.HasField should no longer generate and exception when the field does not exist. |
149 |
> |
|
150 |
> |
30. TIBXScript: case insensitive regex now used when matching statements instead of |
151 |
> |
converting statement to upper case. |
152 |
> |
|
153 |
> |
31. TIBExtract: metadata comments now supported. New published property |
154 |
> |
IncludeMetaDataComments (default true). If true then metadata comments included |
155 |
> |
in extracted DDL. New Extract Object member eoComments. This may be used with |
156 |
> |
ExtractObject method to list all metadata comments. |
157 |
> |
|
158 |
> |
32. TIBExtract: ListObjectNames method added. |
159 |
> |
|
160 |
> |
33. Updated Database component editor to support additional connection string |
161 |
> |
types. |
162 |
> |
|
163 |
> |
IBX Change Log version (2.2-0) Wed, 28 Feb 2018 10:57:45 +0000 |
164 |
|
|
165 |
|
NOTE: THE LOCATIONS OF SOME OF THE UNIT DIRECTORIES HAS CHANGED FROM IBX 2.1. THIS IS TO |
166 |
|
AVOID DUPLICATE PPU WARNINGS. PLEASE REMOVE EARLIER VERSIONS OF IBX BEFORE INSTALLING THIS |