Append with Unidac Oracle

polsol · Post by **polsol** » Mon 27 Jun 2011 12:07

Using Unidac 3.70.0.17 Oracle in Direct Mode with Devexpress grid, the insert ('add') button on the built in DevEx navigator works fine but if I use Append, then the append button is 'greyed' and inactive.
Suggestions as to why this might be?
Have tried both Unitable and Uniquery and neither work in Append mode.
TIA

AlexP · Post by **AlexP** » Mon 27 Jun 2011 13:05

Hello,

Such behaviour is not connected with our components. To make the Append button accessible, you should set the TcxGrid1DBTableView.OptionsData.Appending property to True.

polsol · Post by **polsol** » Mon 27 Jun 2011 13:53

Hi Alex,

I did that, set both the Append visible and edit properties to true but it still doesn't work. The Append button remains inactive.
Also tried setting Insert edit to true in addition to append edit = true as well - just in case - but append still didn't work.
I think Devart also uses Devexpress. Maybe you can confirm the observation or not.
The insert button does, however, work which is confussing.
I've used Append with ODAC previously without problems. However this was with Delphi 2007 Pro and I'm now using Delphi XE Pro. Not sure this has any relevance.

AlexP · Post by **AlexP** » Mon 27 Jun 2011 15:07

Hello,

I cannot reproduce this problem.

Please try to use standard Delphi components for DB access instead of UniDAC. For example, you can try dbExpress or ADO, and you should connect them with DevEx navigator. If in this case the Append button is not available, please contact devExpress developers.

polsol · Post by **polsol** » Tue 28 Jun 2011 07:27

Hi Alex,

Sorry, problem is with me. Apart from setting the DevEx navigator append to true and vissible to true there is also, under grid optionsdata, a setting for appending true/false that is false by default .
Problem solved.

My bad, sorry for wasting your time

AlexP · Post by **AlexP** » Wed 29 Jun 2011 09:20

Hello,

Glad to see that the problem was solved. If you have any other questions, feel free to contact us.