Re: [libreoffice-users] Re: Base - a risky feature of the document display?

2017-11-29 Thread Harvey Nimmo
On Wed, 2017-11-29 at 18:43 +0100, Robert Großkopf wrote: > Hi Harvey, > > > > > > The UPDATE query is allowed (i.e. stored in the queries list) if > > you > > 'edit in SQL view' and then set the 'Run SQL Command directly' in > > the > > SQL editor. If you don't do it this way only SELECT queries

Re: [libreoffice-users] Re: Base - a risky feature of the document display?

2017-11-29 Thread Harvey Nimmo
On Wed, 2017-11-29 at 18:43 +0100, Robert Großkopf wrote: > Hi Harvey, > > > > > > The UPDATE query is allowed (i.e. stored in the queries list) if > > you > > 'edit in SQL view' and then set the 'Run SQL Command directly' in > > the > > SQL editor. If you don't do it this way only SELECT queries

Re: [libreoffice-users] Re: Base - a risky feature of the document display?

2017-11-29 Thread Robert Großkopf
Hi Harvey, > > The UPDATE query is allowed (i.e. stored in the queries list) if you > 'edit in SQL view' and then set the 'Run SQL Command directly' in the > SQL editor. If you don't do it this way only SELECT queries are > permitted. If I try this the message appears: Statement does not generate

Re: [libreoffice-users] Re: Reports Libre Base

2017-11-29 Thread jorge Rodríguez
Hi Peter and all:     I suggest to run LibreOffice Base from Terminal (of Ubuntu), and run the report that you want to do. When it crash, looks the Terminal and usually there you can see what happen. I hope this help, Jorge Rodríguez El 28/11/2017 a las 14:54, Robert Großkopf escribió: Hi

Re: [libreoffice-users] Re: Base - a risky feature of the document display?

2017-11-29 Thread Harvey Nimmo
Hi Alex, The UPDATE query is allowed (i.e. stored in the queries list) if you 'edit in SQL view' and then set the 'Run SQL Command directly' in the SQL editor. If you don't do it this way only SELECT queries are permitted. Cheers Harvey On Wed, 2017-11-29 at 14:34 +0100, Alexander Thurgood wr

[libreoffice-users] Re: Base - a risky feature of the document display?

2017-11-29 Thread Alexander Thurgood
Le 29/11/2017 à 12:27, Harvey Nimmo a écrit : Hi Harvey, Perhaps I am misunderstanding the issue here, but the panel you refer to is only supposed to be a Preview of the document display. So, if you execute a query then you get a preview of the result, which to me, would seem to be "functioning

[libreoffice-users] Base - a risky feature of the document display?

2017-11-29 Thread Harvey Nimmo
In initial Base view there is an area for showing the 'document' or 'none'. The default setting is 'none'. If however, the setting is 'document' and queries are selected, any query of the list is executed as soon as the query is selected (not only on double-click).  As it happens, one of the queri