--- ibx/trunk/changelog 2018/01/01 11:31:34 90 +++ ibx/trunk/changelog 2018/01/18 14:37:35 106 @@ -1,3 +1,33 @@ +IBX Change Log version (2.1-1) Fri, 12 Jan 2018 10:13:29 +0000 + +1. IBExtract: Identity columns - add addition check for null column for generator name. + +2. IBCustomDataSet: Insert and Modify (Update) queries now recognise and process SQL RETURNING clauses. + The main use for this is for Firebird 3 Identity columns (see IBXDocumentation 6.6.8 for further + information). Values returned as a result of executing an Insert or Update statement + replace existing values in the current row for each corresponding column. + +3. The InsertSQL property editor now shows Firebird 3 Identity columns separate from the Field List. + When InsertSQL is generated, the Identity columns are not included in the list of values to + be inserted. A RETURNING clause is added to the insert statement to return the value of + each Identity column after the insert is executed. + +4. TIBGenerator: small performance improvement by not preparing query each time + a new number is generated. + +5. TIBSQL: Free resources when transaction changed. + +6. Property editor will now sync table name to a System Table when "Include System + Tables" is selected and the query is for a System Table. + +7. Modify Property Editor now generates Update SQL with Computed By fields in Update..Returning clause. + Similarly Insert Property Editor now generates Insert SQL with Computed By fields in + Insert..Returning clause. + +8. Minor Performance improvement to handling of Date/Time types in IBX datasets. Field + values are no longer converted to milliseconds from TDateTime and then back again + the TDateTime (the TDataset approach). + IBX Change Log version (2.1-0) Fri, 15 Dec 2017 12:20:11 +0000 1. IBCustomDataset: Minor change of PChar to PByte for compatibility with fbintf