Problem: CancelUpdate FAILS for a DataGrid bound to Oracle database

Problem: CancelUpdate FAILS for a DataGrid bound to Oracle database

Post by UUne » Wed, 14 Jul 1999 04:00:00

MyDataControl.Recordset.CancelUpdate method fails when there's any error on
Oracle database-server while trying to update a New record (bound thru
DataControl and displayed using bound DataGrid). For example, if a key-value
is missing, or a column that cannot be NULL is being updated with NULL
value, Oracle returns error message which DataGrid displays correctly.
There's only one way out of this situation, which is to satisfy all
constraints. Even if the user now decides not to continue with the said
operation, and wants to fall back by trying to cancel, calling the
CancelUpdate method fails, generating further error. It goes into an
un-ending loop of error conditions, where the only way out is by providing
all the correct values.

My guess is its the grid which is creating problem. For an existing record,
if I try to modify data which would fail update operation on the database(by
changing numeric data to non-numeric, for example), the grid displays error
message, and also changes back to the old value, by itself.

DataGrid 6.0 (SP3, MSDATGRD.OCX version 6.00.8418, dated Feb 22, '99) bound
to Oracle7.3.3.6 database thru ADO Data Control(version 6.00.8418, dated Feb
22, '99, updated to MDAC_TYP SP3 of Visual Basic6-SP3).

Any help is appreciated.


1. rs.CancelUpdate and a DataGrid

my problem is: I use some textboxes and an ADO DataGrid to edit data
from an access database. Changes in the datagrid are now immediately
realized in the table of the database, changes in the textboxes are
When the user cancels the edit session, rs.CancelUpdate works only
with the textboxes but not with the datagrid. What do I have to do?

Thanks for your help in advance!


2. Class not registered and ADODB

3. DataGrid & CancelUpdate

4. Trashing the Log file on Windows NT

5. datagrid and cancelupdate (Help Please)

6. how can i know the size of free space on a disk??

7. DataGrid adn RecordSet.CancelUpdate

8. Stored Procedure Timing Out

9. Bound Controls retaining changes after cancelupdate

10. Using Data-bound textboxes en the CancelUpdate method

11. Bound Control data refresh after CancelUpdate

12. problem binding a datagrid to an ADO recordset

13. Sybase database bound failure with datagrid