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 23 by tony, Fri Mar 13 10:26:52 2015 UTC vs.
Revision 305 by tony, Fri Jul 17 22:51:19 2020 UTC

# Line 1 | Line 1
1 < IBX Change Log  version                                                   (1.2-1) Fri, 13 Mar 2015 11:14:15 +0000
1 > FBINTF Change Log  version          (1.1-5 Build 12044) Fri, 17 Apr 2020 12:30:01 +0100
2  
3 < 1.  A new IBControl - TDBControlGrid has been added. TDBControlGrid a lookalike
4 <    rather than a clone for the Delphi TDBCrtlGrid. TDBControlGrid is a single column grid
5 <    that replicates a TWinControl - typically a TPanel or a TFrame in each row. Each row
6 <    correspondes to a row of the linked DataSource. Any data aware control on the
7 <    replicated (e.g.) TPanel will then appear to have the appropriate value for the row.
3 > 1. ISQLParams.GetHasCaseSensitiveParams added. Returns true if param names are
4 >   case sensitive
5  
6 < 2. As suggested by Julio Jiménez, a new property "SQLHourGlass" has been added to TIBDatabase.
10 <   When set to false (default true), the Hour Glass cursor is surpressed and no cursor change
11 <   takes place during database access. This may be useful when there are performance issues with
12 <   the change of cursor. Setting the property to false suppresses the change of cursor.
6 > 2. Single line SQL comments starting with '--' are now recognised by SQL Parser.
7  
8 < 3. As suggested by Julio Jiménez, a new property "AutoCommit" has been added to TIBDataSet, TIBQuery
9 <   and TIBTable. When set to acCommitRetaining (Default: acDisabled), a call is made to
10 <   Transaction.CommitRetaining immediately after every Post or Delete. This has the effect of
11 <   making all changes permanent immediately rather than when the transaction is explicitly
12 <   committed.
8 > 3. New API Calls:
9 >        IColumnMetaData.GetStatement
10 >        IColumnMetaData.GetTransaction
11 >        ISQLData.GetStrLength
12 >        IResults.GetStatement
13 >        IAttachment.OpenBlob (using Blob metadata)
14 >        IAttachment.OpenArray (using array metadata)
15  
16 < 4. Experiental support for the Firebird 3 SQL_BOOLEAN type has been added while still
21 <   using the legacy Firebird API.
16 > 4. FBMessages: removal of unused messages
17  
18 < IBX Change Log  version                                      (1.2-0) Thu, 26 Feb 2015 10:34:04 +0000
18 > 5. TFBArray.Create (2nd case): ensure that FFirebirdClientAPI is correctly set.
19  
20 < 1. An internal select SQL Parser is now available for TIBCustomDataset descendents.
26 <   This is typically used during an "OnBeforeOpen" event handler to manipulate the
27 <   "Where" and "Having" clauses to implement user specified filters of arbitrary
28 <   complexity.
20 > 6. TIBSQLStatementType: SQLSavePoint added to end of enumeration.
21  
22 < 2. A new Component Palette entry "Firebird Data Controls" is now available. This has
31 <   three new data aware controls dependent on IBX and which make use of the SQL Parser.
32 <   These are:
22 > FBINTF Change Log  version          (1.1-4 Build 11515)  Fri, 28 Dec 2018 10:04:19 +0000
23  
24 <   - TIBLookupComboEditBox
25 <   - TIBDynamicGrid
36 <   - TIBTreeview
24 > 1. Fix a problem with the SQL parameter parser that failed to recognise parameters
25 >   where the second character of the parameter name is a numeric.
26  
27 <   TIBLookupComboEditBox is a TDBLookupComboBox descendent that implements "autocomplete"
28 <   of typed in text and "autoinsert" of new entries. Autocomplete uses SQL manipulation
29 <   to revise the available list and restrict it to items that are prefixed by the
41 <   typed text (either case sensitive or case insenstive). Autoinsert allows a
42 <   newly typed entry to be added to the list dataset and included in the available
43 <   list items.
27 > 2. New method for IAttachment: procedure getFBVersion(version: TStrings);
28 >   This returns the isc_version connection information as one or more lines.
29 >   This is the same information as returned by isql with the -z option.
30  
31 <   TIBDynamicGrid is a TDBGrid descendent that provides for:
32 <   - automatic resizing of selected columns to fill the available row length
33 <   - automatic positioning and sizing of a "totals" control, typically at the
48 <     column footer, on a per column basis.
49 <   - DataSet resorting on header row click, sorting the dataset by the selected column.
50 <     A second click on the same header cell reversed the sort order.
51 <   - Support for a "Panel Editor". That is on clicking the indicator column, the row
52 <     is automatically expanded and a panel superimposed on it. The panel can have any
53 <     number of child controls, typically data aware controls with the same datasource
54 <     as the grid allowing for editing of additional fields and more complex editors.
55 <   - Reselection of the same row following resorting.
56 <   - A new cell editor that provides the same functionality as TIBLookupComboEditBox.
57 <     Its properties are specified on a per column basis and allows for one or more
58 <     columns to have their values selected from a list provided by a dataset.
59 <     Autocomplete and autoinsert are also available. The existing picklist editor
60 <     is unaffected by the extension.
31 > 3. If -dFIREBIRD3APIONLY is used as a compiler option then the legacy Firebird API
32 >   is no longer compiled in. Likewise, if -dLEGACYFIREBIRDAPIONLY is used as a
33 >   compiler option then the Firebird 3 API is no longer compiled in.
34  
35 <   TIBTreeView is a data aware TCustomTreeView.
35 > 4. IColumnMetaData: new method.
36  
37 < 3. When getting a field value using FieldByName.AsVariant, an SQL_INT64 with a
38 <   zero scale will no longer return an error. An Int64 will be returned instead.
37 >   TIBDateTimeFormats = (dfTimestamp, {SQL TIMESTAMP}
38 >                        dfDateTime,   {SQL DATETIME}
39 >                        dfTime);
40  
41 < 4. TIBTransaction now has events for Before and After Transaction End and a new function
68 <   "GetEndAction" allowing the EndAction to be accessed by these event handlers.
41 >   function GetDateTimeStrLength(DateTimeFormat: TIBDateTimeFormats): integer;
42  
43 < 5. TIBQuery can now handle correctly queries which contain the same keyword parameter
44 <   repeated multiple times.
43 >   This returns the max. number of characters returned by the "AsString" method
44 >   when the SQL type of the column is respectively TIMESTAMP, DATETIME or TIME.
45  
46 < 6. TIBUpdateSQL will no longer return an error when "RowsAffected" is <> 1. This error
47 <   check used to get in the way of using Stored Procedures, and "Update or Insert"
75 <   statements.
46 > 5. Additional argument for IAttachment.PrepareWithNamedParameters -
47 >     CaseSensitiveParams: boolean = false
48  
49 < 7. Insert, Modify and Delete property Editors now support Query Generation from
50 <   Stored Procedures.
49 >   If this argument is set to true then SQL parameter names are assumed to be case
50 >   sensitive and must be referenced (using ISQLParams.ByName) using the case
51 >   sensitive name.
52  
53 < 8. Three new examples illustrate the use of the new IB Controls
53 > 6. Bug fix: when setting a query parameter, it is now possible, when the parameter
54 >   is of type VarChar or Char to set the parameter to a numeric value (e.g. using
55 >   .AsCurrency) and then subsequently to update the value to a non-numeric string
56 >   using .AsString.
57  
58  
83 IBX Change Log  version                      (1.1-0) Mon, 07 Jul 2014 14:01:07 +0100
59  
60 < 1. TIBXSQLVAR code clean up and optimisation to improve client side "prepare" and parameter
86 <   setting performance. See "readme.field+param.names in the doc folder.(Thanks to
87 <   Gabor Boros for reporting this problem and for testing the improvements).
60 > FBINTF Change Log  version                  (1.1-3) Wed, 05 Dec 2018 14:28:10 +0000
61  
62 < 2. IBX can now support dialect 3 quoted column names that contain spaces and which differ only in their case.
90 <   See readme.field+param.names in the doc folder.
62 > 1. DARWIN only syntax error: fix missing semi-colon in TFBClientAPI.LoadIBLibrary
63  
64 < 3. IBX SQL Editors will now automatically add double quotes around column names when the database
65 <   dialect is "3" and the column name contains spaces or is a Firebird 2.5 SQL Reserved Word.
64 > 2. Restrict IsMultiThread check to Unix only for compatibility with
65 >   https://bugs.freepascal.org/view.php?id=30535
66  
67 < 4. Param Type LargeInt now supported in TIBQuery and TIBStoredProc
67 > 3. New SQL Tokeniser added to IBUtils. This is used to pre-process SQL with
68 >   named parameters and is intended to avoid problems with (e.g.) Execute Block
69 >   and processing internal parameters as statement parameters.
70  
71 < 5. TIBSQL.ExecQuery retry on failure removed to avoid problems with "at most once"
72 <   actions.
71 > 4. New interface IFirebirdLibrary provides access to the underlying firebird DLL
72 >   or shared object. Available via a new member (GetFBLibrary) of IFirebirdAPI.
73  
74 < 6. TIBTransaction.SetDefaultDatabase uses SetObjectProp instead of mis-using SetOrdProp (with
101 <   thanks to Yuriy Kopnin for pointing this out).
74 > 5. New function added to IB.pas
75  
76 < 7. GenerateParamName is now a published property of TIBSQL, TIBQuery and TIBDataSet.
76 >   function LoadFBLibrary(aLibPathName: string): IFirebirdLibrary
77  
78 < 8. varWord, varShortInt and varInt64 added to TIBXSQLVAR.SetAsVariant and hence now available as variant types
79 <   for both fields and parameter setting.
78 >   This allows a Firebird Library to be loaded from an explicit path. use the
79 >   IFirebirdLibrary.GetFirebirdAPI member function to get the Firebird API using
80 >   the library. It is possible to load Firebird libraries from different locations
81 >   simultaneously, each with a distinct IFirebirdAPI.
82  
83 < 9. Changes to the Select SQL in an IBCustomDataset descendent should now be
109 <   visible in the Fields Editor immediately afterwards - rather than only after cycling the "active" property.
83 > FBINTF Change Log  version               (1.1-2) Mon, 16 Apr 2018 09:30:32 +0100
84  
85 < 10. TIBSQL SQL editor will operate correctly and not report an SQL syntax error on SQL test,
86 <    when DSQL ('?') parameter placeholders are used and the TIBSQL.GenerateParamNames property is set to true.
85 > 1. Firebird.pas: {$OBJECTCHECKS OFF} added to file to avoid runtime error when
86 >   program compiled with -CR command line switch.
87  
88 < 11. TIBTable now has a property editor for "MasterFields"
88 > 2. IServiceManager additions (informational):
89 >    function getProtocol: TProtocol;
90 >    function getPortNo: AnsiString;
91  
92 < 12. SQL Property Editors now include a checkbox "Allow DSQL Placeholder". This corresponds to the
93 <    GenerateParamNames property and should be set when using DSQL (i.e. '?') style parameters.
92 > 3. IServiceManager improved error handling. Interfaces changed:
93 >    function Start(Request: ISRB; RaiseExceptionOnError: boolean=true): boolean;
94 >    function Query(SQPB: ISQPB; Request: ISRB; RaiseExceptionOnError: boolean=true) :IServiceQueryResults; overload;
95 >    function Query(Request: ISRB; RaiseExceptionOnError: boolean=true) :IServiceQueryResults; overload;
96  
97 < 13. The IBTransaction editor now has a radio button ("Unspecified") which is set when the combination
98 <    of settings is unrecognised. Selecting this radio button has no effect on the settings.
121 <  
97 > 4. IAttachment addition (informational)
98 >    function GetSecurityDatabase: AnsiString;
99  
100 < IBX Change Log  version                 (1.0-5) Sat, 28 Dec 2013 19:22:23 +0000
100 > 5. IStatement: performance counters now updated after each Fetch. GetPerfStatistics
101 >   thus now returns accumulated stats for a select statement from opening a cursor
102 >   up to the last fetch.
103  
104 < 1. TBookmark change conditional compile changed to >= 2.7.0 to match revised availability of change.
104 > 6. DARWIN: uloadlibrary.inc bug fix. Many thanks to Luigi Naimi for correcting
105 >   the problem.
106  
107 < IBX Change Log  version          (1.0-4) Thu, 28 Feb 2013 16:56:13 +0000
107 > 7. Type change: "TPerfCounters = array[TPerfStats] of Int64". Note "Int64"
108 >   replaces deprecated "comp" type.
109  
110 < 1. In a TIBCustomDataset descendent, a generator now only sets the value when
130 <   it is null. This allows for alternative user defined setting of the generator
110 > 10. Testsuite Test10 updated to include thread synchronisation for event reporting.
111  
112 <   Many thanks to Julio Jiménez for this fix
112 > 11. URL Connection Strings: inet4 and inet6 now recognised.
113  
114 < 2. An Error Dialog is now displayed in the Lazarus IDE if IBX cannot find the Firebird Library
135 <   and suggests that the user may have forgotten to install it.
114 > 12. IBUtils: Parse and Make Connect String now recognise URL style loopback syntax.
115  
116 < IBX Change Log  version         (1.0-3) Thu, 22 Nov 2012 22:53:39 +0000
116 > 13. IAttachment.CharSetName2CharSetID is now performed case insensitive.
117  
139 1. Conditional compilation used to limit registration of TIntegerField to
140   Lazarus versions less than 1.1
118  
119 < 2. When a database connection is created, character set is now by default set
143 <   to UTF8 (Unix) or to the current Windows code page (Windows) if in the range
144 <   1250 to 1254.
119 > FBINTF Change Log  version (1.1-1) Tue, 27 Feb 2018 16:51:16 +0000
120  
121 + 1. IBUtils.QuoteIdentifierIfNeeded: Add check for space character.
122  
123 < IBX Change Log  version     (1.0-2) Tue, 09 Oct 2012 09:10:30 +0100
123 > 2. IAttachment: add two new methods
124 >     function HasDefaultCharSet: boolean;
125 >     function GetDefaultCharSetID: integer;
126  
127 < 1. TBookmark change conditional compile changed to > 2.6.2 to match expected availability of change.
127 >   These return, respectively, true if a connection default character set was
128 >   specified and the character set id of the connection default character set.
129 >   The DefaultCharSetID is cached when the connection is opened and hence does not
130 >   require a database lookup.
131  
132 + 3. Avoid exception when a text blob is a stored procedure parameter.
133  
134 < IBX Change Log  version    (1.0-1) Sun, 05 Aug 2012 20:00:04 +0100
134 > 4. Update test suite to include a test for a stored proc returning a text blob.
135  
136 < 1. In IBCustomDataset. Changed CurBookmark from string to TBookmark for compiler versions > 2.6.0
137 <   Necessary because of TBookmark type and TDataSet.Bookmark property change in fpc 2.7.1
136 > 5. IAttachment: add
137 >      function GetRemoteProtocol: AnsiString;
138 >      function GetODSMajorVersion: integer;
139 >      function GetODSMinorVersion: integer;
140 >      function GetAuthenticationMethod: AnsiString;
141  
142 < 2. IBX now registers TIntegerField as a "No Icon" component. This may be removed if the fpc DB
143 <   package is changed to do this (which it should do).
142 >   These results are cached when the connection is opened and hence do not
143 >   require a database lookup.
144  
145 < IBX Change Log  version (1.0-0)  Sat, 28 Apr 2012 16:43:00 +0100
145 > 6. IAttachment: add "function GetConnectString: AnsiString;" This returns the
146 >   connect string used to create/connect to the database.
147  
148 < 1. Add "if active then active := false" to TIBCustomDataset destructor. (Avoid error on database close).
148 > 7. IAttachment: Create Database using SQL statement. The username and password
149 >   are now extracted and used to populate a DPB made available via IAttachment.getDPB.
150 >   It is now possible to use IAttachment disconnect/connect to reconnect to
151 >   a database for which the initial connection was established by a create
152 >   database sql statement. Available in FPC only.
153  
154 < 2. Make use of $STATIC conditional in IBSQLMonitor (Needed for FPC 2.6.0 compliance)
154 > 8. Update Test 1 to test 5, 6 and 7 above.
155  
156 < 3. Database Property Editor: Character Set drop down box now uses "OnChange" rather than "OnCloseUp" to react to changes
156 > 9. IBUtils code tidy up.
157  
158 < 4. Property editors should now correctly resize.
158 > 10. Parameter Block interfaces "find" method. As documented, this should have
159 >   returned a nil interface when the item could not be found. Instead, an empty
160 >   interface item was returned. "Find" now works as documented and will return
161 >   a nil interface if the item cannot be found.
162  
163 < 5. In IBDatabaseEdit.TestClick, the LoginPrompt is now set to the state of the LoginPrompt Checkbox
164 <   (restored original functionality)
163 > 11. DBInformation: support added for isc_info_active_tran_count and isc_info_creation_date.
164 >
165 > 12. DBInformation: New interfaces: IDIRB and IDIRBItem added to support DB Information
166 >    requests with additional parameters. This is to enable support for fb_info_page_contents
167 >    (return of page contents). Response to fb_info_page_contents returned as
168 >    a string with code page CP_NONE.
169 >
170 > 13. DBInformation: Support for fb_info_pages_used and fb_info_pages_free added, plus
171 >    test suite updated.
172 >
173 > 14. DBInformation: Support for fb_info_crypt_key (Firebird 3.0.3 onwards) added as
174 >    a string type, and fb_info_conn_flags (Firebird 3.0.3 onwards) added as an integer type.
175 >
176 > 15. Service Manager: List of protocols supported expanded to include inet, wnet and xnet.
177 >    An overloaded version of IIFirebirdAPI.GetServiceManager also allows a non
178 >    default connection port to be specified.
179 >
180 > FBINTF Change Log  version                             (1.1-0) Sun, 07 Jan 2018 15:20:02 +0000
181 >
182 > 1. Fix issues with setting SQL Param values using SetAsString with Numeric types.
183 >   Scale is no longer ignored.
184 >
185 > 2. Fix issues with setting SQL Param values using SetAsString with Date values
186 >   not in locale format but which are recognised by Firebird. Date values that
187 >   cannot be converted to a string using Pascal library are now passed through
188 >   to Firebird as Text Strings.
189 >
190 > 3. Lookup character set name by codepage amended to ensure that CP_UTF8 returns
191 >   UTF8 and not UNICODE_FSS.
192 >
193 > 4. Charset ID problem. When using Firebird 3, with no default database character set
194 >   and a column has a non-default collation specified, an incorrect character set
195 >   id was being reported that could result in a 'division by zero' error when
196 >   used by IBX. This has now been fixed.
197 >
198 > 5. Move GetCharsetName, CharSetID2CodePage, CodePage2CharSetID, CharSetName2CharSetID,
199 >   CharSetWidth from IFirebirdAPI to IAttachment. This is a better data model as
200 >   the character sets supported can be updated on a per database basis. That is
201 >   it is possible to add a (Firebird) user defined character set to a database.
202 >
203 > 6. Add RegisterCharSet to IAttachment. This is used to register a user defined character
204 >   set supported by Firebird with the API.
205 >
206 > 7. Add missing isc_info_db_read_only to list of decoded Database Information items
207 >   in FBOutputBlock.pas and update test suite to include this item.
208 >
209 > 8. FB30Client: avoid always using "StartMultiple" when only a single database attachment.
210 >
211 > 9. Loading Windows fbclient.dll: when using the FIREBIRD variable to locate the client
212 >   library or finding it by disk location, the PATH environment variable is now also set to
213 >   include the FIREBIRD directory. This is to ensure that the correct dlls in the
214 >   firebird client library dependencies are loaded.
215 >
216 > 10. Testsuite: Ensure consistent UTF-8 output on Windows console.
217 >
218 > 11. Testsuite: Update Windows script to include FPC 3.0.4 in search path.
219 >
220 > 12. FB30Statement: Protect call to "Move" and avoid calling with a nil pointer
221 >
222 > 13. FB30Statement: A check has been added to ensure that all SQL Parameters
223 >    have been given a value (including NULL). Previously, failing to set the
224 >    value of an SQL Parameter could give rise to unpredictable results or
225 >    an SQLDA error.
226 >
227 > 14. FB30Statement/FB25Statement: Set SQLParam "modified" when string value set.
228 >
229 > 15. FBAttachment: Avoid string reference count error when processing an Ansistring
230 >    parameter in an array of const passed to IAttachment.OpenCursor, etc.
231 >
232 > 16. FBAttachment: Allow for WideString and UnicodeString parameters in an array
233 >    of const passed to IAttachment.OpenCursor, etc.
234 >
235 >
236 > FBINTF Change Log  version             (1.0-2) Sat, 04 Mar 2017 14:43:56 +0000
237 >
238 > 1. Change syntax to Mode Delphi
239 >
240 > 2. Change all uses of string type to explicit AnsiString in order to ensure
241 >   compatibility between Delphi and FPC.
242 >
243 > 3. Various syntax changes to ensure Delphi and FPC compilation including GUIDs
244 >   defined for each interface.
245 >
246 > 4. Generics syntax variations for Delphi added
247 >
248 > 5. PChar replaced with PByte expect where an actual string is being referenced,
249 >   where PAnsiChar is used instead.
250 >
251 > 6. Review of type definitions in IBExternals to ensure Delphi compatibility
252 >
253 > 7. Testsuite updated for Delphi
254 >
255 > FBINTF Change Log  version            (1.0-1) Fri, 24 Feb 2017 12:17:57 +0000
256 >
257 > 1. Limit maximum Blob segment read/write to MaxuShort. Avoids data loss with
258 >   large blobs and the FB3 API.
259 >
260 > 2. Update Event Handling algorithm to avoid looping due to recreation of the
261 >   event block.
262 >
263 > 3. Avoid invalid XSQLDA error when the only parameter is updated to null
264 >
265 > 4. Array Handling: fix problem with text arrays with character set none. When the
266 >   DB connection has a default character set (e.g. UTF8), an error is raised by
267 >   Firebird if the space allocated is not enough to allow for transliteration, even
268 >   though it is not required for character set none.
269 >
270 > 5. IBUtils: List of reserved words brought up-to-date
271 >
272 > 6. Add ISQL style performance statistics collection to IStatement
273 >
274 > 7. Add IFirebirdAPI.CreateDatabase variant to allow execution of user provided
275 >   CREATE DATABASE statement.
276 >
277 > 8. Update SQL Statement parsing to allow for Array Dimensions. That is so that the ':' in
278 >   an array dimension is not mistaken for a named parameter prefix.
279 >
280 > 9. Trim function no longer applied to result of GetAsString for SQL_TEXT
281 >   when Character set is octets. Avoids loss of non printable characters at start of string.
282 >
283 > 10. Add function GetPerfStatistics to IStatement. This returns ISQL like performance
284 >    statistics for the last action. Requires use of procedure IStatement.EnableStatistics
285 >    to enable stats gathering.
286 >
287 > 11. API Version information added as constants to IB.pas
288 >
289 > 12. BlobMetaData character set id should now be the same as that given by IColumnMetaData.GetCharSetID
290 >
291 > 13. Firebird Character set "NONE" now interpreted as codepage CP_ACP.
292 >
293 > FBINTF Change Log  version                                      (1.0-0) Tue, 06 Dec 2016 10:33:47 +0000
294 >
295 > 1. Initial Release
296  
173 6. Under OSX, if IBX fails to load libfbclient.dylib, it will now try and load the firebird
174   library using the absolute path /Library/Frameworks/Firebird.framework/Firebird.

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines