<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:serval2412@yahoo.fr" title="Julien Nabet <serval2412@yahoo.fr>"> <span class="fn">Julien Nabet</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - EDITING: UI: Firebird: Migration: Base fails to call QueryEditor for defined database view"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116953">bug 116953</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>serval2412@yahoo.fr
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - EDITING: UI: Firebird: Migration: Base fails to call QueryEditor for defined database view"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116953#c6">Comment # 6</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - EDITING: UI: Firebird: Migration: Base fails to call QueryEditor for defined database view"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116953">bug 116953</a>
from <span class="vcard"><a class="email" href="mailto:serval2412@yahoo.fr" title="Julien Nabet <serval2412@yahoo.fr>"> <span class="fn">Julien Nabet</span></a>
</span></b>
<pre>With Firebird, the pb comes from here:
1748 Reference< XAlterView > xAsAlterableView;
1749 if ( xViews.is() && xViews->hasByName( _rTableOrViewName ) )
1750 xAsAlterableView.set( xViews->getByName( _rTableOrViewName
), UNO_QUERY );
1751
1752 bIsAlterableView = xAsAlterableView.is();
see
<a href="https://opengrok.libreoffice.org/xref/core/dbaccess/source/ui/app/AppController.cxx#1748">https://opengrok.libreoffice.org/xref/core/dbaccess/source/ui/app/AppController.cxx#1748</a>
#0 0x00007fffc9b6c96b in
dbaui::OApplicationController::impl_isAlterableView_nothrow(rtl::OUString
const&) const (this=0x555557c9ed80, _rTableOrViewName="View1")
at
/home/julien/lo/libreoffice/dbaccess/source/ui/app/AppController.cxx:1752
#1 0x00007fffc9b65f7f in dbaui::OApplicationController::GetState(unsigned
short) const (this=0x555557c9ed80, _nId=12317)
at /home/julien/lo/libreoffice/dbaccess/source/ui/app/AppController.cxx:773
#2 0x00007fffc9c333a4 in
dbaui::OGenericUnoController::ImplBroadcastFeatureState(rtl::OUString const&,
com::sun::star::uno::Reference<com::sun::star::frame::XStatusListener> const&,
bool) (this=0x555557c9ed80, _rFeature=".uno:DBEditSqlView",
xListener=uno::Reference to (framework::MenuBarManager *) 0x5555582bd3d0,
_bIgnoreCache=true)
at
/home/julien/lo/libreoffice/dbaccess/source/ui/browser/genericcontroller.cxx:397
Except in hsqldb, searching xAlterVIew returns nothing for Firebird or other DB
types
<a href="https://opengrok.libreoffice.org/search?project=core&q=XAlterView&defs=&refs=&path=&hist=&type">https://opengrok.libreoffice.org/search?project=core&q=XAlterView&defs=&refs=&path=&hist=&type</a>=
So it seems it's not possible to edit views in those (Mysql, Postgresql...) or
perhaps I missed something?</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>