Page 1 of 1
Append with Unidac Oracle
Posted: Mon 27 Jun 2011 12:07
by polsol
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
Posted: Mon 27 Jun 2011 13:05
by AlexP
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.
Posted: Mon 27 Jun 2011 13:53
by polsol
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.
Posted: Mon 27 Jun 2011 15:07
by AlexP
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.
Posted: Tue 28 Jun 2011 07:27
by polsol
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

Posted: Wed 29 Jun 2011 09:20
by AlexP
Hello,
Glad to see that the problem was solved. If you have any other questions, feel free to contact us.