[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [libreoffice-users] Re: SQL Syntax UPDATE


On Tue, 2019-07-23 at 19:03 +0200, Alexander Thurgood wrote:
> Le 23/07/2019 à 18:37, Harvey Nimmo a écrit :
>
> Hi Harvey,
>
> > A bit disappointing though. Is there no possibility for storing
> > those
> > kinds of SQL statements, so that they could be used again?
> > I have a few in mind, and it seems a bit primitive to have to
> > create a
> > clipboard type of text file for that kind of thing.
>
> As yet, and as Robert has indicated, nothing in the Base UI allows
> you
> to save UPDATE queries and run them from the SQL Query UI. It has
> unfortunately always been this way, since StarOffice (so that's a
> very
> long time for a seemingly critically missing piece of functionality).
>
> No one has undertaken to add the required functionality to the UI, or
> internal LO parser (which would allow for graphical UI manipulation
> of
> update statements).
>
> The only remaining possibility then is via macro, which can be stored
> in
> the ODB file, and triggered for example, via a button press on a
> form,
> or a form reload, or some other action that can be used as the event
> trigger.
>
> Alex
>
Hallo Alex,

yes, thanks for that suggestion. I was 'kinda feared' you might suggest
that. I think I would need some very solid documentation to go that
way. What flummexes me most there is the multitude of methods available
that house the relatively modest functions I need.

I remember using VBA from my days with MSAccess, but our LO/Linux world
has such an 'embarrassment of riches' I don't quite know where to
start. You could say I'm a bit intimidated by the idea. Any suggestions
where I might start?

Cheers
Harvey



--
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/
Privacy Policy: https://www.documentfoundation.org/privacy

Follow-Ups:
Re: [libreoffice-users] Re: SQL Syntax UPDATERobert Großkopf <robert@familiegrosskopf.de>
References:
[libreoffice-users] SQL Syntax UPDATEHarvey Nimmo <harvey@nimmo.de>
Re: [libreoffice-users] SQL Syntax UPDATERobert Großkopf <robert@familiegrosskopf.de>
Re: [libreoffice-users] SQL Syntax UPDATEHarvey Nimmo <harvey@nimmo.de>
Re: [libreoffice-users] SQL Syntax UPDATERobert Großkopf <robert@familiegrosskopf.de>
Re: [libreoffice-users] SQL Syntax UPDATEHarvey Nimmo <harvey@nimmo.de>
Re: [libreoffice-users] SQL Syntax UPDATERobert Großkopf <robert@familiegrosskopf.de>
Re: [libreoffice-users] SQL Syntax UPDATEHarvey Nimmo <harvey@nimmo.de>
[libreoffice-users] Re: SQL Syntax UPDATEAlexander Thurgood <alex.thurgood@gmail.com>
Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.