Print Thread
Page 2 of 3 1 2 3
Re: Problems with TOracledataset and Dbgrid and Blob-Fields
Ing Rodolfo #36516 11/16/09 10:43 AM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
We hope to have a fix later this week.


Marco Kalter
Allround Automations
Re: Problems with TOracledataset and Dbgrid and Blob-Fields
Marco Kalter #36545 11/20/09 01:43 PM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
You can download a fix here. Let me know if this fixes it for you as well.


Marco Kalter
Allround Automations
Re: Problems with TOracledataset and Dbgrid and Blob-Fields
Marco Kalter #36548 11/20/09 03:06 PM
Joined: Oct 2009
Posts: 10
M
M_K;uhn Offline OP
Member
OP Offline
Member
M
Joined: Oct 2009
Posts: 10
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.


Re: Problems with TOracledataset and Dbgrid and Blob-Fields
M_K;uhn #36554 11/23/09 10:43 AM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
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?

Last edited by Marco Kalter; 11/23/09 10:56 AM.

Marco Kalter
Allround Automations
Re: Problems with TOracledataset and Dbgrid and Blob-Fields
Marco Kalter #36558 11/23/09 02:06 PM
Joined: Oct 2009
Posts: 10
M
M_K;uhn Offline OP
Member
OP Offline
Member
M
Joined: Oct 2009
Posts: 10
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.


Re: Problems with TOracledataset and Dbgrid and Blob-Fields
M_K;uhn #36568 11/24/09 11:03 AM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
[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>.


Marco Kalter
Allround Automations
Re: Problems with TOracledataset and Dbgrid and Blob-Fields
Marco Kalter #36573 11/24/09 11:34 AM
Joined: Oct 2009
Posts: 10
M
M_K;uhn Offline OP
Member
OP Offline
Member
M
Joined: Oct 2009
Posts: 10
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.

Re: Problems with TOracledataset and Dbgrid and Blob-Fields
M_K;uhn #36585 11/25/09 03:38 AM
Joined: Nov 2009
Posts: 4
I
Member
Offline
Member
I
Joined: Nov 2009
Posts: 4
I have the same problem,Record has been changed by another user
my projects are unfinished, and am having problems, time is money.... Please !!!!


Re: Problems with TOracledataset and Dbgrid and Blob-Fields
Ing Rodolfo #36587 11/25/09 08:25 AM
Joined: Oct 2009
Posts: 10
M
M_K;uhn Offline OP
Member
OP Offline
Member
M
Joined: Oct 2009
Posts: 10
I've sent a new Demo-Project to "support@allroundautomations.com".

Re: Problems with TOracledataset and Dbgrid and Blob-Fields
M_K;uhn #36590 11/25/09 10:28 AM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
We'll check it out.


Marco Kalter
Allround Automations
Page 2 of 3 1 2 3

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.037s Queries: 15 (0.010s) Memory: 2.5592 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-05-05 21:51:43 UTC
Valid HTML 5 and Valid CSS