ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/trunk/changelog
Revision: 345
Committed: Mon Aug 23 14:22:29 2021 UTC (2 years, 7 months ago) by tony
File size: 75921 byte(s)
Log Message:
Merged into public release

File Contents

# Content
1 IBX Change Log version (2.4-2 Build 12773) Mon, 23 Aug 2021 11:59:42 +0100
2
3 1. TIBDatabaseInfo: review and tidy-up of property types. Most widen to int64 with the
4 exception of those defined to be one byte wide e.g. DBImplementationNo.
5
6 2. TIBSQL: Batch Update/Insert support added.
7
8 3. TIBStoredProc: when generating the SQL, the value of the StoredProcName property
9 is no longer automatically converted to upper case when it is syntactically a
10 SQL Identifier. This is to support the use of stored procedures defined e.g.
11 as CREATE PROCEDURE "iCASE".
12
13 There could be a backwards compatibility issue when the StoredProcName was entered
14 manually at design time. That is not selected from the drop down list. If the
15 StoredProcName is entered in mixed case and the procedure was declared e.g. as
16 CREATE PROCEDURE iCASE, then the SQL generation will be incorrect. You should
17 ensure that the value of the StoredProcName is all upper case, unless it was
18 declared under dialect 3 and explicitly as mixed case (i.e. delimited by double
19 quotes).
20
21 Note that when a stored procedure name was declared delimited in double quotes,
22 as in the first example above, the value of the StoredProcName property must not
23 include the delimiters (double quotes).
24
25 4. IBXUpgradeConfFile: an exception is now raised if a patch file specified in
26 upgrade.conf was not found. This replaces silently ignoring the problem.
27
28 5. TIBLocalDBSupport: new property "SectionHeaderTemplate". This defaults to
29 'Version.%.3d' and is used to generate the section header names (for a given
30 version no.) in the upgrade.conf file.
31
32 IBX Change Log version (2.4-1 Build 12550) Wed, 23 Jun 2021 13:59:14 +0100
33
34 1. -c command line option added to fbsql example program. Used to set connection
35 character set.
36
37 IBX Change Log version (2.4-0 Build 12543) Mon, 22 Feb 2021 11:00:08 +0000
38
39 1. Firebird 4 support added.
40
41 2. New FB4 data types TIME WITH TIME ZONE, TIMESTAMP WITH TIME ZONE, DECFLOAT and
42 extended precision NUMERIC fields are supported.
43
44 3. TFmtBCDField is used to support access to DECFLOAT and extended precision NUMERIC fields.
45
46 4. TIBDateTimeField and TIBTimeField are introduced in support of TIMESTAMP WITH TIME ZONE
47 and TIME WITH TIME ZONE fields. These inherit from TDateTimeField.
48
49 5. IBExtract now supports FB4 enhancements:
50 - new data types as above
51 - Identity column extensions
52 - Default user role
53 - SQL Security clause for Database, Tables, Procedures, Functions and Triggers
54 - Internal Functions
55
56 6. IBExtract: new event: OnExtractLines.
57
58 7. IBExtract: revert create trigger to legacy syntax see Firebird CORE-6243, CORE-5545 and DOC-145
59
60 8. IBXServices: Server version no. parsing now allows any letter before major version number
61 and is no longer restricted to 'V' e.g. "LI-T4.0.0.1436 Firebird 4.0 Beta 1"
62
63 9. TIBDataSet and TIBQuery: new property TZTextOption. Used to determine the default
64 format for rendering a time zone.
65
66 10. TIBDataSet and TIBQuery: new property DefaultTZDate. Used to provide the default date
67 to convert TIME WITH TIME ZONE data type values to and from GMT.
68
69 11. Unit name IBTypes changed to IBInternals. Internal interfaces TIBGUIInterface and TIBTimerInf renamed to
70 IIBGUIInterface and IIBTimerInf respectively.
71
72 12. Constants: DPBPrefix and TPBPrefix moved to IB unit. DPBConstantNames and TPBConstantNames
73 now accessible as properties of TIBDatabase and TIBTransaction respectively.
74
75 13. String Fields: when a fixed character with (CHAR) field is returned, it is now
76 truncated to its fixed character width rather than being right padded with
77 white space to the maximum data size.
78
79 14. TIBTable.Empty table. In additional to deleting all records in the underlying
80 table, the internal buffers are now also flushed ensuring that the TIBTable is
81 also empty.
82
83 15. TBatchSQLStatementReader: Line buffer is now cleared on call to reset.
84
85 16. TIBXControlService descendents: DatabaseName may now be set using a database
86 connect string. The database name is extracted from the connect string.
87
88 17. DBControlGrid: Minor bug fixes. avoid AV on form closure, avoid black panel
89
90 18. TIBExtract: Data type of COMPUTED By columns is no longer included in SQL.
91
92 19. Local database on Linux and with legacy API and FB 2.5 embedded server: fixed problem with password
93 not being present as required.
94
95 20. IBTreeView split into DBTreeView and IBTreeView. This former is an IBX indepedent
96 version that can be customised to work with other database drivers.
97
98 21. ISQLMonitor: use platform specific LineEnding to delimit messages. Avoids
99 unnecessary CR at end of line on Unix platforms.
100
101 22. ISQLMonitor: Unix: Default semaphore timeout increased from 1 second to 10
102 seconds in order to reduce risk of message loss.
103
104 23. ISQLMonitor: read and write count statistics now available via:
105 property TIBSQLMonitor.ReadCount;
106 IIBSQLMonitorHook.GetWriteCount: integer;
107
108 24. ISQLMonitor tidy up and unit split. IPC functions moved to new unit IBIPC.
109
110 IBX Change Log version (2.3-5 Build 12350) Tue, 25 Aug 2020 16:11:02 +0100
111
112 1. TIBStringField: when a string value is read from a dataset buffer, if the
113 number of UTF8 characters exceeds the string size then string is truncated
114 to the maximum string size. This is usually a problem with fixed width columns
115 right padded with white space.
116
117 2. SQLFiltered and SQLFilterParams added to TIBQuery, TIBTable and TIBDataset.
118 If SQLFiltered is set then when a dataset is opened, each line in the
119 SQLFilterParams property is assumed to be a SQL condition clause and
120 ANDed into the Where clause of the SQL Select statement provided as a
121 dataset property. Each such SQL condition thus acts as an additional filter
122 on the dataset.
123
124 3. The Filtered property inherited from TDataset is no longer used for SQL (server
125 side filters).
126
127 4. IBLookupComboEditBox: Selection should no longer reset to start of text when
128 text matches complete entry.
129
130 5. TIBDataLink: Detail Dataset params not refreshed unless both master and detail
131 dataset are active (avoids risk of access violation if master is inactive)
132
133 6. TIBEvents: Registered property can now be set at design time even if database not open
134
135 7. TIBEvents: component now correctly re-initialised after call to UnregisterEvents.
136 This should prevent "spillover" of events between sessions.
137
138 8. TIBCustomDataset: GetNextRecord now called when reseting to first record of a unidirectional dataset.
139 This should ensure that the internal buffer is set up correctly and avoids
140 a duplicate initial row.
141
142 9. TIBStringField: DataSize now given as byte size of string less trailing any zero character.
143 That is, the DataSize should be the field size * character set width. The
144 value returned by DataSize is now the same as the Dataset buffer size reserved
145 for the field.
146
147 10. IBExtract: Tidyup of SQL generation. Avoid unnecessary double quotes.
148
149 11. TIBCustomDataset: Add checks on buffer sizes when copying data from row to field buffer
150 and vice-versa. This may result in an exception being raised (correctly) for
151 older programs when using dataset fields added to a form and the database has been
152 upgraded. For example, computed fields can change from 32-bit to 64-bit integers.
153 In such cases, the field needs to be deleted in the IDE fields editor and then
154 added back in.
155
156 12. IBCustomDataSet: CanInsert, CanEdit, CanDelete and CanRefresh updated to return
157 false if query contains only white space and not just empty.
158
159 12. IBCustomDataset: Blob data is now cleared when TDataSet.Cancel is called. This
160 should ensure that (e.g.) a TDBMemo is correctly refreshed after a dataset edit
161 is cancelled.
162
163 13. IBCustomDataset: SetArrayIntf should no longer cause an access violation if
164 called on a null field.
165
166 14. IBCustomDataSet: An access violation should no longer occur when calling CancelUpdates
167 results in an empty dataTC86 Client side Filtered Dataset 1 X
168 set.
169
170 15. IBCustomDataSet: OnUpdateError should now be called in all circumstances when
171 a cached update is applied and an exception is raised.
172
173 16. IBCustomDataSet: Avoid access violation when SetBookmarkData called with nil pointer.
174
175 17. Console Mode Local Database support: backup/restore should now work correctly.
176
177 18. Local Database Support: if an upgrade fails, a downgrade is now performed if
178 possible and an exception raised.
179
180 19. MinimumVersionNo added to Local Database Support. Database will not open if
181 below this version no. and upgrade not possible.
182
183 IBX Change Log version (2.3-4 Build 12041) Fri, 17 Apr 2020 14:00:32 +0100
184
185 1. TIBXDataSet and Generators: Generator Names that are not all upper case or
186 not SQL Identifiers are now supported.
187
188 2. TIBXScript: Set Generator is no longer rejected as unrecognised SQL and is
189 passed to the Firebird engine for execution.
190
191 3. TIBDataSet: Unidirectional datasets now give an error message if an attempt
192 is made to scroll back.
193
194 4. New unit: IBMessages.pas. Contains only messages used by IBX and not FBIntf
195
196 5. TIBLookupComboEditBox: When generating auto-complete SQL, the ListField is now
197 only enclosed in double quotes in SQL dialect 3 and when it needs to be.
198
199 6. TIBLookupComboEditBox: when the list source opens, the ListField name is now
200 validated. If no match is found in the list of field names and the database has
201 been opened in SQL Dialect 3, then the ListField Name is converted to upper case
202 if it then matches a field name. Otherwise, a Listfield not valid exception occurs.
203
204 7. IBGeneratoreditor.pas: Add missing parenthesis around "IS" statement for compliance
205 with fpc 3.2.
206
207 IBX Change Log version (2.3-3 Build 11512) Fri, 28 Dec 2018 10:04:17 +0000
208
209
210 1. New property for TIBDatabase and TIBXServicesConnection. This is "ConfigOverrides"
211 and is used to override the default settings in the client side "firebird.conf" This
212 includes "WireCompression" and "WireCrypt". The value of this property is a "TStrings".
213 Each line of the string list should be a setting in the same format as "firebird.conf".
214 For example "WireCompression = true" in order to request wire compression on the client side.
215
216 Note: explicit settings in the client side "firebird.conf" appear to take precedence
217 over settings given in TIBDatabase and TIBXServicesConnection. Many client side settings
218 also require a compatible setting in the server side "firebird.conf". For example
219 "WireCompression = true" must also be set in the server's "firebird.conf" for wire
220 compression to be used.
221
222 Whether or not WireCompression or WireCrypt are in use can be checked using the information
223 returned with the Client/Server protocol version. See ibx/examples/dbadmin and
224 ibx/examples/dbinfo for examples of how to display this information.
225
226 2. New property for TIBDatabase and TIBXServicesConnection: "WireCompression". This
227 is a "convenience" property. If set the "WireCompression=true" is added to the
228 ConfigOverrides. If unchecked then this setting is removed.
229
230 3. TIBExtract: 64-bit integer types are now correctly extracted as "BIGINT" and
231 not "INT64".
232
233 4. New published properties for TIBCSVDataOut, TIBInsertStmtsOut and TIBBlockFormatOut
234 These are:
235 property TimestampFormat: string;
236 property DateFormat: string;
237 property TimeFormat: string;
238
239 Respectively, these provide the date time format templates for SQL types: TIMESTAMP,
240 DATETIME and TIME. The format strings use the standard FPC date/time format
241 characters (see https://www.freepascal.org/docs-html/rtl/sysutils/formatchars.html).
242
243 If any of the above properties are set to an empty string, then the locale default
244 is used. This uses the ShortDateFormat and the LongTimeFormat. In timestamp, the
245 locale default is extended by appending '.zzz' to include milliseconds.
246
247 TIBCSVDataOut by default sets these properties to the empty string, while the other
248 two use: 'yyyy.mm.dd hh:nn:ss.zzz', 'yyyy.mm.dd' and 'hh:nn:ss.zzz' respectively.
249
250 5. New published property for TIBCSVDataOut:
251 property QuoteStrings: boolean (default true)
252
253 If false then strings are unquoted, otherwise, the QuoteChar property value is
254 used to delimit each and every string in the output.
255
256 6. New published properties for TIBCSVDataOut:
257 property FieldSeparator: string;
258 property HeaderSeparator: string;
259
260 Respectively, these provide the separator character(s) used to separate fields
261 in data and header rows. Both default to ','.
262
263 7. New published properties for TIBCSVDataOut and TIBBlockFormatOut:
264 TOnFormatTextString = procedure(sender: TObject; var TextString: string) of object;
265 property OnFormatTextString;
266
267 This event handler can be used to process text strings before they are included
268 in the output e.g. to replace unprintable characters with alternative strings.
269 This only applies to columns with an SQL Type of SQL_VARYING and SQL_TEXT.
270
271 8. TIBDataSet now raises an exception when ParamByName called with an invalid parameter name.
272 Uses "FindParam" if in order to find out if a parameter with a given name exists
273 and without raising and exception if it does not.
274
275 9. TIBQuery now uses IBX SQL Parser instead of the TParams SQL parser in order to ensure
276 consistency with SQL queries.
277
278 10. CaseSensitiveParameterNames property added to TIBSQL, TIBDataSet and TIBQuery.
279 When true, SQL statement parameter names are parsed case sensitive. Note for
280 TIBDataSet only applies to Select query.
281
282 11. IBEvents: removing a TIBEvent component from a form should no longer result in
283 an IDE exception.
284
285 12. LocalDBSupport: initial database creation should now work correctly
286 when the schema source is an sql file.
287
288 13. TIBCMLocalDBSupport: new event handler "property OnProgressEvent: TOnProgressEvent"
289 when defined, this handler will be called by the internal TIBXScript during
290 initial database creation when the schema source is an sql file and may be used
291 to provide a visual indication of progress in console mode.
292
293 14. TCustomIBLocalDBSupport: new public property "InOnCreateDB: boolean". This is set
294 to true while a new local database is being created and its schema populated.
295 Useful in (e.g.) TIBDatabase.OnAfterConnect handler to suppress actions
296 when the database is disconnected/connected during the create DB procedure.
297
298 15. TIBXScript: any User/password parameters found in a CREATE DATABASE statement
299 are now always ignored and replaced by the user name and password provided as
300 the login parameters for the TIBDatabase referenced from the TIBXScript. The
301 IgnoreCreateDatabase property still applies and the CREATE DATABASE statement is
302 completely ignored if this property is true.
303
304 16. Code tidyup in IBTreeView: Node properties initialisation moved from TIBTreeView.AddNodes
305 to TIBTreeView.Added. An OnAddition event handler is no longer needed to initialise
306 ImageIndex and SelectImageIndex values on AddNode.
307
308 17. TIBDatabase.Attachment and TIBXServicesConnection.ServicesIntf properties are now
309 read/write. This should enabled (e.g.) multiple instances of TIBDatabase to share
310 the same database connection.
311
312 18. TIBDataSet and TIBQuery now support the TDataSet "Filter" property.
313 if provided, this should be an conditional SQL expression suitable for
314 including in an SQL Select statement "where" clause. If non-empty and the
315 "Filtered" property is true then the SQL expression provided as the value of
316 the "Filter" property is "ANDed" with any existing condition statement
317 in the SQL statement's "Where" clause.
318
319 If the "Filter" property is set at run time, the "Filtered" property is true
320 and the dataset is already open, then the dataset is closed and re-opened automatically.
321
322 The "Filter" condition may include IBX style parameters. In which case, their
323 value must be set by the dataset's "OnBeforeOpen" event handler.
324
325 This is a public property for TIBDataSet and TIBQuery query and intended for
326 use at run time.
327
328 Note: The property is a published property of TIBTable. The TIBTable functionality
329 is unaffected by this change.
330
331 IBX Change Log version (2.3-2) Wed, 05 Dec 2018 12:19:23 +0000
332
333 1. Remove need to check for IsMultiThread by providing access to GUI timers via
334 IBGUIInterface. Note: master/detail delay timer does not apply to console
335 mode apps.
336
337 2. TIBCustomDataSet: SQLParser ignored if it does not contain a valid select
338 statement. This avoids problems if "Execute Block" is used as the Query.
339
340 3. IBSQLParser now uses the common SQL tokeniser from fbintf. This replaces the
341 internal SQL tokeniser routines.
342
343 4. IBSQLParser: new property NotaSelectStmt. Set to true if SQL fails to parse
344 as a select statement, with or without CTEs.
345
346 5. IBSQLParser: parser now recognises the "ROWS" clause.
347
348 6. TIBXScript now uses the common SQL tokeniser from fbintf. This replaces the
349 internal SQL tokeniser routines.
350
351 7. Fix error in TIBXScript processing of "set" statements. This avoids exceptions
352 being raised for valid set statements processed by a data formatter.
353
354 8. New published property for TIBDatabase and TIBXServicesConnection. This is
355 FirebirdLibraryPathName: string. If not empty it is used to explicitly specify
356 the path of the Firebird Library used by the database/services connection.
357
358 9. New read only public property for TIBDatabase and TIBXServicesConnection. This
359 is FirebirdAPI and returns the IFirebirdAPI interface used by the database/
360 services connection.
361
362 10.SQL Property editors now quote parameter names if "Quote identifier" is selected
363 or param name is not a valid SQL identifier.
364
365 11. IBLookupComboEditBox: In Lazarus 2.0, TDBLookupComboBox takes a more restrictive
366 view of whether the text box should be editable when no DataSource is specified.
367 TIBLookupComboEditBox has been updated to workaround this problem. As long as
368 ReadOnly is false, the text box is editable when no DataSource is specified.
369
370 12. AllowUseOfFBLIB is now set to "true" at design time. This is to allow use of
371 the FBLIB environment variable. If you do not want to permit this then you
372 must modify the Register procedure in the design/IBDBReg.pas unit to remove
373 this setting.
374
375 IBX Change Log version (2.3-1) Thu, 25 Oct 2018 14:39:45 +0100
376
377 1. IBCustomDataset: replace deprecated function ValidUTF8String with call to
378 Utf8EscapeControlChars
379
380 IBX Change Log version (2.3-0) Mon, 16 Apr 2018 09:48:06 +0100
381
382 IMPORTANT: the source code tree has been re-organised for IBX 2.3. Please remove
383 all previous copies of the IBX source code tree before installing this release.
384
385 The IBX packages used by most users have not changed, with one exception. The
386 IBServices unit has been moved to the package iblegacyServices.lpk. To continue
387 to use the IBServices unit in your applications, please add the iblegacyServices
388 to the list of dependencies. To do this, open the Project Inspector and select
389 Add->New Requirement and select "ibLegacyServices" from the list of available
390 packages.
391
392 1. New unit IBXServices. The IBXServices unit is a re-architectured update of
393 the IBServices unit providing what is intended to be a clearer and easier to
394 use set of IB Services components. See Chapter 10 of the IBX User Guide for
395 more information and the guide to "Firebird Service Management Using IBX".
396 As indicated above, the legacy services components are still available and
397 provided in a separate package. There is no need to update working applications
398 using the older versions except for an additional package dependency.
399
400 2. The IBX packages and source code tree have been re-organised in an attempt to
401 finally get rid of the "duplicate ppu" warnings. This re-organisation should
402 not affect existing users. Section 2.3 of the IBX User Guide describes the
403 new set of IBX packages.
404
405 3. The ibx/examples/DBAdmin and the ibx/examples/services example have been
406 updated to use the new Services API components.
407
408 4. The iblocal package has been updated to use the new Services API components.
409
410 5. procedure SetAutoAdmin; in the new IBX Services this method is now a member of
411 TIBXSecurityService. It had been wrongly classified in the previous version
412 as a per database configuration item. It is global to a server and hence
413 correctly positioned as part of the Security Package. In the DBAdmin example,
414 the setting has moved to the mappings page.
415
416 6. TIBXScript: IgnoreCreateDatabase added. If true then CREATE DATABASE statements
417 are ignored.
418
419 7. TIBDatabase: DropDatabase now ensures that all transactions have been properly
420 closed before the database is dropped. Before and After Disconnect event handlers
421 are also fired.
422
423 8. TIBTransaction: OnStartTransaction event now fires every time the transaction
424 is started and not just the first time.
425
426 9. IBDataOutput: Use FormatFloat for all performance statistics to avoid platform
427 depenendency with comp type.
428
429 10. IBDataOutput: select query data output is now sent to stdout instead of stderr.
430
431 11. TIBDatabase: Remove regression. If a user login dialog changes the DatabaseName
432 then this is recognised and not ignored.
433
434 12. TIBDataSet, TIBQuery, TIBTable: additions:
435 function GetRowsAffected(var SelectCount, InsertCount, UpdateCount, DeleteCount: integer): boolean;
436 function GetPerfStatistics(var stats: TPerfCounters): boolean;
437 property EnableStatistics: boolean read FEnableStatistics write SetEnableStatistics;
438
439 GetRowsAffected returns the affected row counts from the last insert/update/delete
440 if EnableStatistics = true then GetPerfStatistics returns the current stats
441 counters for the select query. Note: stats accumulate after each fetch from
442 the database. To get total query cost after open, call the "Last" method
443 and then GetPerfStatistics.
444
445 See ibx/examples/consolemode for an example of the use of GetPerfStatistics
446
447 13. TIBExtract: Identity columns DDL. "Start with clause" now correctly encapsulated
448 in parenthesises.
449
450 14. TIBExtract: new published property "AlwaysQuoteIdentifiers". If true then in dialect 3
451 SQL identifiers are always delimited by double quotes. If false, then they are
452 only delimited if the identifier is a reserved word, contains lower case or special
453 characters. Set this property to true to retain previous behaviour.
454
455 15. Insert SQL Property Editor. In Insert Returning Clause, Identity column names
456 are now inserted in double quotes if not Reserved Words or valid SQL Identifiers.
457
458 16. TIBDataSet, TIBQuery, TIBTable: addition:
459 property MasterDetailDelay: integer {defaults to zero}
460
461 When non-zero and the dataset is a detail table referencing a master table
462 through either a MasterSource (TIBTable) or a DataSource (TIBDataSet, TIBQuery)
463 then a synchronisation delay is added (in milliseconds) between the master
464 row changing and the detail dataset being re-opened. If the master dataset
465 is scrolled before the delay expires then the delay is reset. This can be used
466 to avoid performance overheads when scrolling through a large master dataset.
467
468 Note: uses fptimer and hence requires a thread manager. Under Linux the
469 chreads unit must be included in your project. TTimer is not used in order
470 to avoid an LCL dependency. Requires FPC 3.0.2 or later.
471
472 17. TIBExtract: User role grants now excluded when etGrantsToUser not specified
473 with Extract Option eoDatabase.
474
475 18. TIBLookupComboEditBox: Workaround added for https://bugs.freepascal.org/view.php?id=33428
476 When a deLayoutChanged event is reported on the ListSource dataset, the
477 combobox text is updated. This allows a listsource (detail) to be in a Master/Detail
478 relationship with the control's datasource (master).
479
480 19. TIBExtract: Full BigInt value range now supported for Generators/Sequences.
481
482 20. TIBExtract: Select Procedures (Procedure type 1) now include "SUSPEND;" clause in their
483 stubs. Pedantic fix really, as procedures output in dependency order anyway.
484
485 21. TIBExtract: Package Headers and Package Bodies are now included in the extracted
486 DDL (Firebird 3 and later only).
487
488 22. TIBLookupComboBox Autocomplete Fixes:
489 i. Only appended text is now selected after autocomplete.
490 ii. Uppercase keys no longer ignored for autocomplete.
491 iii. Retain Prefix case is now honoured correctly.
492 iv. When a DataSource is assigned, typing after autocomplete now extends prefix
493 before autocomplete performed. i.e. behaviour now the same as when
494 no DataSource assigned.
495
496 23. TIBXScript: Single Line Comments starting with '--' are now ignored when occurring
497 between SQL statements.
498
499 24. TIBExtract: New published property CaseSensitiveObjectNames. If false (default) then
500 ObjectNames are converted to upper case before matching against metadata object
501 names, unless the objectname is delimited by double quotes, in which case, the
502 double quotes are removed and the remaining string is used (unmodified) to match
503 against the metadata object name.
504
505 If true then the ObjectName is used as is without modification and matched
506 against the metadata object name. No attempt is made to remove double quotes.
507
508 25. TIBExtract: New Extract Types: etDatabaseTriggers and etDDLTriggers. When used
509 with eoTrigger, these extract types can be used to select only Database Triggers,
510 or DDL Triggers or both. Ignored when etTable or etTrigger included in Extract Types.
511
512 26. TIBXScript: If an exception occurs during the processing of a statement, the
513 statement separate character is now reset to the default (';').
514
515 27. TIBDatabase: Reconnect method added and used by TIBXScript for reconnect.
516
517 28. TIBXScript: Transaction is no longer automatically reactivated immediately processing
518 a commit or reconnect statement and instead activated only when next SQL statement
519 is executed.
520
521 29. TIBSQL.HasField should no longer generate and exception when the field does not exist.
522
523 30. TIBXScript: case insensitive regex now used when matching statements instead of
524 converting statement to upper case.
525
526 31. TIBExtract: metadata comments now supported. New published property
527 IncludeMetaDataComments (default true). If true then metadata comments included
528 in extracted DDL. New Extract Object member eoComments. This may be used with
529 ExtractObject method to list all metadata comments.
530
531 32. TIBExtract: ListObjectNames method added.
532
533 33. Updated Database component editor to support additional connection string
534 types.
535
536 IBX Change Log version (2.2-0) Wed, 28 Feb 2018 10:57:45 +0000
537
538 NOTE: THE LOCATIONS OF SOME OF THE UNIT DIRECTORIES HAS CHANGED FROM IBX 2.1. THIS IS TO
539 AVOID DUPLICATE PPU WARNINGS. PLEASE REMOVE EARLIER VERSIONS OF IBX BEFORE INSTALLING THIS
540 RELEASE.
541
542 NOTE: THE DBADMIN DEMO REQUIRES THAT THE MemDSLaz PACKAGE IS INSTALLED IN THE LAZARUS IDE.
543
544 1. IBExtract: Identity columns - add additional check for null column for generator name.
545
546 2. IBCustomDataSet: Insert and Modify (Update) queries now recognise and process SQL RETURNING clauses.
547 The main use for this is for Firebird 3 Identity columns (see IBXDocumentation 6.6.8 for further
548 information). However, this is also a very useful mechanism for returning updated computed by
549 column values. Values returned as a result of executing an Insert or Update statement
550 replace existing values in the current row for each corresponding column.
551
552 Previously, if a dataset's select query included read only (computed by) fields then
553 an automatic row refresh was performed after an insert or update query had been processed,
554 irrespective of the setting of the "ForcedUpdates" property. This has changed such
555 that an automatic refresh is no longer performed if an insert or update query contains
556 a returning clause that updates one or more fields on the current row. A full row
557 refresh is only performed if (a) ForcedRefresh is true or (b) the query does not return any
558 field values and the select query contains read only fields. Use of Insert/update
559 returning should be significantly more efficient than executing a refresh query.
560
561 This behaviour change is intended to be backwards compatible and there should be no need to change
562 existing programs, other than to improve performance by using the new capability.
563
564 3. IBCustomDataSet: DELETE...RETURNING queries are now also recognised. However, as
565 they are called when the dataset row is being deleted, there is no value in
566 updating the current record from the query result. Instead, a new event handler
567 "OnDeleteReturning" is provided. If a DELETE...RETURNING query is execute and
568 an OnDeleteReturning event handler is provided then it is called with the IResults returned
569 by the query. The event handler can then interrogate the query results and
570 perform whatever action is necessary. For example to confirm, to the user,
571 the deletion of a row with the returned values.
572
573 4. TIBTable: generated Insert and Update SQL now include a RETURNING clause for
574 any Computed By or Identity Columns. The IBTables example has been updated to
575 illustrate the computation of the employee Full Name on update.
576
577 5. TIBTable: The GeneratorField property is now published.
578
579 6. The InsertSQL property editor now shows Firebird 3 Identity columns separate from the Field List.
580 When InsertSQL is generated, the Identity columns are not included in the list of values to
581 be inserted. A RETURNING clause is added to the insert statement to return the value of
582 each Identity column after the insert is executed.
583
584 7. The Modify Property Editor now generates Update SQL with Computed By fields in Update..Returning clause.
585 Similarly Insert Property Editor now generates Insert SQL with Computed By fields in
586 Insert..Returning clause.
587
588 8. TIBGenerator: small performance improvement by not preparing query each time
589 a new value is generated.
590
591 9. TIBSQL: Free resources when transaction changed - ensures new transaction is used.
592
593 10. Property editors will now sync table name to a System Table when "Include System
594 Tables" is selected and the query is for a System Table.
595
596 11. Minor Performance improvement to handling of Date/Time types in IBX datasets. Field
597 values are no longer converted to milliseconds from TDateTime and then back again
598 to TDateTime (the conversion to milliseconds is the default TDataset approach).
599
600 12. Property Editors handling of Stored Procedures.
601 * Select and Refresh: only show a list of stored procedures that return multiple rows (proc type 1) and
602 which have a non-empty list of output parameters (i.e. stored procedures that may be used in a select
603 query).
604 * Modify and Insert: only show a list of stored procedures that return at most a singleton row (proc type 2).
605
606 13. IBStoredProc: Now supports Firebird 3 Package Names. A new published property PackageName
607 can be used to select a package. If non-empty, the stored procedure name is
608 expected to be a stored procedure defined in the specified package and the
609 generated SQL will be as required for a stored procedure located in a package.
610
611 14. Select, Refresh, Insert, Modify, Delete and TIBSQL SQL Property Editors now include
612 a "Package Name" drop down box to allow selection of a Firebird 3 Package from
613 which a stored procedure can be selected. With no package name selected, non-package
614 stored procedures are listed.
615
616 15. TIBXScript: turn off database login prompt when reconnecting - this avoids prompting
617 for password on reconnect.
618
619 16. TIBDatabase: use IAttachment for connection default character set id, code page
620 and character set name.
621
622 17. TIBDatabaseInfo: cache ODS Version information on first request in order to minimise
623 DB info lookups"
624
625 18. IBExtract: now supports DDL Triggers and Grants to DDL objects.
626
627 19. Add a property Editor for TIBUpdate.RefreshSQL.
628
629 20. IBUpdate: Ignore non-data (e.g. calculated) fields when assembling list of input
630 parameters. This stops an exception being raised when the field cannot be
631 located in the record buffer.
632
633 21. Property Editors now automatically include System Tables when opened and when the query table
634 is a System Table.
635
636 22. IBServices: SQRB and SRB buffers are now reset when service query throws an exception.
637 This avoids errors due to a stale SQRB or SRB being used for the next query.
638
639 23. IBServices: Service attach parameters now include "expected_db". This is used to
640 add the SPB item isc_spb_expected_db. This names a database using
641 an alternative Security Database (FB3 onwards) and allows (e.g. backup/restore) using such a
642 database. examples/services re-written to illustrate use of "expected_db".
643
644 24. IBServices: TIBControlAndQueryService.WriteNextChunk no longer ignores isc_info_svc_timeout.
645 This avoids truncated backups when the server returns a timeout (busy) response.
646
647 25. TIBDatabase: isc_dpb_page_size now supported as a database parameter when using TIBDatabase.CreateDatabase.
648
649 26. TIBDatabase: DatabaseName property may now be prefixed by $TEMP$ or $DATADIR$ for local
650 databasenames. These are respectively expanded to the local system's temp directory
651 (including trailing delimiter) or to a prescribed data directory (including
652 trailing delimiter). Under Unix systems the data directory is a hidden directory
653 in the user's home directory. The hidden directory name is either the string returned
654 from the SysUtils "Vendor Name" or "IBX" if empty. In either case prefixed by a '.'.
655 Under Windows, the directory is the same as the Data Directory as decribed
656 above but instead prefixed by the User's application data path. These may be
657 used to improve application portability for Personal Databases.
658
659 27. TIBTable: FieldDefs property is no longer published. Due to the use of TIBFieldDef
660 this has not worked for a long time and is not useful either. FieldDefs should be
661 managed using the Fields Editor as with any other dataset. To access the fields
662 editor for a TIBTable component, double click on the component. The fields editor
663 is then displayed.
664
665 28. TIBDatabaseInfo: new properties/function
666 * DateDBCreated (returns date/time database created)
667 * TransactionCount (returns no. of active transactions)
668 * GetDatabasePage(PageNo: integer) (returns contents of specified database page - SYSDBA only).
669 * PagesFree (Firebird 3 or later)
670 * PagesUsed (Firebird 3 or later)
671 * Encrypted (returns true if database encrypted. (Firebird 3.0.3 or later only)
672 * EncryptionKeyName (returns the name of the encryption key if any (Firebird 3.0.3 or later only)
673
674 29. IBServices classes now provided the decoded release number in the (array) property ServerVersionNo.
675
676 30. TIBSecurityService now supports display/modification of the User Admin Role (Firebird 2.5 and later).
677
678 31. TIBConfigService now has a procedure SetAutoAdmin(Value: boolean) to enable/disable
679 the automtic mapping of privileged OS users to the RDB$ADMIN role (Firebird 2.5 and later).
680
681 32. TIBBackupService: New Option - NoDBTriggers equivalent to -nodbtriggers switch introduced
682 in the gbak utility at V.2.1 to prevent database-level and transaction-level triggers from
683 firing during backup and restore.
684
685 33. Both TIBBackupService and TIBRestoreService now support backup/restore statistics options
686 for verbose output using the new property "StatisticsRequested".
687 see https://firebirdsql.org/file/documentation/release_notes/html/en/2_5/rnfb25-util-gbak.html#rnfb25-util-gbakstats
688
689 34. TIBRestoreService: now supports new options RestoreMetaDataOnly (Firebird 2.5 and later).
690
691 35. TIBOnlineValidationService component added to the IBServices and the "Firebird Admin"
692 palette. This uses the online validation feature added in Firebird 2.5. The
693 services's properties enable inclusion/exclusion of tables and indexes using
694 regular expressions. See.
695 https://firebirdsql.org/file/documentation/release_notes/html/en/2_5/rnfb25-apiods-api.html#rnfb25-apiods-api-onlinevalidation
696
697 36. IBServices: procedure TIBConfigService.SetNoLinger added to set no linger
698 option on a database.
699
700 37. TIBCustomService: Assign method implemented to allow copying of service login
701 context between service API components. "Detach" method now only detaches
702 service when last reference to the service interface detaches. Tidy up of
703 code for SetActive and Attach methods including password hiding.
704
705 38. TIBDatabase: new properties: AuthenticationMethod and RemoteProtocol. Read only
706 and used to determine the auth method and protocol used for the connection.
707
708 39. TIBDatabase: ensure that SQLDialect setting is used when creating a database using
709 a Create Database Statement generated by IBX.
710
711 40. All IBServices now have an additional published property "PortNo". This may
712 be set to a non-standard port number when necessary. If zero then the default
713 port number is used.
714
715 41: TIBLookupComboeditBox: Ensure dataset updated when change selected with the keyboard
716 and not just the mouse.
717
718 42. TIBCustomDataset: reopen query if already active when a TIBControlLink is added.
719
720 43. TIBTreeview: new ImageIndexField and SelectedIndexField Property allows the
721 image index and selected image index for each node to be set from a database field.
722
723 44. TIBExtract: new extract type (etGrantsToUser) for use with eoDatabase. If included
724 then database schema includes grants to all users. If not present then the
725 only user grants included are those to User PUBLIC.
726
727 45. TIBTreeView: performance improvement. When expanding include both expanded node
728 and child nodes in dataset.
729
730
731 IBX Change Log version (2.1-0) Fri, 15 Dec 2017 12:20:11 +0000
732
733 1. IBCustomDataset: Minor change of PChar to PByte for compatibility with fbintf
734 changes.
735
736 2. IBCustomDataset: Fixed use of incorrect datasize in TIBStringField.SetAsString.
737 Bug could result in truncated multi-byte character set values.
738
739 3. Changes consequential on moving fbintf character set utility functions from
740 IFirebirdAPI to IAttachment.
741
742 4. Avoid "Object is nil" error when opening a database with DefaultSystemCodePage = true
743
744 5. IBLookupComboEditBox: avoid race condition when autocompleting text that occasionally
745 results in autocomplete ignoring prefix text.
746
747 6. IBLookupComboEditBox: Ensure that cursor is not reset to start of text when
748 entering a new name into the text box.
749
750 7. IBCustomDataset: ensure that TIBStringField uses the field size reported by
751 Firebird rather than recomputing it.
752
753 8. Property Editor positioning tidy up: All IBX Property editors should now be
754 screen centre. Previously some were "poDesigned" which may be inappropriate
755 for multi monitor desktops.
756
757 10. TIBTreeView.FindNode: protect against error if zero length path or empty tree node.
758
759 11. TIBTransaction: On Force Disconnect do not raise an exception when problem ending
760 a transaction and always reset the object.
761
762 12. TIBQuery tidyup: remove unnecessary call to GetAffectedRows.
763
764 13. TIBXScript: Allow for override of database filename in Create Database statements.
765
766 14. IBLocaldb: Support initialisation of the database from an SQL script in addition
767 to a gbak format archive.
768
769 15. IBLocaldb: fix problem that stopped the OnSharedDataDir event from being recognised.
770
771 16. IBLocaldb: Drop database if error creating an empty database.
772
773 17. TIBTreeView: improve performance when selecting node - avoid refreshing dataset
774 unless selected node not in current dataset.
775
776 18. IBServices: SetDBParams method moved from TCustomIBLocalDBSupport (in IBLocalDB package)
777 to TIBCustomService, and IBlocalDB code tidy up.
778
779 19. IBTreeView: Initialise TIBTreeNode KeyValue to null to avoid unpredictable
780 behaviour due to uninitialised variable.
781
782 20. IBServices: Correct encoding of isc_spb_prp_write_mode in TIBConfigService from
783 integer to byte. Ditto isc_spb_prp_reserve_space and isc_spb_prp_access_mode.
784
785 21. IBSQL: When Database changed ensure that all resources are freed.
786
787 22. IBCustomDataset: When database changed ensure that queries an unprepared.
788
789 23. SQL Property Editors now use SynEdit with SQL Highlighter. New features include:
790 * Line Wrap on SQL Token boundaries (on user command)
791 * auto-complete table names in drop down list of table names
792 * Double click on tablename or field name adds to SQL text
793
794 24. IBDataOutput: print statistics using float (%f) format instead of decimal (%d).
795
796 25. IBTreeView: Call to FindNode: param type change from "array of Variant" to
797 TVariantArray. Seems to avoid memory corruption in Windows (probably a
798 workaround for a problem in fpc 3.0.4 win64).
799
800 26. IBDatabaseInfo: Code tidy up. Add check for database not assigned or not open.
801
802 27. IBDatabaseInfo: Remove memory leak when accessing database operation counts.
803
804 IBX Change Log version (2.0-2) Fri, 24 Feb 2017 12:17:53 +0000
805
806 1. TIBDatabase.CreateDatabase: extract full DB Name from SQL using reg ex in order to
807 include remote system name.
808
809 2. TIBExtract: No longer include comment header and COMMIT statement for empty
810 tables when data included in output.
811
812 3. Profiling: IBSQL now has conditional compilation flags to enable query performance
813 and timing information to be written to stdout. This may be used to locate
814 performance bottlenecks.
815
816 4. SQLParser: only call "OnChanging" event handler when value is different.
817
818 5. IBDynamicGrid: Update handling of navigation keys for a TDateEdit
819
820 6. IBCustomDataset: Set internalunprepared flag when transaction ends. This ensures
821 that BindFields is called when the query is next activated. Avoids FieldName
822 not found error.
823
824 7. IBUpdate: This is a new IBX component similar to TIBUpdateSQL. It is more general
825 purpose and allows the programmer to define any action they want for Update, Insert
826 or Delete. This may be complex SQL (similar to a Trigger), application specific
827 filtering of updates, or use of statements such as Grant or Revoke instead of
828 normal DML. See User Manual for more information.
829
830 IBX Change Log version (2.0-1) Mon, 09 Jan 2017 15:31:49 +0000
831
832 1. TIBEvents: Fix uninitialised variable that could result in lost events.
833
834 2. TIBExtract: Added support for FB3 "USAGE" privilege.
835
836 3. TIBExtract: data formatted as Charset set "octets" is now output using
837 hexadecimal notation.
838
839 4. TIBExtract: Binary Blobs and array data can now be embedded in INSERT statements
840 using a simple XML format.
841
842 5. TIBExtract: extract of individual Triggers and Stored Procedures can now include
843 grants to these objects.
844
845 6. TIBExtract: Stored Procedures and Views output in dependency order to avoid
846 dependency problems restoring complex databases.
847
848 7. TIBXScript: This component has been restructured to allow for the processing of
849 embedded XML in INSERT statements and to support interactive sources in addition
850 to non-interactive data sources such as files.
851
852 8. TIBXScript: CREATE DATABASE, DROP DATABASE, CONNECT statements are now supported.
853
854 9. TIBXScript: ISQL compatiable Set statements are now supported:
855 SET SQL DIALECT
856 SET TERM
857 SET AUTODDL
858 SET BAIL
859 SET ECHO
860 SET COUNT
861 SET STATS
862 SET NAMES <character set>
863
864 10. IBVersion unit added to hold current IBX Version Number information.
865
866 11. TIBExtract: Use character rather than byte length for VarChar procedure arguments.,
867 and domain definitions.
868
869 12. TIBExtract: Triggers now use SQL2003 syntax and database and transaction triggers
870 fully supported.
871
872 13. TIBExtract: when a database dump includes data, the generator values are now also set.
873
874 14: IBSQLEdit: Unit LCLPlatformDef added to uses clauses for lazarus 1.7 and later.
875
876 IBX Change Log version (2.0-0) Tue, 06 Dec 2016 10:33:44 +0000
877
878 See also doc/IBX4LazarusGuide.pdf for important information on
879 upgrading to IBX2.
880
881 1. Size property of TIBStringField is now the width in characters of the field
882 and not the byte length. This applies only to multi-byte character sets such
883 as UTF8. The original approach aligned with TStringField. However, the TStringField
884 code is not recognised as a bug and hence this change to align the behaviour.
885 The TStringField change is expected in fpc 3.2.0.
886
887 2. A new property AutoFieldSize: boolean has been added to TIBStringField. When
888 true (default) then Size property value saved in the lfm is ignored. Size is
889 always set from the dynamic information read from the database. It is unclear
890 why anyone would want to override this and set Size to false.
891
892 3. ibxscript: should now handle correctly a Case..End statement within a procedure
893 block.
894
895 4. IBDatabase: new property - CreateIfNotExists. If true and database does not
896 exist when an attempt is made to connect to it (run time only) then an attempt
897 is made to create the database.
898
899 5. IBDatabase: new event - OnCreateDatabase. This event is called after a database
900 has been successfully created as a result of a call to CreateDatabase or when
901 creating a database after it was found not to exist.
902
903 6. DBControlGrid: a race condition could result in the wrong row image being
904 written to the cache. This has been avoided by a trip round the message
905 loop before rendering the row image.
906
907 7. DBControlGrid: It is strongly recommended not to open the source DataSet for
908 a DBControlGrid during a Form's "OnShow" event handler. Under GTK2 this is
909 known to risk corrupt rendering of row images when the control is first
910 displayed. If necessary use "Application.QueueAsyncCall" to delay opening
911 of the dataset (see DBControlGrid examples) until the Form's Window has been created.
912
913 8. DBControlGrid & IBDynamicGrid: Navigation keys should now work correctly with
914 a TDateEdit control located on an editor panel.
915
916 9. TIBExtract: brought up-to-date plus many bug fixes.
917
918 10. DBControlGrid: Removed memory leak when updating rows.
919
920 11. TIBCMLocalDBSupport: fixed invalid free on upgrade.
921
922 IBX Change Log version (1.4-3) Thu, 22 Sep 2016 18:10:15 +0100
923
924 1. IBCustomDataset: When calling SetCodePage, no longer request transliteration
925 when target codepage is CP_NONE. This is a workaround for
926 http://bugs.freepascal.org/view.php?id=30622.
927
928 2. DBLog option removed from TIBStatisticalService - not supported by server
929 since Firebird 1.5.
930
931 3. ibxscript: An error is no longer generated for "on commit preserve rows" or
932 similar.
933
934 4. IBCodePage: updated mapping between codepages and character id.
935
936 5. ftWideString and ftWideMemo withdrawn. There is no UTF16 character set in
937 Firebird. Character sets with a char width of two are not UTF16.
938
939 6. Strings received from the database are now always transliterated into UTF8
940 regardless of the database character set or connection character set. This
941 is for compatibility with the LCL.
942
943 IBX Change Log version (1.4-2) Thu, 22 Sep 2016 15:25:27 +0100
944
945 1. IBBlob: Defer reading of blob until read method called. This avoids having to
946 read in an entire blob just to get the size of the blob. General performance
947 improvement when opening datasets containing blobs.
948
949 2. Clearing a Blob now sets the corresponding field's modified flag.
950
951 3. IBLookupCombo: When not performing auto-complete, original query sort order
952 is now used.
953
954 4. IBDynamicGrid: Add OnSelectEditor event. Allows editor panel to be dynamically
955 determined.
956
957 5. IBDynamicGrid: Recompute column widths after dataset closed and re-opened.
958
959 6. IBLookupCombo: LazUTF8 added to uses clause to avoid compilation problems post
960 lazarus 1.6.0
961
962 7. IBControls. Removed "runtime" from list of paths to avoid "multiple packages"
963 compilation error.
964
965 IBX Change Log version (1.4-1) Tue, 17 May 2016 09:14:51 +0100
966
967 1. No character set specified for connection: when a text blob is retrieved, the
968 character set is determined by looking up the native character set using then
969 Firebird API. Otherwise a text mode blob is assumed to have the same character
970 set as the connection.
971
972 2. TIBGUIInterface: this is an internal interface. Minor type changes to allow
973 for Login Dialog returing a change to the database path.
974
975 3. Design Time Database and Server login Dialogs now allow the Database Name/Server Name
976 to be changed from that given in the TIBDatabase/TIBServer component and for the
977 entered value to be saved on a project specific basis (design time only).
978
979 4. IBDynamicGrid: TDBLookupCellEditor now compares its DataFieldName with the
980 column fieldname. If they are the same then it is acts as a look up for the KeyValue
981 Otherwise, it sets the column text to the selected ListField Value.
982
983 5. IBDynamicGrid: Only visible columns are now taken into account When recalculating
984 column width.
985
986 6. IBLookupComboEditBox: Fix error with autocomplete query when a RelationName is given
987 and a case insensitive search is requested.
988
989 7. IBDynamicGrid: No longer ignores notifications removing Column Totals controls
990 or column ListSource.
991
992 8. IBQuery: no longer performs unnecessary refresh of SQL Text (and hence avoids an
993 unprepare) when closing and the text has not changed.
994
995 9. IBSQL: Base the cursor name on a GUID instead of a hexstr version of the class pointer.
996 Less likely to cause a cursor re-use error on Windows.
997
998 10.SV5IPC: include workaround for OSX. FPC 3.0.0 has broken ipc module for darwin.
999 Expected to be fixed in 3.0.2. Hence workaround only applies to 3.0.0.
1000
1001 11. TIBTreeView: Guard against nil destination on record changed
1002
1003 12. AnsiString Code page support: TIBStringField.AsString and TIBMemoField.AsString now return a
1004 string type with the code page set to reflect the returned field encoding after
1005 Firebird driver transliteration, if any. FPC 3.0.0 onwards only. Behaviour unchanged for
1006 earlier versions.
1007
1008 13. AnsiString Code page support: Assigning to TIBStringField.AsString and TIBMemoField.AsString
1009 will now result in transliteration to the code page specified for the Firebird driver
1010 if the assigned string has a different code page. FPC 3.0.0 onwards only.
1011
1012 14. TIBDatabase: new property UseDefaultSystemCodePage. When set any lc_ctype parameter
1013 is ignored and the lc_ctype value, when the database is opened, is set to align with
1014 the DefaultSystemCodePage (FPC 3.0.0 onwards). Normally, this is what you want and should ensure
1015 platform independence. Note: this applies to FPC 3.0.0 and earlier versions. Pre FPC
1016 3.0.0, when this property is true, the lc_ctype is UTF8 except under windows when
1017 the GETACP is used to determine the Windows code page.
1018
1019 15. TIBDatabase: new property DefaultCharSetName. This is the Firebird character set
1020 name used as the lc_ctype when the database was opened. Only valid while the
1021 Database is connected.
1022
1023 16. TIBDatabase: new property DefaultCodePage (FPC >=3.0.0 only). This is the codepage
1024 id that corresponds to the DefaultCharSetName.
1025
1026 IBX Change Log version (1.4-0) Mon, 15 Feb 2016 14:44:24 +0000
1027
1028 1. Unix: If Firebird Embedded Server shared object is loaded and a local database
1029 path is given and database attach fails due to access permission issues on the
1030 temp directory or security database, then the attach is retried with "localhost:"
1031 prefixing the databasename. This should avoid problems when the database has to
1032 be accessed by a local (e.g. classic) server and libfbembed is used.
1033
1034 2. Windows: revised search order for Firebird DLL:
1035 i. The Firebird Embedded Server in the application Directory.
1036 ii. If the FIREBIRD environment variable is set then the directory this
1037 points to is searched for the FB Client DLL and then then underlying
1038 "bin" directory.
1039 iii. Registry Key HKEY_LOCAL_MACHINE\SOFTWARE\Firebird Project\Firebird Server\Instances
1040 is used to locate the Firebird installation directory and the underlying
1041 "bin" directory is searched for the FB Client DLL.
1042 iv. The Default installation directories C:\Program Files\Firebird\Firebird_2_x
1043 are searched for the FB Client DLL.
1044 v. The PATH Environment variable is used to search for the FB Client DLL.
1045 vi. Finally the PATH Environment variable is used to search for IBASE.DLL.
1046
1047 3. New Component: TIBXScript. This is an ISQL compatible SQL script execution engine.
1048 See doc/readme.scriptengine and example applications.
1049
1050 4. New Component: TIBlocalDBSupport. This is a TIBDatabase support component intended to
1051 simplify the use of the embedded firebird server on both Linux and Windows platforms.
1052 See dpc/readme.localdatabase and example applications.
1053
1054 5. IBDynamicGrid: Reordering on column header click should now also work for
1055 dynamic columns.
1056
1057 6. ISQLMonitor: (Windows only). Mutex added to TMultilockGate to avoid race condition
1058 between incrementing/decrementing the lock count and signalling the event.
1059
1060 IBX Change Log version (1.3-2) Tue, 26 Jan 2016 14:39:54 +0000
1061
1062 1.3.2 was never formally released and only made available as beta copies.
1063
1064 1. DBControlGrid,IBDynamicGrid: Ignore down arrow and up arrow in TCustomMemo
1065
1066 2. IBDynamicGrid: Now deals correctly with a single column grid which has no indicator and autosize column
1067
1068 3. IBLookupComboEditBox: reset timer on each key press - avoids timer going off too early
1069
1070 4. IBDynamicGrid: Call event OnUpdateSortOrder even when aliasname not found in dataset
1071 i.e. when it is a calculated field
1072
1073 5. IBDynamicGrid: Fix problem selecting a different row when expanded row at end of grid.
1074 This problem was due to a race condition between recalculating row heights and
1075 determining which row was selected by the mouse click. The row height calculation
1076 is now deferred by an extra trip round the message loop allowing the row to
1077 be always calculated on the current grid layout rather than risking it being
1078 calculated on the grid layout after the expanded row has been shrunk.
1079
1080 6. IBLookupComboEditBox: avoid race condition between cm_killfocus and cm_exit on
1081 Windows.
1082
1083 7. TIBStringField: Now has two new public properties: CharacterSetName: string and CharacterSetSize: integer;
1084 These properties allow the (Firebird) character set name for the field and the max number of bytes per character
1085 to be determined at runtime. See doc/readme.charactersets.html.
1086
1087 8. TIBWideStringField: This is a new field type with the same additional public properties as above and subclassed from
1088 TWideStringField. This field type is used with the character size reported by Firebird is two. See doc/readme.charactersets.html.
1089
1090 9. TIBMemoField and TIBWideMemoField: new field types with the same additional public properties as above and subclassed from
1091 TMemoField and TWideMemoField respectively. These field types are used with Blob subtype 1 and a characterset size of
1092 1, 3 or 4 (TIBMemoField) or 2 (TIBWideMemoField). See doc/readme.charactersets.html.
1093
1094 Both also have a new published property "DisplayTextAsClassName". If false (default) the displaytext is generated
1095 from the blob text by truncating the string to the displaywidth (in characters not bytes). A displaywidth of zero
1096 implies no truncation.
1097
1098 10. IBLookupComboEditBox: Force autocomplete when EditingDone called and timer active.
1099
1100 11. IBDynamicGrid: Call DataSet.Append when entering edit mode and dataset empty and not in insert state
1101 (avoids "Not in Edit Mode" error).
1102
1103 12. IBDynamicGrid: Correctly resize grid when one column width plus indicator.
1104
1105 13. IBDynamicGrid: Ensure Editor Panel has focus when shown - avoids Windows API calling
1106 DBGrid.DoExit on subsequent mouse click (e.g. on child control such as a tabbed page control.
1107
1108 14. IBDynamicGrid: ignore up, down tab and return when editorpanel open and focus in a TCustomGrid descendent.
1109
1110 15. DBControlGrid: Stop flashing grid when dataset closed and then re-opened while DisabledControls
1111
1112 16. IBQuery: Bug fixed that prevented SQL being set programmatically once the Parser had been invoked.
1113
1114 17. IBCustomDataSet: On close, parser is now freed and Select SQL reverts to value before DataSet Opened.
1115
1116 IBX Change Log version (1.3-1) Sat, 18 Jul 2015 13:30:50 +0100
1117
1118 1. OnCloseUp Event Handler added to TDBLookupProperties
1119
1120 2. IBDynamicGrid: Call to OnEditorPanelHide is now last editor hide action - avoids
1121 problem with row size when exception is called.
1122
1123 3. IBLookupComboEditBox: Force pending autocomplete on combobox exit.
1124
1125 4. IBDynamicGrid and DBControlGrid: Keyhandler now ignores up, down, escape and return keys if
1126 in a TCustomComboBox and ignores return key if in a TCustomMemo
1127
1128 5. IBLookupComboEditBox: Ensure that KeyValue is set correctly when full text
1129 keyed in i.e. when autocomplete not performed
1130
1131 6. Cleanup of "Uses" clauses and add console mode support. IBX should now support
1132 console mode applications with all LCL required functions (builtin dialogs and
1133 cursor management) centralised in the IBDialogs unit. As long as "IBDialogs" is
1134 not included in your project, IBX should compile and link with a console mode program.
1135 See consolemode example and its "readme"for further guidence. DO NOT add the ibexpress package to a
1136 console mode application or the IDE will automatically assume that your
1137 application is GUI based. Instead, you should include the ibexpressconsolemode package.
1138
1139 IMPORTANT NOTE: IBDialogs must be included in GUI applications in order
1140 to use the built in dialogs and cursor management. IBDialogs is
1141 included by default if "ibexpress" is in your project source's "uses" clause.
1142 This should be the case for all projects created through the IDE. This is why
1143 you do not want to add the ibexpress package to console mode applications. The
1144 ibexpressconsolemode package has been created to allow console mode programs
1145 to avoid adding LCL dependencies when using IBX, while still having the
1146 unit search paths set up correctly.
1147
1148 Existing users should check to ensure that the "ibexpress" unit is included in
1149 each project's source file (*.lpr).
1150
1151 You may find that in order for the IDE to recognise that ibexpressconsolemode
1152 exists, you have to first open the package in the IDE and then close it. This
1153 adds it to the most recently accessed packages list. To make it permanently
1154 available, add the package name to lazarus' staticpackages.inc file.
1155
1156 Thanks to Julio Jiménez for suggesting support of console mode.
1157
1158 7. SQL Parser can now accept quoted strings that include new lines
1159
1160 8. IBDynamicGrid: Lookup Cell Editor - the cursor is now positioned at end
1161 of text on start of edit. This is particularly useful when tabbing to a
1162 column and then inserting text.
1163
1164 9. New Examples provided for IB Services and ISQLMonitor.
1165
1166 10. Fix error when writing to blob streams that recorded only the last buffer
1167 write in the blob stream. In most cases, this did not cause a problem as the
1168 IB Blob Stream is written in a single write. However, with the TDBImage, write
1169 of a graphic type prefix was lost which caused a problem when the image could
1170 not be automatically recognised.
1171
1172 11. Improve generation of random cursor names in TIBSQL - avoid risk of "cursor
1173 already open" errors due to random numbers used for the cursor name being identical.
1174
1175 12. IBTable: corrected error that could result in an "Index out of bounds" error
1176 when opening the table and the Primary Key is the last or only column in the
1177 table. Thanks to Rick Hoover for the fix.
1178
1179 13. Fix TIBDatabase initialisation of lc_ctype under unix. Set to "UTF8" instead
1180 of "UTF-8", and update list of available database character sets. Existing
1181 users should check the current lc_ctype setting in their applications.
1182
1183 IBX Change Log version (1.2-4) Sat, 09 May 2015 12:38:29 +0100
1184
1185 1. Firebird Services: avoid List Index error when opening a service with an
1186 empty Params property.
1187
1188 2. IBControls: Fix problem with new link mechanism introduced in 1.2.3.
1189 Link now set up in Loaded method - avoids occasional failure to apply
1190 SQL markup on initial open.
1191
1192 3. "Employees" example performance improvements when scrolling.
1193
1194 4. DBControlGrid: Correctly handle edit panel removal when panel is child control of a
1195 TFrame. Force recaching of selected frame to avoid GTK race (results in a
1196 random image cached).
1197
1198 5. DBControlGrid: Should now react to changes in panel height at run time.
1199
1200 6. IBDynamicGrid: Redraws rows below on panel editor hide - avoids blank space at end of grid
1201 even when further rows exist.
1202
1203 7. DBControlGrid: DefaultRowHeight is no longer a published property as it should
1204 always be derived from panel height and setting this property can cause confusion.
1205 Note for existing projects: to avoid a missing property error at run time,
1206 each form using the DBControlGrid must be opened, updated and saved in the IDE
1207 in order to remove the property value from the lfm.
1208
1209
1210 IBX Change Log version (1.2-3) Tue, 14 Apr 2015 14:11:17 +0100
1211
1212 1. TIBStoredProc. Prepare now called by ParamByName to avoid need to always
1213 call Prepare before setting parameter values.
1214
1215 2. Error message on ParamByName (all cases) not found now includes name of missing parameter.
1216
1217 3. Code tidyup and more robust handling of dsql information result vector.
1218
1219 4. Support for centralised handling of transaction status changes. TIBTransaction
1220 has been given additional events "AfterEdit", "AfterInsert", "AfterDelete", "AfterPost"
1221 and "AfterExecQuery". The first three are called after the same event is called
1222 for an IBCustomDataSet descendent using the Transaction. The fourth is called
1223 after a call to TIBSQL.ExecQuery, again using this transaction. These new events
1224 enable monitoring of transaction status changes for a given transaction to be
1225 handled in a single place. For example, when a change to the dataset occurs
1226 an indicator can be set that shows the user that in order to save changes,
1227 the transaction should be committed. Rather than doing this per dataset, this
1228 can now be done per transaction.
1229
1230 5. TDataSet.CheckBrowseMode automatically posts changes to the current row when
1231 the dataset is scrolled. However, any changes to the current row are, by default,
1232 discarded when the dataset is closed. TIBDataSet, TIBQuery and TIBTable now
1233 have a new property "DataSetCloseAction" that adds automatic posting of changes
1234 on dataset close. If this property is set to dcDiscardChanges (default) then the
1235 behaviour is unchanged from previous versions. if the value is set to dcSaveChanges
1236 then IBX will attempt to post any unsaved changes before the dataset is closed
1237 (and after the BeforeClose event handler is called). The exception is when the
1238 dataset is being closed as a result of a transaction rollback. In this case,
1239 no action is taken and any unsaved changes are discarded. This avoids both
1240 unnecessary overhead and the risk that a validation error may occur in the Post
1241 raising an exception and thereby preventing a rollback.
1242
1243 6. String Field sizes and Display Widths should now be correct for multi-byte character sets.
1244 In earlier versions, the Display Width was set to the maximum byte width rather than the character
1245 width. Display Widths are now corrected by dividing by the max byte width per character.
1246 For UTF8 character sets, the byte width is four and hence the Display Width will be
1247 the byte width divided by 4. The byte width of each character set is determined
1248 dynamically when the database connection is estabished from the RDB$CHARACTER_SETS
1249 system table. (see also http://bugs.freepascal.org/view.php?id=27766).
1250
1251 7. SQLParser will now correctly parse SQL Text which contains ':' within quoted string.
1252
1253 8. IBLookupComboEditBox: List should now always be restored to full list when the
1254 control loses focus. Default Key press default interval reduced to 200ms.
1255
1256 9. DBControlGrid: Ensure that selection is changed to newly appended row, even
1257 when dataset rows are less than visible rows.
1258
1259 10. IBDynamicGrid: Editor Panel is not shown on indicator click if Datasource
1260 does not exist or DataSet is empty. More responsive on dataset open. New event
1261 OnRestorePosition. Column sort disabled if no header row.
1262
1263 11. IBTreeView: improved handling of response to "Add Node". Avoid scrolling dataset
1264 while dataset state is dsInsert. Avoids posting errors.
1265
1266 12. IBControls: New mechanism for distributing UpdateSQL and UpdateParams events. This is to
1267 avoid conflict with DisableControls/EnableControls with Master/Detail linked tables.
1268
1269 13. IBLookupComboEditBox: Now avoids SQL Errors when combo box text contains single quotes.
1270
1271 14. TIBDataSet and TIBQuery: new Event - OnValidatePost. This event has been introduced
1272 to solve a specific problem. That is when the dataset cursor is moved (e.g. by
1273 a grid mouse click and the current row is being edited or inserted. In this case, TDataset
1274 always "posts" the current record regardless or whether or not it may be more appropriate
1275 to cancel any changes; the post occurs before the "BeforeScroll" event fires due to the way the
1276 "MoveBy" function is implemented by TDataSet. The OnValidatePost event is called
1277 as the first action of the "Post" method and allows the handler to convert the Post
1278 into a Cancel if that is the appropriate action on moving to a different row. This is
1279 achieved by returning with "CancelPost" argument set to true. Note that an exception could be
1280 raised here, but it may still be more appropriate to validate a post and signal
1281 a problem in the "BeforePost" event handler. See readme.automaticposts.xhtml)
1282
1283 15. On Unix derived systems, the Firebird library name can now be given as a colon
1284 separated list. Each library name on the list is tried in turn, in left to right
1285 order with the first found being used as the firebird library. By default, on Linux,
1286 the library name list is 'libfbembed.so.2.5:libfbembed.so.2.1:libfbclient.so.2'. This can be
1287 overidden by the FBLIB environment variable or the OnGetLibraryName function.
1288
1289 Note: when using the libfbembed.so, if you prefix the database name with "localhost:"
1290 then it will still attempt to access the database via the Firebird Server and will
1291 require a username and password. If only the pathname is given, then the username
1292 and password should be omitted and the unix file permissions are used to grant
1293 access.
1294
1295 IBX Change Log version (1.2-2) Sat, 14 Mar 2015 11:35:04 +0000
1296
1297 1. A new IBControl - TDBControlGrid has been added. TDBControlGrid a lookalike
1298 rather than a clone for the Delphi TDBCrtlGrid. TDBControlGrid is a single column grid
1299 that replicates a TWinControl - typically a TPanel or a TFrame in each row. Each row
1300 corresponds to a row of the linked DataSource. Any data aware control on the
1301 replicated (e.g.) TPanel will then appear to have the appropriate value for the row.
1302
1303 2. As suggested by Julio Jiménez, a new property "SQLHourGlass" has been added to TIBDatabase.
1304 When set to false (default true), the Hour Glass cursor is supcpressed and no cursor change
1305 takes place during database access. This may be useful when there are performance issues with
1306 the change of cursor. Setting the property to false suppresses the change of cursor.
1307
1308 3. As suggested by Julio Jiménez, a new property "AutoCommit" has been added to TIBDataSet, TIBQuery
1309 and TIBTable. When set to acCommitRetaining (Default: acDisabled), a call is made to
1310 Transaction.CommitRetaining immediately after every Post or Delete. This has the effect of
1311 making all changes permanent immediately rather than when the transaction is explicitly
1312 committed.
1313
1314 4. Experimental support for the Firebird 3 SQL_BOOLEAN type has been added while still
1315 using the legacy Firebird API. Thanks to Gabor Boros for helping to test this feature.
1316
1317 IBX Change Log version (1.2-1) Fri, 13 Mar 2015 11:14:15 +0000
1318
1319 Development version only.
1320
1321 IBX Change Log version (1.2-0) Thu, 26 Feb 2015 10:34:04 +0000
1322
1323 1. An internal select SQL Parser is now available for TIBCustomDataset descendents.
1324 This is typically used during an "OnBeforeOpen" event handler to manipulate the
1325 "Where" and "Having" clauses to implement user specified filters of arbitrary
1326 complexity.
1327
1328 2. A new Component Palette entry "Firebird Data Controls" is now available. This has
1329 three new data aware controls dependent on IBX and which make use of the SQL Parser.
1330 These are:
1331
1332 - TIBLookupComboEditBox
1333 - TIBDynamicGrid
1334 - TIBTreeview
1335
1336 TIBLookupComboEditBox is a TDBLookupComboBox descendent that implements "autocomplete"
1337 of typed in text and "autoinsert" of new entries. Autocomplete uses SQL manipulation
1338 to revise the available list and restrict it to items that are prefixed by the
1339 typed text (either case sensitive or case insensitive). Autoinsert allows a
1340 newly typed entry to be added to the list dataset and included in the available
1341 list items.
1342
1343 TIBDynamicGrid is a TDBGrid descendent that provides for:
1344 - automatic resizing of selected columns to fill the available row length
1345 - automatic positioning and sizing of a "totals" control, typically at the
1346 column footer, on a per column basis.
1347 - DataSet resorting on header row click, sorting the dataset by the selected column.
1348 A second click on the same header cell reversed the sort order.
1349 - Support for a "Panel Editor". That is on clicking the indicator column, the row
1350 is automatically expanded and a panel superimposed on it. The panel can have any
1351 number of child controls, typically data aware controls with the same datasource
1352 as the grid allowing for editing of additional fields and more complex editors.
1353 - Reselection of the same row following resorting.
1354 - A new cell editor that provides the same functionality as TIBLookupComboEditBox.
1355 Its properties are specified on a per column basis and allows for one or more
1356 columns to have their values selected from a list provided by a dataset.
1357 Autocomplete and autoinsert are also available. The existing picklist editor
1358 is unaffected by the extension.
1359
1360 TIBTreeView is a data aware TCustomTreeView.
1361
1362 3. When getting a field value using FieldByName.AsVariant, an SQL_INT64 with a
1363 zero scale will no longer return an error. An Int64 will be returned instead.
1364
1365 4. TIBTransaction now has events for Before and After Transaction End and a new function
1366 "GetEndAction" allowing the EndAction to be accessed by these event handlers.
1367
1368 5. TIBQuery can now handle correctly queries which contain the same keyword parameter
1369 repeated multiple times.
1370
1371 6. TIBUpdateSQL will no longer return an error when "RowsAffected" is <> 1. This error
1372 check used to get in the way of using Stored Procedures, and "Update or Insert"
1373 statements.
1374
1375 7. Insert, Modify and Delete property Editors now support Query Generation from
1376 Stored Procedures.
1377
1378 8. Three new examples illustrate the use of the new IB Controls
1379
1380
1381 IBX Change Log version (1.1-0) Mon, 07 Jul 2014 14:01:07 +0100
1382
1383 1. TIBXSQLVAR code clean up and optimisation to improve client side "prepare" and parameter
1384 setting performance. See "readme.field+param.names in the doc folder.(Thanks to
1385 Gabor Boros for reporting this problem and for testing the improvements).
1386
1387 2. IBX can now support dialect 3 quoted column names that contain spaces and which differ only in their case.
1388 See readme.field+param.names in the doc folder.
1389
1390 3. IBX SQL Editors will now automatically add double quotes around column names when the database
1391 dialect is "3" and the column name contains spaces or is a Firebird 2.5 SQL Reserved Word.
1392
1393 4. Param Type LargeInt now supported in TIBQuery and TIBStoredProc
1394
1395 5. TIBSQL.ExecQuery retry on failure removed to avoid problems with "at most once"
1396 actions.
1397
1398 6. TIBTransaction.SetDefaultDatabase uses SetObjectProp instead of mis-using SetOrdProp (with
1399 thanks to Yuriy Kopnin for pointing this out).
1400
1401 7. GenerateParamName is now a published property of TIBSQL, TIBQuery and TIBDataSet.
1402
1403 8. varWord, varShortInt and varInt64 added to TIBXSQLVAR.SetAsVariant and hence now available as variant types
1404 for both fields and parameter setting.
1405
1406 9. Changes to the Select SQL in an IBCustomDataset descendent should now be
1407 visible in the Fields Editor immediately afterwards - rather than only after cycling the "active" property.
1408
1409 10. TIBSQL SQL editor will operate correctly and not report an SQL syntax error on SQL test,
1410 when DSQL ('?') parameter placeholders are used and the TIBSQL.GenerateParamNames property is set to true.
1411
1412 11. TIBTable now has a property editor for "MasterFields"
1413
1414 12. SQL Property Editors now include a checkbox "Allow DSQL Placeholder". This corresponds to the
1415 GenerateParamNames property and should be set when using DSQL (i.e. '?') style parameters.
1416
1417 13. The IBTransaction editor now has a radio button ("Unspecified") which is set when the combination
1418 of settings is unrecognised. Selecting this radio button has no effect on the settings.
1419
1420
1421 IBX Change Log version (1.0-5) Sat, 28 Dec 2013 19:22:23 +0000
1422
1423 1. TBookmark change conditional compile changed to >= 2.7.0 to match revised availability of change.
1424
1425 IBX Change Log version (1.0-4) Thu, 28 Feb 2013 16:56:13 +0000
1426
1427 1. In a TIBCustomDataset descendent, a generator now only sets the value when
1428 it is null. This allows for alternative user defined setting of the generator
1429
1430 Many thanks to Julio Jiménez for this fix
1431
1432 2. An Error Dialog is now displayed in the Lazarus IDE if IBX cannot find the Firebird Library
1433 and suggests that the user may have forgotten to install it.
1434
1435 IBX Change Log version (1.0-3) Thu, 22 Nov 2012 22:53:39 +0000
1436
1437 1. Conditional compilation used to limit registration of TIntegerField to
1438 Lazarus versions less than 1.1
1439
1440 2. When a database connection is created, character set is now by default set
1441 to UTF8 (Unix) or to the current Windows code page (Windows) if in the range
1442 1250 to 1254.
1443
1444
1445 IBX Change Log version (1.0-2) Tue, 09 Oct 2012 09:10:30 +0100
1446
1447 1. TBookmark change conditional compile changed to > 2.6.2 to match expected availability of change.
1448
1449
1450 IBX Change Log version (1.0-1) Sun, 05 Aug 2012 20:00:04 +0100
1451
1452 1. In IBCustomDataset. Changed CurBookmark from string to TBookmark for compiler versions > 2.6.0
1453 Necessary because of TBookmark type and TDataSet.Bookmark property change in fpc 2.7.1
1454
1455 2. IBX now registers TIntegerField as a "No Icon" component. This may be removed if the fpc DB
1456 package is changed to do this (which it should do).
1457
1458 IBX Change Log version (1.0-0) Sat, 28 Apr 2012 16:43:00 +0100
1459
1460 1. Add "if active then active := false" to TIBCustomDataset destructor. (Avoid error on database close).
1461
1462 2. Make use of $STATIC conditional in IBSQLMonitor (Needed for FPC 2.6.0 compliance)
1463
1464 3. Database Property Editor: Character Set drop down box now uses "OnChange" rather than "OnCloseUp" to react to changes
1465
1466 4. Property editors should now correctly resize.
1467
1468 5. In IBDatabaseEdit.TestClick, the LoginPrompt is now set to the state of the LoginPrompt Checkbox
1469 (restored original functionality)
1470
1471 6. Under OSX, if IBX fails to load libfbclient.dylib, it will now try and load the firebird
1472 library using the absolute path /Library/Frameworks/Firebird.framework/Firebird.