Hi there,

i am a newbie in EWB but programming with Delphi for nearly 25 years.

i have a Problem in EWB updating a database row accessing with ADO (MS-SQL Server). After commiting the transaction i get the error:
"Database commit Response error: cannot find the row for updating:
ID=103
NEWAUTOCOMM=null

Line 1"

ID is an integer field and is a primary key. NEWAUTOCOMM is definied as char(1).

It looks for me as if the dataset is matching the NEWAUTOCOMM with "= null" instead of "Is null". And thats why its not finding the row.

Is it possible to set a property like UpdateMode=upWhereKeyOnly as i can do in datasets in Delphi?

If not, do you have a solution for my problem?

Best regards

<< ID is an integer field and is a primary key. NEWAUTOCOMM is definied as
char(1).  >>

If ID is the primary key, then that's all that EWB will use to find the row.
Something else must be going on, so please contact support
(support@elevatesoft.com) and get a support session started.  We'll probably
need to see your database, but don't send that unless you're an actual
customer since it will get blocked.

Tim Young
Elevate Software
www.elevatesoft.com