3.1.3

• changed TcsTable to enclose field, table and database names with brackets ( [ ] ) instead of using quotes.
• fixed problem caused by the fact that a query wasn't closed when changing the SQLServer property.
• using ReadAhead together with CacheMaxRecords did not cause the connection to be dropped  correctly. Fixed.
• added support for C++Builder 6.0
• fixed problem in D3-version with Params-editor for TcsStoredProc

3.1.2

• Using LocalEdit together with UpdateObject or UpdateParams would cause SQLQuery to send a (sometimes incomplete) SQL Delete statement to server. It shouldn't send any statement when LocalEdit is on. Fixed!
• Changed the component registration for Delphi 6, all components are now registered but since Borland introduced a TSQLQuery class in Delphi 6 our TSQLQuery is now renamed to TcsSQLQuery (only in D6). Please note that the support for TSQLServer and TSQLQuery (TcsSQLQuery) will be discontinued in SQLQuery v 4.0!
• The Delphi 6 version is now compiled with Delphi 6 update pack 2.

3.1.1

• QueryOptions.csTrimAllStrings was ignored. This is now fixed.
• Fixed: Changing the Datasource did not clear the Dataset.State, now it's reset to dsBrowse if the dataset is active.
• Changed the design time behaviour when setting to Option LocalEdit, previously it cleared the UpdateObject or UpdateParam properties, now it leaves them as is.

3.1.0

• fixed problem with TSQLQuery.Recno raising an exception if trying to read it from a closed query.
• added support for Delphi 6. Please see additional note below.
• added propertys ExecuteOptions and QueryOption to TcsQuery and TcsTable
• added missing event calls on detail refresh

NOTE! 

The Delphi 6 version of SQLQuery doesn't register the classes TSQLServer and TSQLQuery any more. This is because Borland introduced a TSQLQuery class in the dbExpress package, and to avoid conflicts for new users installing SQLQuery under Delphi 6 we decided not to register our classes. For current customers upgrading from prior Delphi versions we have included a registration unit (csOLDSQL.pas) that can be used to register the missing classes manually into a package of your own. Also note that SQLQuery version 4.0 probably won't have any backward compatibility with TSQLServer and TSQLQuery classes. All current customers are recommended to migrate to TcsDatabase, TcsQuery and TcsTable.

3.0.40

• fixed the problem with NULL parameters transalted to DEFAULT at incorrect times, caused by the addition of DEFAULT handling in 3.0.39. DEFAULT values will now only be generated when using UpdateParams to insert a new row in the dataset.

3.0.39

• added DEFAULT values for parameter resolution
• fixed a problem where the SessionBinding did not work correctly, causing transactions to hang
• fixed the UnPrepare so that it won't generate an error message if the temporary stored proc is already dropped
• some minor fixups

3.0.38

• added event OnRecordUpdate. If it's assigned you must perform the updating by yourself. It can be used for datasets with more complex updates, cascaded deletes or complex key generation sequences.
• added support for TIMESTAMP data type. It is translated to ftVarBytes field type.
• fixed the PSExecuteStatement procedure so that updates applied to a TClientDataset are performed correctly.
• fixed an error in TcsDatabase.Onlogin that caused a login even if the login event had a abort statement.
• fixed problem with UniDirectional property in design time package that made it always appear as False in runtime.

3.0.37

• some minor fixups and optimizations with how QuotedIdentifiers are handled. 
• added code so that a TSQLQuery.Close correctly closes a query opened with AsyncOpen.
• fixed a bookmark positioning bug that caused an odd behaviour when inserting rows in a grid.
• removed the DisableControls/EnableControls in RefreshParams that caused master-detail relations only refreshed one level in multilevel relations.

3.0.36

• changed the way SQLQuery handles QuotedIdentifiers so that server roundtrips are minimized. The options are now set when a connection is allocated instead of everytime a sql statement with quotes is executed. This reorganization also fixed some problems with csTablem and csQuery.

3.0.35

• fixed a problem caused by the addition of QuotedIdentifiers in update 3.0.33. The problem is fixed and the default value for QuotedIdentifiers is set to False for TcsQuery. The default value True is kept for TcsTable.
• fixed a problem with InternalPositionToBookmark that was inefficient. This was most notably noticed when having large result sets, as the very crude search algorithm we used caused excessive swapping.
• SQLQuery released the connection at EOF. This caused problems with prepared queries that lost their temporary stored procedure. Problem was corrected by not dropping the connection for prepared queries.

3.0.34

• fixed a problem with TcsQuery using UpdateParams that caused an incomplete SQL statement to be generated when posting an update where a field was unchanged (or changed to the same value it had before entering Edit mode)

3.0.33

