Problems with TOracledataset and Dbgrid and Blob-Fields

[M_K;uhn]

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.

 

[Marco Kalter]

Do you have a little demo project to reproduce this?

 

[M_K;uhn]

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

thank you.

 

[M_K;uhn]

the scrolling error occurs if you set queryallrecords to false

 

[M_K;uhn]

Have you tested the Demo-Project ?

the refresh error ?

it's very important for me.

 

[Marco Kalter]

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

 

[M_K;uhn]

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

 

[Ing Rodolfo]

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

 

[Marco Kalter]

We will have a solution soon.

 

[Ing Rodolfo]

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

Please !!!!

 

[Marco Kalter]

We hope to have a fix later this week.

 

[Marco Kalter]

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

 

[M_K;uhn]

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.

 

[Marco Kalter]

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?

 

[M_K;uhn]

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.

 

[Marco Kalter]

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

I can't reproduce this, but we'll investigate further.

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.

This is a Delphi TDBGrid feature. Null fields are displayed as and non-null fields are displayed as .

 

[M_K;uhn]

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.

 

[Ing Rodolfo]

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

 

[M_K;uhn]

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

 

[Marco Kalter]

We'll check it out.

 

[Marco Kalter]

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

 

[Ing Rodolfo]

everything works perfectly fine, thank you for addressing the problems

 

[M_K;uhn]

looks good. no error found.

thank you

 

[Marco Kalter]

Okay, we'll publish this patch.