Icon Incident Reports Addressed in 2.09

The following is a list of the incident reports addressed in version 2.09. Click on the incident # in order to view the details of the incident report.

Serious Problems

1745ORDER BY NOCASE Clause with a DISTINCT Query Causes NOCASE to be IgnoredNo
1746Using a Constant Value for a Float that Exceeds High(Integer) in Filter Expressions Causes ErrorNo
1750Trying to Delete a Record that is Currently Being Edited Causes a Lock ErrorYes
1762FlushBuffers Method Not Causing an OS Flush to OccurNo
1763Multi-Way INNER JOINs not Working Properly in SQL EngineNo
1764Adding an Index, Deleting the Index, Repairing the Table, and then Re-Adding the Index Causes ErrorNo
1765Closing a Table Not Freeing an Internal Structure Causing Exists Function to FailNo
1766Using RestructureIndexDefs.Add Method in Various Orders May Cause Index Creation to FailNo
1767Using an SQL NOT IN Clause with Multiple Columns from Multiple Tables Fails with ErrorNo
1768Using a Long Constant String Value in an SQL INSERT Statement Truncates the Value at 255 CharsYes
1769Using CopyOnAppend with a DBMemo Control Causes the Memo Field to Not Be Copied to the New RecordNo
1770Using Multiple OR Conditions in a LEFT OUTER JOIN Clause Does not Work ProperlyNo
1772Using a Nested INNER JOIN within a LEFT OUTER JOIN in a SQL Query Does Not Work ProperlyYes
1773Multiple Comments After an SQL Statement Causes an ErrorYes
1776Parameters in SQL Containing a SubQuery Cause Query to Return Incorrect ResultsYes

Minor Problems