• fixed 28 byte memory leak at TCustomSQLServer.Destroy.
• fixed TSQLQueryDatalink so it doesn't refresh the detail dataset on master dataset layout changes (dragging columns in a grid or changing the ReadOnly property of a TField). Note that this change makes SQLQuery work differently than a TQuery, that always will refresh regardless of the changes made to the master row.
• fixed error when selecting multiple rows in a grid (more than 255)
• added an Option - QuotedIdentifiers. This option affects how the UpdateParams SQL statements are generated. Turning this option on will cause the identifiers to be quoted, allowing blanks and reserved words in field names. This Option is ON as default on the TcsTable and TcsQuery components.
• fixed a minor problem with quoted table names containing owner name for the TcsTable component

3.0.32

• fixed problem with pressing Cancel on the login dialog for TcsDatabase.
• fixed problem with using Abort in the OnLogin event.

3.0.31

• fixed the TcsTable.ReadOnly so that it's not possible to modify a dataset that is marked ReadOnly
• added functions to allow a TcsQuery.Refresh. Note that it only does a Close - Open sequence without any cursor positioning.
• fixed problem with the fields editor in the C++Builder version where all fields where defined as ftAutoInc.

3.0.30

• The addition of support for non-updatable fields caused an error "List index out of bounds(0)". This is fixed but please note that the Delphi 3 version does not support the non-updatable fields.

3.0.29

• TSQLUpdate now supports the use of parameters that are calculated fields in the linked dataset
• SQLQuery now correctly sets TField.ReadOnly for fields that are not updatable
• fixed problem with AV when pushing the Cancel button on the login dialog for TcsDatabase
• fixed some minor problems with the property editor for TUpdateParams
• changed the error handling when connection to SQL Server is broken. If a connect was successfull and a later query is executed with the connection broken the TSQLQuery.OnExecuteError event will be fired. If the connection is broken when doing a Post the OnPostError will be called. Note that DBLIB´s error recovery procedures are not 100% foolprof, it might signal a connection as dead even if you get reconnected after a connection failure.
• fixed a problem where an TSQLQuery.Insert required an extra connection

3.0.28

• fixed problem with TSQLQuery.OnDuplicateKey not being fired for SQL error 2627

3.0.27

• moved an error message at connect time to csSQLConst
• added event TcsDatabase/TSQLServer.OnConnectError that fires when failing to aquire a connection to SQL Server
• added event TSQLQuery.OnExecuteError that fires when the exeution of a SQL statement fails
• SQLQuery now fully works with C++Builder 4 and C++Builder 5
• fixed a problem with blob fetches that failed when moving backwards in a dataset. This error was introduced in 3.0.25 where we tried to optimize the way SQLQuery fetches blobs. The change was that SQLQuery not did an explicit READTEXT when retrieving blobs for the last row read. Since this caused other problems we now have reverted the behaviour to how it was before 3.0.25. If you only retrieve the dataset rows sequintial you can set the UniDirectional property to True. Using this blob performance will be optimized but you won't be able to retrieve blobs from other rows than the last read row.

3.0.26

• fixed problem causing SQLQuery missing the IDENTITY field when creating an update statement. The problem occured only when using UpdateParams with UpdateMode=upWhereAll.
• fixed problem with clearing TFields when using UpdateParams

3.0.25

• optimized blob reads
• fixed problem with TcsQuery.OnFilter event not being called correctly

3.0.24

• fixed problem with DBLIB returning the same length for empty TEXT fields as a TEXT field with one character. This problem only affected SQL 7.0 users.
• changed the way blob fields are read (because of the above problem)
• made the TcsDatabase.Datasets list thread safe
• added the Keyword 'MaxProcs' in TcsDatabase.Params
• changed the way IDENTITY field values are fetched on INSERT. It will now work when executing an INSERT from within a thread, if you are using TSQLQuery.UpdateParams to do the update.

3.0.23

• access violation when using Option LocalEdit with TcsQuery fixed

3.0.22

• fixed problem with AV when executing an illegal sql statement
• added checks in several places to assure the server connection is not broken
• fixed problem with Rollback when statement was implicitly rolled back by server
• improved thread functionality by making the internal list of datasets maintained by TSQLServer thread safe.
• fixed problem with AV:s at program termination

3.0.21

• fixed minor problem with design time behavior regarding TcsDatabase.DatabaseName
• fixed problem with incorrect record positioning if using TSQLQuery.RecNo in an OnCalcFields event.

3.0.20

• made the ConnectionPool thread safe. 
• fixed problem with TcsDatabase default DatabaseName settings when using several instances on different modules.

3.0.19

• fixed problem with TEXT containing only one character where truncated
• added public property TSQLServer.Hostname. This can be used to override the default hostname setting thats done by SQLQuery.
• fixed a problem that occasionally caused access violations when using SQLQuery in sevral simultaneous threads

3.0.18

