Icon View Incident Report

Serious Serious
Reported By: Terry Swiers
Reported On: 2/18/2010
For: Version 2.03 Build 8
# 3152 Queries/filters Not Refreshing on Empty Table After Inserting First Row

If you have a sensitive query on a newly created empty table and create a record that matches the where criteria, a new record created with that query does not show up in your result set. Once the table has had at lease 1 record created in it, there isn't any issue.

Steps to recreate from inside EDB Manager:

1. Create a new table with a varchar(20) field named Field1. No indexes or
any other changes are needed.

2. Execute the following query with Request Sensitive set to true.

select * from test where field1 = 'ABC'

3. Insert a record and enter ABC into field1. Click Post.

At this point, the record will disappear from the results. Refresh the query and the result will show and subsequent entries into the table will show as they are entered.

This only occurs when creating the first record in a newly created table AND there is a where clause (via TEDBQuery) or filter (via TEDBTable). Once a record has been created in the table, even if the table is emptied out, everything works as expected.

Resolution Resolution
Fixed Problem on 2/19/2010 in version 2.03 build 9

Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial