Incident Reports Addressed in 2.02

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

Serious Problems

Build

Title

Workarounds

1	2779	ElevateDB Manager Not Handling Large Fonts Correctly	No
1	2784	Using Optimistic Locking Can Cause Row Lock Errors When Updating More than One Row	No
1	2786	Using an Active Index that Includes a GUID or CHAR Column Can Cause AV in TEDBTable	No
1	2787	TEDBTable CancelRange Does Not Cancel Range Completely When Used with Un-Optimized Filter	No
1	2788	Using a RANGE Clause with Multiple Correlated Sub-Queries Can Cause Incorrect Results	No
1	2792	Stopping the ElevateDB Server While Sessions Are Connected Can Cause AV in Remote Sessions	No
1	2793	Delphi 5 Loses All Settings when ElevateDB Design-Time Package is Loaded	No
1	2794	Migration of Table Data that Contain BLOB Columns Fails with Exception	No
1	2797	TEDBQuery OnProgress Event Handler Firing Continuously When Progress Hits 100%	Yes
1	2800	A Write Error During the Final Portion of an Alter Table Can Cause Version Mismatch Errors for Table	No
1	2802	Using Computed Expressions in Derived Tables Results in Conversion Error	No
1	2805	Using Remove Server Session Task Link in ElevateDB Manager Can Cause Error	No
1	2806	Restoring a Backup to an In-Memory Database Causes an Exception When Restored Tables Are Opened	No
1	2807	Incorrect Error Position Indicated When Comments are Present in SQL Statement	Yes
1	2808	ElevateDB .NET Data Provider Visual Studio Plugin Contains Incorrect Assembly Reference	No
1	2809	Transaction Commit or Rollback Can Cause an AV	No
1	2811	Sessions that Contain Functions that Reference Other Functions Cause AV During Dead Session Removal	No
1	2812	Changing the Active Index in TEDBTable with an Active OnFilterRecord Event Handler Causes Error	No
1	2813	UNIQUE Constraints Not Being Enforced Properly When NULLs Present in Constraint Columns	No
1	2815	Calling Refresh After Setting a Range Can Cause Invalid Blank Rows with Remote Sessions	No
1	2816	Executing a SELECT Statement with a JOIN Containing a Filter Condition Only Causes AV	Yes
1	2817	Executing a Query with a Parameterized IN Sub-Query Returns Same Results with Different Parameters	No
1	2818	IGNORE MISSING UPDATES Clause Not Working for LOAD UPDATES Statement	No
2	2819	Executing a Script in the EDB Manager that Includes Log-Generating Statement Causes Multiple Windows	No
2	2820	Altering a Table Immediately After Publishing Causes a Version Mismatch Error When Table Is Opened	No
2	2823	Using TEDBDataSet Locate Method with Delphi 2009 Causes	Yes
2	2824	Remote DataSet Navigation Results in Incorrect Row Display	Yes
2	2827	Referencing a Different Database In a UNION/EXCEPT/INTERSECT Query Causes Dangling Read Lock	No
3	2834	Columns Incorrectly Allowed with Aggregate Functions in Expressions in SQL Statements	Yes
3	2835	Altering the Number of Columns in a Table Constraint Can Corrupt the Table	No
3	2836	Executing a Script with OUT Parameters in EDB Manager Causes Dialog to Be Shown Multiple Times	No
3	2838	Empty Remote Ranges Do Not Refresh Properly When New Row Inserted Into Range	Yes
3	2840	Heavy Concurrent Inserts Can Cause #601 Corruption Error with a Session	No
3	2843	Referencing a UNIONed SELECT Column Correlation Name in an ORDER BY Causes Incorrect Sort	No
4	2848	Debugging Scripts in the ElevateDB Manager Using a Remote Session Causes a Hang	No
4	2852	NEWROW BLOB Column Values Are Always Empty in AFTER INSERT Triggers	Yes
4	2853	Installation of .NET Data Provider Does Not Work Properly with Visual Studio Server Explorer	Yes
4	2854	Moving Indexed Columns in an ALTER TABLE Statement Can Cause Error	No
4	2856	Calling a Procedure from Within a Trigger Can Cause an AV if the Procedure Returns a Result Set	Yes
4	2857	Clearing the Contents of a TDBMemo Control Does Not Work	No
4	2859	Exceptions Raised During the Execution of a Job Can Cause the ElevateDB Server to Terminate	No
4	2860	Trying to Compile the Lazarus Packages Causes Compilation Errors	No
4	2861	Dropping a Column Referenced in a Trigger in an ALTER TABLE Statement Causes Incorrect Error	Yes
4	2863	DISTINCT, UNION, EXCEPT, and INTERSECT Queries with More than 4 Columns Cause Incorrect Results	No
5	2864	Index Navigation Can Cause Array Index Error Under .NET	No
5	2865	Index Navigation Can Skip Rows Due to Read-Ahead Optimization	No
6	2869	Help Files Not Installed Into Correct Namespace in Delphi 2009	No
6	2871	Triggers Not Working Properly If DDL Statements Cause Reload of the Database Catalog	No
6	2873	Trying to Connect to a Database with Views Causes Object Reference Error	No
6	2874	Bookmarks Not Working Properly with Delphi 2009	No
6	2876	Assigning a Script to the CommandText Property of an EDBCommand Object Causes Compilation Error	No
6	2877	Setting a BLOB Column to an Empty String Causes The Existing Text to Still Show	No
7	2890	Deleting All Rows From a Table Can Cause #601 Cannot Find Index Page Error	No
7	2892	Subtracting a Day Interval From a Date Across Year Boundaries Causes Incorrect Results	No
8	2903	Executing Query that Uses Same Derived Table Correlation Name as Existing Query Can Cause AV	No
8	2906	A CONTAINS Filter Can Cause an AV During Navigation of the Dataset	No
8	2907	ALTER JOB Followed By PUBLISH DATABASE Statement in a Script or Job Causes Hang Due to Lock Conflict	No
8	2908	Deleted BLOB Space Not Being Re-Used Properly	No
8	2909	Using EXTRACT Function with Sensitive Query Result Set in Remote Session Can Cause Compilation Error	No
8	2910	GUID Columns Not Displayed Properly in Visual Studio Query Designer Result Set Grid	Yes
8	2911	Visual Studio Query Designer Using Improper SQL Syntax for JOINs	No
8	2912	Job Start Times Can Drift According to the Finish Times	Yes
8	2914	Cannot Use ODBC Driver in MS Access Due to Reserved Error -7778	No
8	2915	Embedded CRLF Pairs in CLOB Values Being Converted to Only CR Characters in IMPORT TABLE	No
8	2916	ElevateDB Requiring OnRemoteReconnect Event Handler for Re-Connection	Yes
8	2917	Querying the Files Table in the Configuration Database While File Creation in Progress Causes Error	No
8	2920	External Procedure Parameter Names Being Changed During CALL Execution	Yes
8	2922	Insensitive Query Result Sets Refreshing When They Should Remain Static	No
8	2924	Using Views in Joins in a SELECT Statement Results in Very Slow Performance	No
8	2925	ODBC Driver Not Working Properly with Word and Excel When Importing Data	No
8	2926	CAST Function Returns Incorrect Results When Casting Date and TimeStamp Values to Strings	No
9	2929	Migrating a Database with KeepTablesOpen Setting Turned on for the Session Causes #100 Error	No
9	2930	MIGRATE DATABASE Slows Down Considerably in .NET with Many Tables in the Source Database	No
9	2931	Altering a Stored Procedure with No Parameters Using a Remote Session Causes Error in EDB Manager	No
9	2934	Populating BLOB Parameters via a Stream in Delphi 2007 Unicode Causes Incorrect Data Population	No
9	2935	Large Backup Restore Operation May Fail with an Uncompress Error	No
9	2937	Changing the Action Time for a Trigger Does Not Take Effect Immediately	No
9	2939	Opening a Table Containing a DATE Column with Microsoft Access and a Remote Session Doesn't Work	No
9	2940	Unicode EDB Manager Saving SQL Editor Files as ANSI Text	No
9	2941	Concatenating Compressed CLOB Columns in SQL Can Cause Embedded NULL Byte Characters	No
9	2942	Executing a DELETE Statement Can Cause #601 Invalid Page Number Specified Error	No
9	2943	Trying to Continue Debugging a Script Window after a Close Attempt in the EDB Manager Can Cause AV	No
9	2944	Referring to a Column by Name Instead of the Correlation Name Can Cause ORDER BY to Not Work	Yes
10	2947	CREATE VIEW Statement Can Result in an Incorrect View Definition	No
11	2950	CopyOnAppend Causing BLOB Columns To Share the Same Internal Offsets	No
11	2954	Trying to Open a Table in a Database with Read-Only Attributes Causes #401 "Table Not Found" Error	No
11	2955	TEDBEngine UseLocalSessionEngineSettings Property Not Being Restored Properly During Project Load	No
11	2956	ElevateDB SQL Reference Help Not Being Loaded Properly in ElevateDB Manager	Yes
11	2957	XML Export from BLOB Columns in .NET Data Provider Results in Incorrect XML Data	No
11	2958	UNIONed SELECT Statements Not Binding Column References Properly	No
11	2959	.NET Data Provider Causes LOWER() Function to Return Results as UPPER() Function	No
11	2963	Restoring a Database Can Cause Issues if New Tables Were Added Since Backup	No
11	2964	Unicode ElevateDB Manager Experiencing Random AVs	No
11	2965	Remote Encryption Password Not Being Set Properly in ElevateDB ODBC Driver	No
11	2966	Single-Row Aggregate Queries with Only Constants and Aggregate Functions Return Incorrect Results	No
11	2967	SQL Can Cause "Value Cannot Be Null" Error When Executed Using .NET Data Provider	No
11	2968	Creating a Database with an Invalid Path Can Cause Database to Become Read-Only	Yes
11	2969	Using REFERENCES Clause for Columns Causes Parsing Error in CREATE TABLE Statement	Yes
11	2971	Cannot Migrate Certain Older DBISAM Tables with BCD Columns to ElevateDB	No
11	2972	Jobs Defined as EVERY x HOURS Not Executing After the First Day Completes	No
11	2973	Jobs Defined as WEEKLY Not Executing Properly	No
12	2978	Weekly Scheduled Jobs Not Firing on Scheduled Days	No
12	2980	Tables with Indexed Computed Columns Can Cause AV When Opened	No
12	2981	UNION Queries Can Cause Index Page Size Error with Unicode Databases	No
12	2982	Calling the Same UDF More Than Once in the Same Expression Can Cause Incorrect Results	No
12	2983	Jobs Scheduled as Every X Hours Are Firing Every X+1 Hours Instead	Yes
12	2984	Compiling an EDB Application with Range Checking Can Cause Range Check Errors at Runtime	No
12	2985	BDE Migrator Module Not Setting Transliterate Parameter Properly for Paradox Tables	No
12	2986	Concatenated CHAR or VARCHAR Columns Can Cause Error When the Length Exceeds 1024 Characters	No
13	2987	Using Locate Method on an Indexed Computed Column or CLOB Column Can Cause Locate to Fail	No
13	2988	Migrating a BDE Database to a Unicode ElevateDB Database Fails with Value Errors	No
13	2989	Row Updates that Only Update Non-Indexed Columns Can Cause Errors in Other Sessions	No
13	2990	Altering an Existing Index Can Cause Either a Corrupted Index or an Index Page Buffer Error	Yes
14	2998	Trying to Open an Updateable View with Correlated Sub-Queries in the SELECT List Causes AV	No
14	3000	Executing a UNION Query with Expressions in the SELECT List Can Cause AV	No
14	3001	Upgrade Reverse-Engineering Not Working Properly in Unicode EDB Manager	No
15	2891	Executing a DELETE Statement on Table with Trigger that Starts Transaction Can Cause Lost Deletions	Yes
15	3015	Login Attempts that Wait for User Input Do Not Time-Out Properly After the Server Timeout is Reached	No
15	3016	Trying to Alter an Existing Table and Add a Foreign Key that References the Same Table Causes AV	No
15	3018	Self-Referencing Triggers Not Executing Properly and Stop After One Recursion	No
15	3019	Insensitive Result Sets are Generated Very Slowly When Forced Buffer Flushing Turned On	No
15	3020	ElevateDB Data Provider EDBDataReader GetBytes Method Returning Data with All Null Bytes	Yes
15	3021	COPY FILE Statement Can Cause Incomplete Destination File During Interrupted Remote Copies	No
15	3022	Sub-Select Queries that Reference the Same Table as the Outer Query Can Cause Incorrect Results	No
15	3024	Updating a Row in a Table with a Text Index on a CLOB Column Can Corrupt the Text Index	No
15	3025	Aggregate Functions Not Returning Correct Results with Single-Row SELECT Queries with WHERE Clause	No
15	3026	Trying to ALTER a Prepared Stored Procedure Can Cause Access Violation When Procedure Executed	Yes
15	3027	Invalid Column References Cause Incorrect Error Message When Table Qualified with Database Name	No
15	3028	Reverse-Engineering Dialog in EDB Manager Reports Database Error When Cancelling Upgrade	No
15	3029	Internal PadL and PadR Functions Not Working Properly	No

