| 1 |
< |
IBX Change Log version (2.1-0) Fri, 15 Dec 2017 12:20:11 +0000 |
| 1 |
> |
IBX Change Log version (2.1-1) Fri, 12 Jan 2018 10:13:29 +0000 |
| 2 |
> |
|
| 3 |
> |
1. IBExtract: Identity columns - add addition check for null column for generator name. |
| 4 |
> |
|
| 5 |
> |
2. IBCustomDataSet: Insert and Modify (Update) queries now recognise and process SQL RETURNING clauses. |
| 6 |
> |
The main use for this is for Firebird 3 Identity columns (see IBXDocumentation 6.6.8 for further |
| 7 |
> |
information). Values returned as a result of executing an Insert or Update statement |
| 8 |
> |
replace existing values in the current row for each corresponding column. |
| 9 |
> |
|
| 10 |
> |
3. The InsertSQL property editor now shows Firebird 3 Identity columns separate from the Field List. |
| 11 |
> |
When InsertSQL is generated, the Identity columns are not included in the list of values to |
| 12 |
> |
be inserted. A RETURNING clause is added to the insert statement to return the value of |
| 13 |
> |
each Identity column after the insert is executed. |
| 14 |
> |
|
| 15 |
> |
4. TIBGenerator: small performance improvement by not preparing query each time |
| 16 |
> |
a new number is generated. |
| 17 |
> |
|
| 18 |
> |
5. TIBSQL: Free resources when transaction changed. |
| 19 |
> |
|
| 20 |
> |
6. Property editor will now sync table name to a System Table when "Include System |
| 21 |
> |
Tables" is selected and the query is for a System Table. |
| 22 |
> |
|
| 23 |
> |
7. Modify Property Editor now generates Update SQL with Computed By fields in Update..Returning clause. |
| 24 |
> |
Similarly Insert Property Editor now generates Insert SQL with Computed By fields in |
| 25 |
> |
Insert..Returning clause. |
| 26 |
> |
|
| 27 |
> |
8. Minor Performance improvement to handling of Date/Time types in IBX datasets. Field |
| 28 |
> |
values are no longer converted to milliseconds from TDateTime and then back again |
| 29 |
> |
the TDateTime (the TDataset approach). |
| 30 |
> |
|
| 31 |
> |
IBX Change Log version (2.1-0) Fri, 15 Dec 2017 12:20:11 +0000 |
| 32 |
|
|
| 33 |
|
1. IBCustomDataset: Minor change of PChar to PByte for compatibility with fbintf |
| 34 |
|
changes. |
| 86 |
|
|
| 87 |
|
22. IBCustomDataset: When database changed ensure that queries an unprepared. |
| 88 |
|
|
| 89 |
< |
23. SQL Property Editors now use SynEdit with SQL Highlighter. |
| 89 |
> |
23. SQL Property Editors now use SynEdit with SQL Highlighter. New features include: |
| 90 |
> |
* Line Wrap on SQL Token boundaries (on user command) |
| 91 |
> |
* auto-complete table names in drop down list of table names |
| 92 |
> |
* Double click on tablename or field name adds to SQL text |
| 93 |
|
|
| 94 |
|
24. IBDataOutput: print statistics using float (%f) format instead of decimal (%d). |
| 95 |
|
|
| 99 |
|
|
| 100 |
|
26. IBDatabaseInfo: Code tidy up. Add check for database not assigned or not open. |
| 101 |
|
|
| 102 |
+ |
27. IBDatabaseInfo: Remove memory leak when accessing database operation counts. |
| 103 |
+ |
|
| 104 |
|
IBX Change Log version (2.0-2) Fri, 24 Feb 2017 12:17:53 +0000 |
| 105 |
|
|
| 106 |
|
1. TIBDatabase.CreateDatabase: extract full DB Name from SQL using reg ex in order to |
