ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/trunk/changelog
(Generate patch)

Comparing ibx/trunk/changelog (file contents):
Revision 270 by tony, Fri Jan 18 11:10:37 2019 UTC vs.
Revision 308 by tony, Sat Jul 18 10:26:30 2020 UTC

# Line 1 | Line 1
1 < IBX Change Log  version (2.3-3 Build 11336) Fri, 28 Dec 2018 10:04:17 +0000
1 > IBX Change Log  version (2.3-5 Build 12212) Fri, 17 Jul 2020 15:24:08 +0100
2 >
3 > 1.  TIBStringField: when a string value is read from a dataset buffer, if the
4 >    number of UTF8 characters exceeds the string size then string is truncated
5 >    to the maximum string size. This is  usually a problem with fixed width columns
6 >    right padded with white space.
7 >
8 > 2.  SQLFiltered and SQLFilterParams added to TIBQuery, TIBTable and TIBDataset.
9 >    If SQLFiltered is set then when a dataset is opened, each line in the
10 >    SQLFilterParams property is assumed to be a SQL condition clause and
11 >    ANDed into the Where clause of the SQL Select statement provided as a
12 >    dataset property. Each such SQL condition thus acts as an additional filter
13 >    on the dataset. (Not yet tested)
14 >
15 > 3.  The Filtered property inherited from TDataset is no longer used for SQL (server
16 >    side filters).
17 >
18 > IBX Change Log  version (2.3-4 Build 12041) Fri, 17 Apr 2020 14:00:32 +0100
19 >
20 > 1.  TIBXDataSet and Generators: Generator Names that are not all upper case or
21 >    not SQL Identifiers are now supported.
22 >
23 > 2.  TIBXScript: Set Generator is no longer rejected as unrecognised SQL and is
24 >    passed to the Firebird engine for execution.
25 >
26 > 3.  TIBDataSet: Unidirectional datasets now give an error message if an attempt
27 >    is made to scroll back.
28 >
29 > 4.  New unit: IBMessages.pas. Contains only messages used by IBX and not FBIntf
30 >
31 > 5. TIBLookupComboEditBox: When generating auto-complete SQL, the ListField is now
32 >   only enclosed in double quotes in SQL dialect 3 and when it needs to be.
33 >
34 > 6. TIBLookupComboEditBox: when the list source opens, the ListField name is now
35 >   validated. If no match is found in the list of field names and the database has
36 >   been opened in SQL Dialect 3, then the ListField Name is converted to upper case
37 >   if it then matches a field name. Otherwise, a Listfield not valid exception occurs.
38 >
39 > 7. IBGeneratoreditor.pas: Add missing parenthesis around "IS" statement for compliance
40 >   with fpc 3.2.
41 >
42 > IBX Change Log  version (2.3-3 Build 11512) Fri, 28 Dec 2018 10:04:17 +0000
43 >
44  
45   1. New property for TIBDatabase and TIBXServicesConnection. This is "ConfigOverrides"
46     and is used to override the default settings in the client side "firebird.conf" This
# Line 62 | Line 104 | IBX Change Log  version (2.3-3 Build 113
104     This only applies to columns with an SQL Type of SQL_VARYING and SQL_TEXT.
105  
106   8. TIBDataSet now raises an exception when ParamByName called with an invalid parameter name.
107 +   Uses "FindParam" if in order to find out if a parameter with a given name exists
108 +   and without raising and exception if it does not.
109  
110 < 9. TIBQuery now uses IBX SQL Parser instead of TParams SQL parser in order to ensure
110 > 9. TIBQuery now uses IBX SQL Parser instead of the TParams SQL parser in order to ensure
111     consistency with SQL queries.
112  
113   10. CaseSensitiveParameterNames property added to TIBSQL, TIBDataSet and TIBQuery.
114      When true, SQL statement parameter names are parsed case sensitive. Note for
115      TIBDataSet only applies to Select query.
116  
117 + 11. IBEvents: removing a TIBEvent component from a form should no longer result in
118 +    an IDE exception.
119 +
120 + 12. LocalDBSupport: initial database creation should now work correctly
121 +    when the schema source is an sql file.
122 +
123 + 13. TIBCMLocalDBSupport: new event handler "property OnProgressEvent: TOnProgressEvent"
124 +    when defined, this handler will be called by the internal TIBXScript during
125 +    initial database creation when the schema source is an sql file and may be used
126 +    to provide a visual indication of progress in console mode.
127 +
128 + 14. TCustomIBLocalDBSupport: new public property "InOnCreateDB: boolean". This is set
129 +    to true while a new local database is being created and its schema populated.
130 +    Useful in (e.g.) TIBDatabase.OnAfterConnect handler to suppress actions
131 +    when the database is disconnected/connected during the create DB procedure.
132 +
133 + 15. TIBXScript: any User/password parameters found in a CREATE DATABASE statement
134 +    are now always ignored and replaced by the user name and password provided as
135 +    the login parameters for the TIBDatabase referenced from the TIBXScript. The
136 +    IgnoreCreateDatabase property still applies and the CREATE DATABASE statement is
137 +    completely ignored if this property is true.
138 +
139 + 16. Code tidyup in IBTreeView: Node properties initialisation moved from TIBTreeView.AddNodes
140 +    to TIBTreeView.Added. An OnAddition event handler is no longer needed to initialise
141 +    ImageIndex and SelectImageIndex values on AddNode.
142 +
143 + 17. TIBDatabase.Attachment and TIBXServicesConnection.ServicesIntf properties are now
144 +    read/write. This should enabled (e.g.) multiple instances of TIBDatabase to share
145 +    the same database connection.
146 +
147 + 18. TIBDataSet and TIBQuery now support the TDataSet "Filter" property.
148 +    if provided, this should be an conditional SQL expression suitable for
149 +    including in an SQL Select statement "where" clause. If non-empty and the
150 +    "Filtered" property is true then the SQL expression provided as the value of
151 +    the "Filter" property is "ANDed" with any existing condition statement
152 +    in the SQL statement's "Where" clause.
153 +
154 +    If the "Filter" property is set at run time, the "Filtered" property is true
155 +    and the dataset is already open, then the dataset is closed and re-opened automatically.
156 +
157 +    The "Filter" condition may include IBX style parameters. In which case, their
158 +    value must be set by the dataset's "OnBeforeOpen" event handler.
159 +
160 +    This is a public property for TIBDataSet and TIBQuery query and intended for
161 +    use at run time.
162 +
163 +    Note: The property is a published property of TIBTable. The TIBTable functionality
164 +    is unaffected by this change.
165 +
166   IBX Change Log  version (2.3-2) Wed, 05 Dec 2018 12:19:23 +0000
167  
168   1. Remove need to check for IsMultiThread by providing access to GUI timers via

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines