DBCombobox and TOracledataset

[Betz]

Hello,
I have a problem with the use of a DBCombobox together with TOracledataset.
The DBCombobox is used to show the value of a field out of the query in the TOracledataset. The itemlist of the DBCombobox is filled with all actually used values of this field.
The Toracledataset is active and the correct value is shown in the DBCombobox.
Now my first problem:
When I select the value in the DBCombobox and do a CTRL+C to copy the value, the TOracledataset starts a refreshrecord, changes the status to dsEdit and the value is not copied to the clipboard. This seems to me an error, because Ctrl+C is always a read and should not change the status.
My second problem is similar.
The status of the TOracledataset is dsBrowse and I try to copy the value out of the clipboard into the Comboboxfield by using CTRL+V the TOracledataset starts a refreshrecord, changes the status to dsEdit and after this refresh, the old value is again in the combobox-Field.
How can I subpress this Refreshrecord procedure when I try to copy or paste the value to DBCombobox?
Copy or Paste work without refreshrecord on a DBEdit field.

Best regards

 

[Marco Kalter]

It seems to me that a control or an event handler is changing the dataset state to dsEdit. Can you verify this?

 

[Betz]

Dear Marco,

Thanks for the fast reply.

I have not added any event handler.

I took only the components to the form, link them (datasource...) and open the database without adding any further code to the components and events.

I don't know if it is possible to link documents in the forum, so I have replied to the Mail from your support and have added my short test application that uses your DOA_EMP table for the test.

Best regards

 

[Marco Kalter]

Thanks. Can you also let me know your Delphi and Direct Oracle Access version?

 

[Betz]

Hello,

I use Delphi7 and DOA 4.06

 

[Betz]

Hello,

any Update on this Item?

Best regards

 

[Marco Kalter]

Not yet, I will get back to you shortly.

 

[Betz]

Hi Marco,

What's the status of this Request.
It's again two weeks.

Best regards

 

[Marco Kalter]

Sorry for the delay, we still need to look at this.

 

[Betz]

Dear Marco,

Now it's three month without any update from you.
When can I get a result to this request.

Best regards

 

[Marco Kalter]

We will hopefully have an answer next week.

 

[Betz]

Dear Marco,

What is the status on this.
It's now more than 4 month.
In October, I got a response from you that you will answer shortly.
I think the 'shortly' period is over after 4 months.

Best regards

Betz

 

[Betz]

Dear Marco,

status please

Best regards

Betz

 

[Marco Kalter]

We have not been able to reproduce this. If you can send me a little demo project, we'll have another look.

 

[Betz]

Hello Marco,

Sorry for the long delay, I had other tasks and I also had problems to create a short program to reproduce the problem.

I was only able to reproduce one of the problems in a short program.
The attached short demo shows the problem that the dataset goes to the Edit mode when I do a copy (ctrl+C).
In my opinion, this is an error because a copy cannot change data, why then switching to 'Edit'.

When this Edit-problem is solved, then we can close this task. If the other errors came up again, I will open a new task.

Marco, can you please tell me how to add an attachment?

Best regards

 

[Marco Kalter]

You can send it to support@allroundautomations.com.