• fixed problem with RecNo not returning correct value in some cases. This problem affected the DBGrid scrollbar behavior.
• Changed AsyncOpen and AsyncClose to work better and allow detail queries in a master-detail set to use the AsyncOpen without problem.
• Changed the blob fetching routine to do several  READTEXT's returning packet-sized chunks instead of doing one READTEXT that returns the whole blob.
• Fixed problem with UseSessionBinding. It now works correctly with SQL 7.0
• Improved logon sequence minimizing logon overhead
• Support for MIDAS 3 IProvider added.
• Fixed problem with changing database name after a query open raised an exception.
• Fixed problem with missing first row when connecting SQLQuery to a DatasetProvider.

3.0.17

• Fixed problem in TcsDatabase.GetDatabaseNames. As we used 'sp_tables' we got an error message if the current user did not have access to all databases.
• Fixed problem in TcsDatabase.GetTableNames where we couldn't get tables names from any other database than the current one.
• Added missing GetDatabaseNames and GetTableNames topics in the help text.
• Fixed problem with AV at program termination. This could occur with queries that where placed on a DataModule and had CacheAllRecord=True. Problem was never reported by any customer but appeared in one of our own applications.

3.0.16

• Fixed problem with connections that where not properly cancelled when an exception occured.
• Improved error detection functions so that a query can be rerun after a failure caused by a broken connection to server.
• fixed problem with trying to drop a temporary stored procedure that was already dropped
• Improved connection allocation/reuse when using TcsTable
• If a logon with empty DatabaseName is done, we will now retrieve the actual database that we are connected to and set DatabaseName accordingly. This will cause SQLQuery to use the default database that's configured in SQL Server for this user.
• Dropped the unnecessary USE dbname statements that where issued even if we already where using the correct database.
• Fixed problem with TcsStoredProc output parameter data conversion from SQL Server -> Delphi format

3.0.15

• Fixed minor problems in UpdateParams property editor (got all fields selected when reopening editor)

3.0.14

• Fixed minor problem with AV:s when using UpdateParams property editor

3.0.13

• Fixed problem with message "No Databasename assigned to query" in IDE when trying to modify TcsQuery.UpdateParams in IDE

3.0.12

• Fixed problem when using .asDate when assigning values to stored proc parameters
• added quoted identifiers with TcsTable so that table names with spaces can be used

3.0.11

• Fixed some minor problems when assigning TcsStoredProc.StoredProcName at runtime
• Made a minor change in the TSQLQuery destructor

3.0.10

• Fixed problem with connections that where not released when doing a SQLQuery.Free.
• Fixed problem with string parameter lengths for TcsStoredProc
• Added property TcsStoredProc.AllowEmptyStringParams. This will allow you to send empty strings to a stored proc and not have DBLIB assign NULL to it. The DBLIB stored procedure API always assumes that a zero-length string parameter is NULL. With this option you can send an empty string that's not NULL.

3.0.9

• Added missing UnPrepare that should have been executed when the TSQLQuery.SQL is changed.

3.0.8

• The handling of BIT fields has been changed back to they way it was done in version 2.x.x
• Fixed problem with TcsStoredProc not retrieving parameters when StoredProcName was changed in run-time.
• Changed TcsStoredProc to support empty strings (not having a NULL value).
• Fixed a problem with DBLIB error handling that sometimes caused an access violation.

3.0.7

• fixed problem with TcsStoredProc.ExecProc not binding the connection even if session binding was activated.
• found and corrected the problem causing SQLQuery to behave bad in D5 new Datamodule Designer.

3.0.6

• fixed problem with Delphi5 IDE using datamodules.

3.0.5

• fixed problem with OnFilter-event not beeing triggered correctly
• fixed error in RecNo property during CalcFields event
• fixed error with IDENTITY smallint and tinyint fields
• improved error recovery. Before executing a query on an open connection, any pending results are cancelled.
• improved threading functions. Any query that's executed in a thread will automatically spawn a new connection. Also, when using RecordCountMode=cmSQLCount, SQLQuery will detect if the parent query is running in aother thread than the main thread and use a own connection for the 'select count(*) from ..'
• added SessionBinding to SQLQuery as TSQLServer.UseSessionBinding and TcsDatabase.Params.Values['UseSessionBinding=Yes']. With sessionbinding all connections for a TSQLServer or TcsDatabase component share the same lock space and can be controlled as one atomic transaction. This function is very useful in situations where queries in different connections causes locking problems or where you want to have transaction control over several connections. For further info, see the help text.
• corrected help text for TcsTable.Exclusive, it is implemented!

3.0.4

• removed the FreeLibrary at Finalization.
• removed the name resolution from TcsDataset.SetDatabaseName
• csTable failed to use ftAutoInc fields as unique keys when updating rows
• included the .dcp in the installation
• updated the DynamicSQL demo to use a TcsTable
  

3.0.3

• fixed problem when using tables with more than 255 fields

3.0.2

• fixed problem with TcsStoredProc not retrieving stored proc
  parameters in the IDE when the stored proc name included the owner.

3.0.1

• changed RecordCountMode cmSQLCount so that it uses a unique
  connection instead of the BaseConnection to improve thread safety.