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

attach is the test project.

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 Query: SELECT * FROM test2
if test2 has million record, then system will not smooth work.

so when use Query type dataset, when delete,update,
the ewb server should use the transaction's record old value to load
the original record, after that then do delete, update.

Sorry for my poor english.

--

kenter

<< MS SQL Server, test table sql: >>

Which version of SQL Server and EWB are you using ?

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com

MS SQL Server 2008,
the last ewb1.02b2

<< MS SQL Server 2008,
the last ewb1.02b2 >>

Thanks, I've reproduced the issue and will have a fix available in the next
build, which will hopefully be this week.

Tim Young
Elevate Software
www.elevatesoft.com