Minor Problems

Build

Title

Workarounds

1	2780	ElevateDB Manager Not Showing Progress Accurately During Long Processes	No
1	2789	SQL Manual Has Incorrect Information Regarding Primary Key Behavior	No
1	2790	SQL Help Files Were Not Updated Properly	No
1	2795	Editing a Session in the ElevateDB Manager Can Cause "Session Name is Missing" Error	Yes
1	2796	FreeNotification Not Being Removed Properly for Destroyed TEDBDatabase Components	No
1	2798	Internal OnFilterRecord Method Does not Handle Exceptions Properly	No
1	2799	Using the RANGE Clause with Sensitive Result Sets Can Result in Incorrect Results	Yes
1	2804	Using an ORDER BY with a UNION/EXCEPT/INTERSECT Query and a Column Correlation Name Causes Error	No
1	2810	Opening a Table with an Invalid Filter Prevents Table Open from Occurring	Yes
1	2814	SQL Manual Shows Incorrect Syntax for SQL/PSM IF Statement	No
2	2821	Move Down Button Does Not Work for Columns or Parameters in the EDB Manager	No
2	2822	EDB Manager Reverse Engineer Generating Duplicate Table Triggers	No
2	2825	EDB Manager Form State Not Being Restored Properly When Maximized and SQL Window Open	No
2	2826	Specifying More Values Than Columns Causes in an INSERT Statement Causes an AV	Yes
2	2828	Setting an Invalid Filter in the EDB Manager Does Not Raise an Exception	No
3	2837	VCL Unicode Example Projects Contain Invalid TStringField References	No
3	2839	TEDBTable FindNearest Method Not Working Properly with Active Filter Set	No
3	2841	Hitting F8 Without an Active SQL Window Causes AV in ElevateDB Manager	No
3	2842	The TEDBSession CurrentRemoteID Property is Returning an Incorrect Value	No
3	2844	Rows Locked Manually Using LockCurrentRecord Method Can Cause Memory Leak	Yes
4	2850	Adding a Description to a Function or Procedure Parameter Causes Error in ElevateDB Manager	No
4	2851	Reverse-Engineering Generates Incorrect SQL for VIEW WITH CHECK OPTION Clause	No
4	2855	Unicode ElevateDB Manager Does Not Compile Properly Under Delphi 2009	No
4	2858	Attempting to CAST an INTEGER to an Incompatible Interval Value Causes a Conversion Error	No
4	2862	Multiplying or Dividing INTERVAL Values Causes Incorrect Results	Yes
5	2866	Derived Tables Not Allowing ORDER BY Statement in INSERT..SELECT Statements	No
6	2868	FETCH Statement Causes AV when Number of Target Variables Does Not Match Columns	Yes
6	2870	TEDBSession OnRemoteTrace Event Not Showing Correct Trace Record Information	No
6	2872	TEDBEngine Component EngineType Property Not Changing Properly When Loading New Project in IDE	No
6	2875	Queries Upon Non-Updateable Views Not Using Indexes for Optimization	No
7	2889	Incorrect Default Increment Values When Altering a Table in ElevateDB Manager	No
7	2923	EDBCommandBuilder Constructor Not Initializing DataAdapter Property Properly	Yes
8	2904	Cannot Run Multiple Instances of the ElevateDB Server as a Service on the Same Machine	No
8	2913	SQL Manual Shows Improper Syntax for Interval Values	No
8	2918	varShortInt Not Handled Properly as a Variant Value for Parameters in Delphi 2009	No
8	2919	Exceptions Being Displayed in EDB Manager Script Debugger with Pause On Exceptions Un-Checked	No
8	2921	.NET Data Provider EDBConnectionStringBuilder Improperly Defaulting Compression to Level 6	No
9	2932	SQL Editor Caret Disappears When Scrolling Horizontally in the EDB Manager	No
9	2933	Stored Procedure Parameter Descriptions Not Being Populated During Alter in EDB Manager	No
9	2936	Remote Store Selection in EDB Manager Not Working Properly	Yes
9	2938	Changing the OF Clause of an UPDATE Trigger Does Nothing in the EDB Manager	Yes
9	2945	Executing a CREATE TABLE..LIKE Statement with LIKE Table Prefaced with Database Name Causes Error	Yes
9	2946	Visual Studio TableAdapter Designer Not Working Properly with Procedures Containing Parameters	Yes
11	2960	ElevateDB Manager Explorer TreeView Scrollbars Not Working Properly Under Vista	No
11	2961	ElevateDB Manager SQL Editor Exhibits a Display Issue When Scrolling Horizontally	No
11	2962	Foreign Key Constraint Violation Errors are Indicating the Incorrect Table Names	No
11	2970	Trying to Create a Temporary Table in the Configuration Database Causes AV	Yes
12	2977	GUID Parameters Not Working Properly with TableAdapters Under .NET	No
14	3002	Executing an INSERT, UPDATE, or DELETE Statement Against the Configuration Database Could Cause AV	No
15	3013	Importing an Empty CSV File into a Table Causes Error	No
15	3014	Creating a Copy of a Session in the EDB Manager Causes the Session to Use the Existing Session Name	No
15	3017	Extra Text After the Last END Block of an SQL Script Does Not Raise an Exception	No
15	3023	Clicking on Column Header of Indexed Column in EDB Manager Data View Does Nothing	No

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap