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".
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.