View Incident Report

Serious

Reported By: Kentersoft
Reported On: 8/28/2013
For: Version 1.02 Build 2

# 3939 Web Server Not Handling ADO DataSet Updates and Deletes Properly

Add record no problem, delete and update record will occur error, use Sql Server Profile, seem when delete and update,
the server part can not locate the original record.

Change Query to table will resolve the problem, but use Sql Server Profile, see when append, update, delete, all generate. If test2 has million record, then system will not smooth work.

MS SQL Server, test table sql:

CREATE TABLE test2
(
   code    nvarchar(20) not null primary key,
   name    nvarchar(20)
)

In ewbserver Define Dataset:

ConnectionType:ADO
Datasetname: test2
RowSource:

Query:
SELECT * FROM test2
WHERE code={code=''}

Base table: test2

Comments

The ADO dataset updating/deleting has been rewritten to use a more generic SQL approach that works better for such datasets.

Resolution

Fixed Problem on 8/30/2013 in version 1.03 build 1

Products Affected

Elevate Web Builder
Elevate Web Builder Trial

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap