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

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 wrote:
> 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 as designed".
>
> I'm slightly confused however that you write that you have an update
> query in your list of "Queries" in the left hand pane. It was my
> understanding that one couldn't establish UPDATE queries in this
> manner
> and save them to the list of queries because the built-in query
> parser
> would refuse to execute an update DML statement (even in "SQL direct"
> mode). How exactly have you achieved this ?
>
>
> Alex

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted