| 1 |
+ |
IBX Change Log version (2.1-1) Fri, 05 Jan 2018 10:40:04 +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 |
|
IBX Change Log version (2.1-0) Fri, 15 Dec 2017 12:20:11 +0000 |
| 16 |
|
|
| 17 |
|
1. IBCustomDataset: Minor change of PChar to PByte for compatibility with fbintf |
