Re: [libreoffice-users] Re: SQL Syntax UPDATE
... and there is no problem to use the *.rpm directly from LibreOffice. I have installed more than 15 different LO-versions for testing parallel in a folder here - also LO 6.3.0.2 ... My System: OpenSUSE 15 64bit rpm Linux. Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Re: SQL Syntax UPDATE
On 24/07/2019 07:49, Harvey Nimmo wrote: > OpenSUSE has not yet integrated 6.2, so I hope I can use the 6.2 > Handbook without further ambiguities. Hi Harvey. I use the repositories below as 6.1 has some bugs blocking my use, fixed in 6.2. https://download.opensuse.org/repositories/LibreOffice:/6.2/openSUSE_Leap_15.1/ https://download.opensuse.org/repositories/LibreOffice:/6.2/openSUSE_Leap_15.0/ A German mirror too; https://ftp.gwdg.de/pub/opensuse/repositories/LibreOffice:/6.2/openSUSE_Leap_15.0/ etc. steve -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Re: SQL Syntax UPDATE
On Tue, 2019-07-23 at 21:02 +0200, Robert Großkopf wrote: > Hi Harvey, > > > > 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? > > I see your mailaccount is from *.de (Germany). So could be you > understand the German descriptions of the Base-Handbuch. You could > find > the newest versions on my homepage. There are also example-databases > where you could find parts of macro-code. > > You could also find older versions, which are translated into > English: > http://robert.familiegrosskopf.de/lo_hb_en/ > ... but my English might be a littel bit too funny ... > > Regards > > Robert > -- > Homepage: http://robert.familiegrosskopf.de > LibreOffice Community: http://robert.familiegrosskopf.de/map_3 > Thanks, Robert. I am at home in both languages, so to speak, so there is no problem there. As I see it, your handbook is limited to Basic, i.e. no Java, no python, so that solves the first problem (I might have tried to venture into python). OpenSUSE has not yet integrated 6.2, so I hope I can use the 6.2 Handbook without further ambiguities. I know that I was waiting for the ODBC connection to be set up in 6.2, but the connection issue is solved, thanks to your help! In short, I'll give it a try! Many thanks again. No doubt I'll be in touch again! Cheers Harvey -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Re: SQL Syntax UPDATE
Hi Harvey, > > 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? I see your mailaccount is from *.de (Germany). So could be you understand the German descriptions of the Base-Handbuch. You could find the newest versions on my homepage. There are also example-databases where you could find parts of macro-code. You could also find older versions, which are translated into English: http://robert.familiegrosskopf.de/lo_hb_en/ ... but my English might be a littel bit too funny ... Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -- To unsubscribe e-mail to: users+unsubscr...@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
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+unsubscr...@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
[libreoffice-users] Re: SQL Syntax UPDATE
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 -- To unsubscribe e-mail to: users+unsubscr...@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