1 |
< |
IBX Change Log version (2.1-0) Fri, 15 Dec 2017 12:20:11 +0000 |
1 |
> |
IBX Change Log version (2.1-1) Sun, 07 Jan 2018 15:15:13 +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 |
> |
IBX Change Log version (2.1-0) Fri, 15 Dec 2017 12:20:11 +0000 |
21 |
|
|
22 |
|
1. IBCustomDataset: Minor change of PChar to PByte for compatibility with fbintf |
23 |
|
changes. |