Icon View Incident Report

Serious Serious
Reported By: Carlos Antunez
Reported On: 11/2/2012
For: Version 1.01 Build 2
# 3691 ADO DataSets Based Upon Queries on Large Tables Causes Long Delay When Opening DataSet

I have this table with around 450.000 records in MSSQL Server, never had a single problem obtaining records via the below query.

When I create a dataset using the dataset manager, and I enter the below Query string


I then click on the preview tab to see the results, on the bottom of the form there is a label which says "Obtaining Data " it goes like that for about 30 seconds, then the label changes to Disconnected, and I see no Data results.

Comments Comments
The issue was with how the DataSet Manager was interrogating the defined primary/unique keys on the base table for use with updates. It was doing so in a way that would cause all rows in the table to be selected/read.

Resolution Resolution
Fixed Problem on 11/28/2012 in version 1.01 build 3

Products Affected Products Affected
Elevate Web Builder
Elevate Web Builder Trial