[Libreoffice-bugs] [Bug 116953] EDITING: UI: Firebird: Migration: Base fails to call QueryEditor for defined database view

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=116953

--- Comment #7 from Drew Jensen <drewjensen.inbox at gmail.com> ---
(In reply to Julien Nabet from comment #6)
> 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
> https://opengrok.libreoffice.org/xref/core/dbaccess/source/ui/app/
> AppController.cxx#1748
> 
> #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
> https://opengrok.libreoffice.org/
> search?project=core&q=XAlterView&defs=&refs=&path=&hist=&type=
> So it seems it's not possible to edit views in those (Mysql, Postgresql...)
> or perhaps I missed something?

You mean that LibreOffice (UNO) dbaccess is not setup to do so yet. Firebird
(MySQL, Postgress also) engine certainly supports ALTER VIEW (and "CREATE OR
REPLACE") command. 

(Going out on a limb here) it seems  there is a chunk of functionality simply
never coded for the firebird, or MySQL, or the Postgress drivers. For the
external RDMBS it isn't really that big a deal as the DBA tools for those are
rather extensive and Base is rather weak with what it supports. But for the
embedded engines there is no other choice, it is the Base UI or SQL commands in
the SQL window.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180610/49fd99c8/attachment.html>