🚀 go-pugleaf

Ohh This is a Hard One.... Maybe Someone from Team-B should look into this
BUG

"Wencheng Chai" <wencheng@wayahead.com.au> wrote in message
news:3f98ac53$1@newsgroups.borland.com...
> 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
>
>