🚀 go-pugleaf

Hi,

I'm using BCB6(Enterprise Suite) + Update 4 and ADO 2.8 on Windows XP, and
database is Oracle 817. Here is the simple test for the error:

1. Create a simple table.

CREATE TABLE TEST
(
 NO          VARCHAR(4)   NOT NULL,
 DESCRIPTION VARCHAR(255) ,
  /* INDEX */
  CONSTRAINT PK_TEST PRIMARY KEY (NO)
);
Note: DESCRIPTION can be NULL.

2. Create a new application.

3. Drop a TADOConnection, a TADOQuery, a TDBNavigator, a TDBGrid and a
TDataSource on the form.

4. Link ADOConnection to my Oracle 817.

5. Set "SELECT * FROM TEST" to ADOQuery and link all the items in (3).

So far, there is no one line code. Now we are going into the heart part.

Run the application. When I input some characters in field DESCRIPTION and
saved it, everything went well regardless of how many times I had tried.
However, after I cleared DESCRIPTION field and saved it - so far so good,
then I tried to input something in DESCRIPTION and saved it, I got the
error: 'Row cannot be located for updating. Some values may have been
changed since it was last read'.

If I refreshed the dataset, everything went back to normal until I cleared
DESCRIPTION and tried to save something again.

I tried the same test on Oracle 9i and got the same error.

Then tried Delphi7, same error.

Then went back to BCB6 and Orcle 817. This time, I tried to use TADOTable
instead of TADOQuery. I got one MORE error EVariantInvalidOpError with
message 'Invalid variant operation'. EVariantInvalidOpError only popped up
in IDE when I debugged it.

Thanks for any help
Wencheng