Page 1 of 1

[Solved] Edit a Query - Option is missing / disabled

PostPosted: Mon Sep 16, 2019 6:22 pm
by beersuser
Libreoffice Version: 5.3.6.1 (x64)
Connecting to MS SQL DB
Create a Query - query works fine.
Later, when I want to edit or view the SQL code within the query, I cannot - on the 'Right Click' context menu, the option to edit is missing. In the 'Edit' Menu in Libreoffice Base, the options are all disabled.
Another set of queries against another MS SQL DB can be edited without any problem.
I'm happy to provide any missing info, but does anybody know why these options are not available - I have been on this for hours now.

Re: Edit a Query - Option is missing / disabled

PostPosted: Mon Sep 16, 2019 8:12 pm
by Villeroy
I can reproduce this if I make a Base file read-only.

Re: Edit a Query - Option is missing / disabled

PostPosted: Tue Sep 17, 2019 11:48 am
by beersuser
Thanks for the help - not read only as such, but it led me to think the file may be open elsewhere by someone - which it was!