|Home » Technical Support » Elevate Web Builder Technical Support » Support Forums » Elevate Web Builder General » View Thread|
|Messages 1 to 2 of 2 total|
|Error after commit|
|Thu, Apr 9 2015 1:42 PM||Permanent Link|
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 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?
|Thu, Apr 9 2015 4:00 PM||Permanent Link|
Tim Young [Elevate Software]
Elevate Software, Inc.
<< ID is an integer field and is a primary key. NEWAUTOCOMM is definied as
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
(email@example.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.