New Incident Reports for 4.21

The following is a list of the new incidents reported for version 4.21. Click on the incident # in order to view the details of the incident report.

Serious Problems

Build

Title

Workarounds

1	2068	SQL DELETE Queries Can Produce Incorrect Record Counts	No
2	2070	Using loPartialKey Option with an Optimized TDBISAMTable or TDBISAMQuery Locate Method Fails	No
2	2073	Setting a BeforeDeleteTrigger Causes BLOB Handle Leak When Deleting Records	No
3	2075	Setting TDBISAMTable.Filtered Property to False Results in a Record Count of 0	Yes
4	2078	Using the OnFilterRecord Event Handler Causes Incorrect Record Display in a Grid	No
5	2082	Delphi 5 and Delphi 6 Builds Not Built with Delphi 5 Update Pack 1 and Delphi 6 Update Pack 2	No
5	2084	SQL CASE Operator Causing Stack Overflow and Access Violations	No
6	2091	ODBC Driver Causes "Another User Has Changed the Record" Error with BDE 5.01	No
6	2092	Filters Not Respecting Existing Ranges When Executing	No
6	2127	Database Descriptions Not Being Saved Properly in Database Server	No
7	2096	Calling TDBISAMTable Refresh Method with OnFilterRecord Event Handler Does Not Filter All Records	No
7	2097	BDE Transfer Utility Causes Error When Trying To Pump Data into Remote Database	No
8	2098	Using a BeforeUpdateTrigger with the TDBISAMEngine Component Causes #9494 Error	No
8	2099	ALTER TABLE Not Working When Only LAST AUTOINC Value Specified	No
8	2100	ALTER TABLE REDEFINE PRIMARY KEY Not Working	No
9	2102	OnFilterRecord Evaluated Too Many Times When Range and Expression Filter Set Also	No
10	2106	Live Queries with No Order By Can Select the Incorrect Default Index for Ordering	No
10	2109	15002 Uncompress Error Triggered When Leaving Table Open During Server Procedure	No
10	2116	TOP Clause Mixed with ORDER BY On Expression Column Causes Incorrect Results	No
10	2118	Using an IN Expression within a LEFT OUTER JOIN Clause Causes Incorrect Results	Yes
10	2121	Exceptions in the OnBeforeUpdate or OnBeforeDelete Trigger Events Can Cause Invalid Parameter	No
10	2122	Table Cursors Not Detecting Changes During Manual Refresh With Active Filters and Ranges	No
10	2125	ODBC Driver Not Retrieving Data Properly When Used with Adobe Acrobat ADBC and Javascript	No
11	2126	Recursive Join in WHERE Clause Causes Incorrect Results	Yes
11	2128	Using DisableControls While Appending a Record and Updating a Memo Field Causes #8962 Error	Yes
11	2129	Possible Access Violation When Using Custom Functions That Return Currency Values	No
11	2134	Table Can Raise an #8965 Error During Open with Concurrent Delete on the Last Record in the Table	No
11	2135	AfterUpdateTriggers Not Showing the Proper Record Contents if Current Record Falls Out of Filter	No

Minor Problems

Build

Title

Workarounds

2	2071	DBISAM Design-Time Package Contains Unnecessary DBISAMUT Unit Reference	No
2	2072	Total Connected Sessions Being Reported Improperly in Database Server After Removing Session	No
3	2076	Setting TDBISAMEngine.TableMaxReadLockCount to 0 Can Cause Divide By Zero Errors	Yes
3	2079	Using the SQL STDDEV Aggregate Function with a HAVING Clause Causes Invalid Floating Point Exception	No
3	2081	Locates that Use a Case-Sensitive Optimized Filter to Perform Search are Slower than Necessary	No
3	2085	Executing UNION ALL With Mixed Blob and Character Columns Causes an AV	Yes
4	2080	Adding a Descending Index Via TDBISAMTable.AddIndex Method Using Only ixDescending Option Incorrect	Yes
6	2087	OldValue Property Not Populated Correctly in TDBISAMEngine AfterUpdate Trigger Event	Yes
6	2088	Compiling DBSYS Utility with Packages Results in Incorrect Reference to the .INI File	No
6	2089	SQL ALTER TABLE IF NOT EXISTS for a Column Still Attempts to Open Table Exclusively	No
6	2090	Manual Refers to DBPwdDlg Unit Instead of Correct DBPwDlg Unit	No
6	2093	Trying to Rebuild DBISAM Packages in Delphi 2005 Results In Error	Yes
10	2107	Manual Missing Information that OnQueryProgress Doesn't Fire for Live Query Results	No
10	2108	Incorrect Description in the Manual for the TDBISAMSession RemoteParamByName Method	No
10	2110	Using Boolean Custom Functions in Filters Causes Incorrect Record Counts	Yes
10	2111	Using a Non-Existent Column in an SQL Query WHERE Clause Does Not Cause an Error	Yes
10	2112	DBSRVR Project Shipped with Build 10 Improperly Includes a Pre-Defined Custom Function	No
10	2114	SQL COALESCE Function Not Clearing Out Previous NULL Values from Other Rows	No
10	2117	SQL ALTER TABLE Statement Requires the STOP WORDS Clause When Only Updating the SPACE CHARS	Yes
10	2119	Using a Function with No Parameters in an SQL Join Causes Error	No
10	2120	Need to Add Support for Using Aggregate Expressions in Single-Row Result Sets	No
10	2123	Mixing Float and Integer Columns in Joins Can Cause Incorrect Results in Some Cases	Yes
11	2130	ZLIBPAS.PAS Unit Contains OutputDebugString Reference	No
11	2131	Cannot Use the ROUND() Function Outside of a SUM() Aggregate Function in an INSERT Statement	Yes
11	2132	Sub-Queries On Tables with Descending Index Matching Selected Column Not Optimized	No
11	2133	ALTER TABLE REDEFINE PRIMARY KEY Not Changing Descending Index Fields to Ascending	Yes
11	2136	Setting a Range and then a Filter Doesn't Change Logical Record Numbers to Reflect Filter	No
11	2137	Incorrect Password Message in DBSYS Utility	No

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap