I have problems with using a Toracledataset a TDBgrid and Blob-Fields in the SQL-statement.

Refreshing the dataset or scrolling the DBgrid causes an accessviolation.

I'm using Delphi 2010 and Oracle 11.

Under Delphi 2006 and DOA 4.1.1.0 it all works fine.

What do i wrong.

Do you have a little demo project to reproduce this?

i sent the demo-project to support@allroundautomations.com

thank you.

the scrolling error occurs if you set queryallrecords to false

Have you tested the Demo-Project ?

the refresh error ?

it's very important for me.

We have received your project and will look into this shortly.

Have you tested our Demo-Project.
We are still waiting.

I have the same problem
is very important to resolve to continue the projects.

We will have a solution soon.

any news on this problem?
is very important to resolve to continue the projects.

Please !!!!

We hope to have a fix later this week.

You can download a fix here. Let me know if this fixes it for you as well.

the refresh works fine.

But now. If I open a dataset and call edit,i get the message "Record has been changed by another user".

In the Demo-Project i sent to you , add a rowid in the sql of "Set1" and try editing in the grid. It is not possible.

I tested this, and it seems to work fine. Can you double-check this with the demo project and the table data you sent us?

i tested it again.
the error occurs if a blob field is not empty.

when i edit a line which contains an emtpy blob field all works fine.
But if there is data in the blob column, i always get an "changed by another user ... "-error.

i've tested it in a 2.project too. With only a grid,a dbnavigator ,an oraclesession and an oracledataset. I've created a table with 3 columns
2 varchar2 fields an a blob field. It has the same behavior.
If the blob field is filled i can't edit any field in the line.

furthermore i've seen ,that you can write data in the blob column (if empty) by writing in a blob-dbgrid-cell. you can see before "(HugeBlob)" and after "(HUGEBLOB)". Is this an error or a feature.
Because the user can't read his changing.

[quote]i tested it again.
the error occurs if a blob field is not empty.[/quote]
I can't reproduce this, but we'll investigate further.

[quote]furthermore i've seen ,that you can write data in the blob column (if empty) by writing in a blob-dbgrid-cell. you can see before "(HugeBlob)" and after "(HUGEBLOB)". Is this an error or a feature.[/quote]
This is a Delphi TDBGrid feature. Null fields are displayed as <Fieldname> and non-null fields are displayed as <FIELDNAME>.

I tested again on 2 Databases in several schemes,it's allways the same.
if the blob column owns data i cant edit any field in the row of the TDBgrid.
The rows with empty blobs make no problems.

I try testing on a clean system.

I have the same problem,Record has been changed by another user
my projects are unfinished, and am having problems, time is money.... Please !!!!

I've sent a new Demo-Project to "support@allroundautomations.com".

We'll check it out.

You can download a new fix here. Let me know your findings.

everything works perfectly fine, thank you for addressing the problems

looks good. no error found.

thank you

Okay, we'll publish this patch.