Hi,
I am new to this list and need some help with Base.
Can anyone help me to create a list report which has one field that may
expand to more that one text line? Most lines of the report in the
detail report section are just one line deep. However, a few fields may
wrap round to more than on li
Also are you using an external
back-end or is the database all 1 big file?
Regards from
Tom :)
On 20 January 2014 20:02, Harvey Nimmo wrote:
> Hi,
>
> I am new to this list and need some help with Base.
>
> Can anyone help me to create a list report which has one field that may
Dear Alex,
> Le 20/01/2014 21:02, Harvey Nimmo a écrit :
>
> Hi Harvey,
>
>
> >
> > Can anyone help me to create a list report which has one field that may
> > expand to more that one text line? Most lines of the report in the
> > detail report section
On Wed, 2014-01-22 at 17:50 +0100, Alex Thurgood wrote:
> On 22/01/2014 16:40, Harvey Nimmo wrote:
>
> Hi Harvey,
>
>
> > I am fetching records from a query and putting them in various text
> > boxes in the 'detail' section of a report. Two fields of each
namically -
> that I think would be quite tricky! If you are interested in looking at my
> code, (written in basic), I could post it on the list. Just let me know.
>
> Noel
> --
> Noel Lodge
> lodg...@gmail.com
>
>
> On 23 January 2014 09:01, Harvey Nimmo wrote:
>
Can I use Mariadb as back-end for LO Base or must it be MySQL? For
example, are the connectors compatible or is there a Mariadb-specific
connector?
Cheers
Harvey
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how
Writer: 30%
Calc: 60%
Impress:4%
Base: 5%
Draw: <1%
Cheers
Harvey
On Mon, 2014-05-12 at 11:31 +0800, som wrote:
> > On , som wrote:
>
> > >
> >
> >
> >> On Monday, 12 May 2014 3:25 AM, Virgil Arrington
> > wrote:
> >> > I'm curious to find o
I apologise from the start if the subject of this thread has already bee
thrashed to death in this forum. It guess I pay detailed attention to
what is going on only when it affects me directly.
I am discovering a number of page formatting problems with LO Writer
which are nearly driving me nuts. I
I apologise from the start if the subject of this thread has already been
thrashed to death in this forum. I guess I pay detailed attention to
what is going on only when it affects me directly!
LO Version: 4.1.6.2 on OpenSuse 13.1
I want to print a two-page A4 document, the first page being port
documents (or the same ones) have problems in other programs?
> LO does seem to have something odd about it's printing configs but
> hopefully people here can help!
>
>
> Good luck and regards from
> Tom :)
>
>
>
>
>
>
>
> On 14
u can choose to output in PDF or postscript.
> PDF was the default and caused me problems, changing to postscript fixed it.
> steve
> On 2014-07-15 06:54, Harvey Nimmo wrote:
> > Thanks for your reply, Tom. My OS is OpenSuse 13.1 (Linux).
> >
> > Yes, there was a mism
gt; Hi.
> I am not meaning the printer selection but under properties and then
> device, printer language type.
>
>
> steve
> On 2014-07-15 07:16, Harvey Nimmo wrote:
>
> > Yes, the problem does not exist when printing from a pdf file. The
> > problem exists only
Yes, I keep getting this one (or one like it) about once a month,
although I have not submitted at post recently.
Harvey
On Sat, 2014-08-02 at 05:39 -0400, Pikov Andropov wrote:
> Is everyone getting this every time some one writes a "bad" post?
>
>
> Forwarded Message
> Subj
I tried to install the 64-bit and 32-bit versions but get the message
"The extension 'MySQL Connector' does not work on this computer."
I have a 64-bit Terra laptop, with Opensuse 13.1 and LibreOffice
Version: 4.1.6.2 Build ID: 410m0(Build:2)
Greetings
Harvey
On Wed, 2014-10-01 at 19:57 -0400, D
aha...so what do I learn from this? => I should read the title of the
thread and check my own installation before taking action and/or
replying.
Sorry for that!
Cheers
Harvey
On Thu, 2014-10-02 at 07:09 -0400, Dan Lewis wrote:
> On 10/02/2014 03:13 AM, Harvey Nimmo wrote:
> >
27;s pretty rare.
>
>
> Regards from
> Tom :)
>
>
>
>
>
> On 2 October 2014 12:46, Harvey Nimmo wrote:
> aha...so what do I learn from this? => I should read the title
> of the
> thread and check my own installation before taki
On Thu, 2014-10-09 at 18:31 +0900, Thomas Blasejewicz wrote:
> Good evening
> I noticed this before:
> I have a spreadsheet with alphanumeric items, Japanese terms, a few
> "functions" and dates.
>
> In the default style for spreadsheets as well as a private style I
> defined fonts to be used
>
I think you will find that a .slk file is a symbolic link file
(equivalent to the linux .lnk) so it won't open directly in Calc. If the
spreadsheet file is at the place where the slk file expects it to be it
should open in Calc. If you deceive it into thinking that the .slk file
is a spreadsheet yo
Sorry, my fault. I was really too hasty :-(
I take it all back. Please ignore my input. Ash on my head (as the
Germans say)
Cheers
Harvey
On Wed, 2014-10-15 at 13:18 +0200, Cley Faye wrote:
> 2014-10-15 12:27 GMT+02:00 Urmas :
>
> > "Harvey Nimmo":
> >
> >
My configuration is Libre-Office Version: 4.3.2.2.0+
Build ID: 430m0(Build:2) on Gnome 3.14.1 under Opensuse 13.2.
I had a simple MySql database running perfectly well under OpenSuse 13.1
using Libre-Office Base as front end. Now when trying to execute my
report in the new configuration, I get th
On Sun, 2014-11-16 at 10:36 +0100, Alex Thurgood wrote:
> Le 14/11/2014 15:39, Harvey Nimmo a écrit :
> > com.sun.star.loader.CannotActivateFactoryException was caught."
>
>
>
> Sounds similar to this :
>
> https://www.libreoffice.org/bugzilla/show_bug.cgi?id=51
On Sun, 2014-11-16 at 10:36 +0100, Alex Thurgood wrote:
> Le 14/11/2014 15:39, Harvey Nimmo a écrit :
> > com.sun.star.loader.CannotActivateFactoryException was caught."
>
>
>
> Sounds similar to this :
>
> https://www.libreoffice.org/bugzilla/show_bug.cgi?id=51
On Sun, 2014-11-16 at 10:36 +0100, Alex Thurgood wrote:
> Le 14/11/2014 15:39, Harvey Nimmo a écrit :
> > com.sun.star.loader.CannotActivateFactoryException was caught."
>
>
>
> Sounds similar to this :
>
> https://www.libreoffice.org/bugzilla/show_bug.cgi?id=51
On Wed, 2014-11-19 at 09:55 +0100, Alex Thurgood wrote:
> Le 14/11/2014 15:39, Harvey Nimmo a écrit :
>
> Hi Harvey,
>
> > My configuration is Libre-Office Version: 4.3.2.2.0+
> > Build ID: 430m0(Build:2) on Gnome 3.14.1 under Opensuse 13.2.
> >
>
> Is this
>
> Tools - Options - Advanced
> and if LibreOffice grumbles then switch it back on again. Most people
> find they can live without Java in LibreOffice and maybe even
> uninstall it.
>
Indeed LibreOffice grumbles if I switch off Java. As soon as I try to
execute the report it reminds me that
On Wed, 2014-11-19 at 10:40 +, Tom Davies wrote:
> Hi :)
> Crashing is usually due to some 3rd party Extension or some weird tangle of
> settings in the User Profile. Renaming the User Profile is usually fairly
> quick and easy, once you've figured it out first time
> https://wiki.documentfou
On Tue, 2014-11-25 at 14:03 +, Tom Davies wrote:
> Hi :)
>
> Nicely done! :)
>
>
> Errr, have you been able to temporarily work-around by going back to
> an older version of LibreOffice or have you had a chance to test-drive
> a newer version, maybe as a parallel install? I dunno if tha
On Fri, 2014-12-19 at 14:00 +0100, Andreas Säger wrote:
> Am 17.12.2014 um 00:16 schrieb Hedley Finger:
> > All:
> >
> >> Why not stay with the advantages of LibreOffice instead of trying to make
> >> it as hideous as MS Office!!?
> >
> > Can MS Office be more hideous than this?
> >
> > I deci
The LibreOffice Base is the LO answer to Access. My observation is that
there are similarities in concept but they are not compatible with each
other.
On Thu, 2015-01-29 at 15:13 +, Philip Jordan wrote:
> Well others will know more than me on this, but from my ltd experience
> I'd ask what OS
On Sat, 2015-07-18 at 08:21 -0400, Tim---Kracked_P_P---webmaster wrote:
> On 07/18/2015 03:42 AM, Eric wrote:
> > On 07/17/2015 05:25 PM, charles meyer wrote:
> >> For those on the list using or contemplating Linux, this was
> >> interesting.
> >>
> >> http://www.techrepublic.com/article/alternati
On Sat, 2015-07-18 at 12:00 -0400, Gary Dale wrote:
> On 18/07/15 11:35 AM, Luuk wrote:
> > On 17-7-2015 23:47, Gary Dale wrote:
> >> On 17/07/15 05:25 PM, charles meyer wrote:
> >>> For those on the list using or contemplating Linux, this was
> >>> interesting.
> >>>
> >
> >
> >> Frankly tho
On Sat, 2015-07-18 at 16:05 -0400, Gary Dale wrote:
> On 18/07/15 02:25 PM, Harvey Nimmo wrote:
> > On Sat, 2015-07-18 at 08:21 -0400, Tim---Kracked_P_P---webmaster wrote:
> >> On 07/18/2015 03:42 AM, Eric wrote:
> >>> On 07/17/2015 05:25 PM, charles meyer wrote:
>
On Sat, 2015-07-18 at 21:43 -0400, James Knott wrote:
> On 07/18/2015 09:25 PM, James E Lang wrote:
> > The big discussion of Linux over the past 24+ hours has me wondering: What
> > operating environment(s) do other members of this list use at home and at
> > work? What factors influence the cho
On Sat, 2015-07-25 at 14:54 -0400, James Knott wrote:
> On 07/25/2015 09:35 AM, Graham P Davis wrote:
> > We only had log tables; standard slide rules weren't allowed as they
> > were too inaccurate. Drifting a bit more OT, ball-point pens weren't
> > allowed either, only fountain pens.
> >
> > To
^1: More than one researcher has argued that The Human Genome Project
> was a complete waste of money, time, and effort, because of the
> numerous
> _known_ errors inflicted upon the project, by the use of Excel, and
> its
> silent translation of data to something other that what the user
> wrote.
On Sat, 2015-11-14 at 19:47 +, toki wrote:
> On 14/11/2015 17:43, Harvey Nimmo wrote:
>
> > > ^1: More than one researcher has argued that The Human Genome
> > > Project
> was a complete waste of money, time, and effort,
> > It would be interesting to ha
On Wed, 2016-01-20 at 12:05 +0200, Ian Whitfield wrote:
> Hi All
>
> I have been trying to import a CSV file from Calc into MySQL to run
> with
> Base for over a week now and can not believe this is so difficult to
> do
> so I'm hoping some other Base users might have cracked this one!!
>
> My
Yes I have a(n old) Knoppix version (V5.0.1) that I sometimes use for
rescue activities. But nowadays for that I prefer to use System Rescue
V4.4.1
Cheers
Harvey
On Fri, 2016-02-12 at 16:40 -0500, charles meyer wrote:
> Hi Folks,
>
> Just a quick off -topic question, s'il vous plaît?
>
> Please
I find Master pdf Editor to be a useful tool. It is free form non
-commercial use. It can be a wee bit slow on my Linux openSUSE Leap
42.1 but has many features that you may have seen in Adobe Pro, and is
also available for Windows. See
https://code-industry.net/masterpdfeditor.
Cheers
Harvey
On M
Try View > Zoom > 150% (or something like that)
Also with View > Zoom > Zoom... you can fix the selection to View
Layout Single Page or choose the number of columns (=pages) you want to
see.
Cheers
Harvey
On Thu, 2016-07-07 at 00:05 -0400, charles meyer wrote:
> For some reason, LW changed to
On Fri, 2016-07-29 at 20:53 -0600, Ken Springer wrote:
> The subject says it all, how successful is Base in importing Access
> Databases?
>
> LO 5.0.x
>
> --
> Ken
> Mac OS X 10.8.5
> Firefox 44.0
> Thunderbird 38.0.1
> "My brain is like lightning, a quick flash
> and it's gone!"
>
>
Un
On Sun, 2016-07-31 at 13:32 -0600, Ken Springer wrote:
> On 7/30/16 8:40 AM, Harvey Nimmo wrote:
> > On Fri, 2016-07-29 at 20:53 -0600, Ken Springer wrote:
> > > The subject says it all, how successful is Base in importing
> > > Access
> > &
On Wed, 2016-08-03 at 10:02 +1200, tonybsa wrote:
> In defence of LibreOffice Base.
> Unlike Ian I have had very good results with Base.
>
> Over the last 8 years I have used Base as a a "front end" to a MySQL
> database in 5 different countries for different projects.
>
> One database was for th
I think the 'Borders' tools can be made visible with
View > Toolbars > Formatting.
Cheers
Harvey
On Wed, 2016-10-05 at 09:30 -0700, John R. Sowden wrote:
> I received a SS from a customer written in an excel format. It had
> some
> of the cells' borders highlighted. I tried to delete this fr
There is much debate about whether software should be the subject of
patents, or rather, copyright/copyleft. The website groklaw.net has a
lot of very interesting material about this. It would be very
interesting to know where the Trump dynasty stands on that; could end
up making a lot of differenc
I wanted to use the CONCAT function in a Base query. However, it seems
that if ONE of the elements of the list to be concatenated is NULL then
the CONCAT function returns a NULL. Am I right? Is it a bug or a
feature?
Kind Regards
Harvey Nimmo
--
To unsubscribe e-mail to: users+unsubscr
Hi Robert,
Thanks for answering.
Your suggestion, however, do not work on my Opensuse Leap 42.3 /
LibreOffice 5.3.3.2 configuration.
I use the Query design feature to enter
"Vorname" || IFNULL( ' & ' || "Partnervorname", ' ' ) || "Nachname"
or
"Nachname" || IFNULL( ', ' || "Vorname", ' ')
Bot
On Fri, 2017-09-15 at 19:19 +0200, Robert Großkopf wrote:
> Hi Harvey,
>
> >
> > Hi Robert,
> > Thanks for answering.
> > Your suggestion, however, do not work on my Opensuse Leap 42.3 /
> > LibreOffice 5.3.3.2 configuration. >
> > I use the Query design feature to enter
> >
> > "Vorname" || IFN
On Fri, 2017-09-15 at 22:46 +0200, Robert Großkopf wrote:
> Hi Harvey,
> >
> >
> > I have a backend Mariadb 10 which I access directly using the using
> > the
> > MySQL connector.
>
> All right. With MariaDB (and MySQL) the two pipes (||) dont work.
>
> But something like
> SELECT CONCAT("Vorna
On Sat, 2017-09-16 at 18:31 +0200, Robert Großkopf wrote:
> Hi Harvey,
> >
> >
> > But shouldn't the CONCAT( ' & ', [Partnervorname] ), '' ) actually
> > return a NULL due to the '' (i.e. not a space, zero length)?
>
> NULL: There is nothing inside, no string, no number, no data ...
> Empty: Cou
On Sat, 2017-09-16 at 18:37 +0200, Harvey Nimmo wrote:
> On Sat, 2017-09-16 at 18:31 +0200, Robert Großkopf wrote:
> >
> > Hi Harvey,
> > >
> > >
> > >
> > > But shouldn't the CONCAT( ' & ', [Partnervorname] ), '&
On Mon, 2017-09-25 at 12:57 +, Virgil Arrington wrote:
> On 09/24/2017 11:07 PM, John R. Sowden wrote:
> >
> >
> > I struggled with the method you referenced below, soliciting
> > assistance from this list. The responders also could not get LO
> > to
> > print a stack of envelopes. We fin
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
+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 y
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
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
On Thu, 2017-11-30 at 15:50 +0100, Robert Großkopf wrote:
>
> ...
>
> It has never beeen intended that the query-editor is used for
> changing
> data. There is a feature-request for this:
> https://bugs.documentfoundation.org/show_bug.cgi?id=31398
> since 7 years.
> The risky feature is: the nati
On Fri, 2017-12-01 at 19:56 +0100, Robert Großkopf wrote:
Hi Robert,
I appreciate your comments! Many thanks.
> What you perform with the query-editor isn't a query. A query
> shouldn't
> change the content of any table.
From a purist viewpoint, you are right, of course! My mind has been
damag
On Sat, 2017-12-02 at 10:42 +0100, Alexander Thurgood wrote:
> Le 01/12/2017 à 23:08, Harvey Nimmo a écrit :
>
> Hi Harvey,
>
> You are correct, it would improve the user experience of Base by an
> important measure to have a GUI UPDATE capability. This is something
> tha
On Sat, 2017-12-02 at 20:57 +0100, Robert Großkopf wrote:
> Hi Harvey,
>
> here is a little example-database for executing SQL by a macro.
> http://robert.familiegrosskopf.de/download/Example_InsertUpdateDelete
> _SQL.odb
> Open the form and try. Could be constructed a little bit better, but
> wor
On Sun, 2017-12-03 at 09:37 +0100, Robert Großkopf wrote:
>
> > Hi Robert,
> >
> > I think I can see what you are trying to do, but nothing happens on
> > clicking the button.
>
> First there should appear a messagebox with question: "Should the
> code
> ... be executed?"
> If you click "yes" h
Macro will be executed here and update to 2,4,3 will be executed.
Hallo Robert,
> > Don't know what is going wrong there with your installation.
> >
> > If you have opened the table at the same time you have to refresh
> > the
> > data of the table afterwords - but if you don't see the messagebox
On Sun, 2017-12-03 at 16:48 +0100, Robert Großkopf wrote:
> Hi Harvey,
> >
> >
> > I've got it. The hsqldb driver pool had to be enabled in the Base
> > options settings.
>
> Have never touched there anything. The conneection-pool is disabled
> here.
> Do you use the LO-version from OpenSUSE or
I'm running LO on OpenSuse and I wonder if anyone alse can confirm this
error on calc.
Multiplying 2048.28*.146 yields correctly 295.54488, but when rounding
down to 2 decimal places, 295.55 is displayed (instead of
295.54)(either using ROUND(2048.28*.146,2) or with field format.
My LO Version:
V
On Fri, 2018-12-28 at 19:22 +0100, Robert Großkopf wrote:
> Hi Harvey,
> >
> > Multiplying 2048.28*.146 yields correctly 295.54488, but when
> > rounding
> > down to 2 decimal places, 295.55 is displayed (instead of
> > 295.54)(either using ROUND(2048.28*.146,2) or with field format.
>
> Please h
gt;
>
>
>
> Num 1Num 2 CalcYour Value?? Rounded
>
> 2048.28 0.144291210186107 295.5488 295.55
>
>
>
>
>
> Same as above, but recalculated the 1st number??
>
>
>
>
>
> Num 1 CalcNum 2Your Value?? Rounded
&
On Fri, 2018-12-28 at 18:41 +, Brian Barker wrote:
> At 18:26 28/12/2018 +0100, Harvey Nimmo wrote:
> > I'm running LO on OpenSuse and I wonder if anyone else can confirm
> > this error on calc. Multiplying 2048.28*.146 yields correctly
> > 295.54488, ...
>
&
show for the Num 1 and Num 2 entered link that or
> are
> that what is displayed on screen.The actual numbers could throw off
> the
> calcs.
>
>
> If the 0.146 number is display like that, but actually contains
> 0.146001936490999 it would change the value.
>
On Fri, 2018-12-28 at 19:12 +, Brian Barker wrote:
> At 20:06 28/12/2018 +0100, Harvey Nimmo wrote:
> > However, I do not have 'Limit decimals for general number format'
> > set to anything. (i.e. No tick)
>
> Good-oh! And what about "Precision as shown
On Fri, 2018-12-28 at 20:12 +0100, Piet van Oostrum wrote:
> Harvey Nimmo writes:
>
> > I'm running LO on OpenSuse and I wonder if anyone alse can confirm
> > this
> > error on calc.
> >
> > Multiplying 2048.28*.146 yields correctly 295.54488, but when
On Thu, 2019-07-11 at 14:05 -0400, Tanstaafl wrote:
> Hi everyone,
>
> I need some help with converting a number (in a text field) to a
> different type.
>
> The type of number is time, and it is in the form of:
>
> hh:mm:ss
>
> I need to convert this to just minutes, rounded up, so if ss is mo
On Thu, 2019-07-11 at 20:55 +0200, Harvey Nimmo wrote:
> On Thu, 2019-07-11 at 14:05 -0400, Tanstaafl wrote:
> > Hi everyone,
> >
> > I need some help with converting a number (in a text field) to a
> > different type.
> >
> > The type of n
Having tried unsuccessfully to connect my remote mariadb from
LibreOffice Base under Leap 15.0, I am still having problems under Leap
15.1. My LO version is 6.1.3.2.
The JDBC and ODBC drivers 'fail to load'.
Can someone please point me in the right direction to troubleshoot this
problem systemati
On Thu, 2019-07-11 at 21:47 +0200, Robert Großkopf wrote:
> Hi Harvey,
>
> have the same system here and have written down all what I have
> tested here:
> http://robert.familiegrosskopf.de/lo_hb_xhtml/Base_02_DatenbankErstel
> len.xhtml#__RefHeading__875_19302748411
>
> Its part of the German Ba
On Fri, 2019-07-12 at 16:08 +0200, Robert Großkopf wrote:
> Hi Harvey,
> >
> > However, whereas I can now connect successfully with jdbc to the
> > database, my existing (LO) input forms won't let me change the
> > data.The
> > form controls are completely deactivated.
>
> Open one of the tables
On Fri, 2019-07-12 at 13:00 -0400, Tanstaafl wrote:
> On Thu Jul 11 2019 15:12:05 GMT-0400 (Eastern Standard Time), Harvey
> Nimmo wrote:
> > Sorry, Tanstaafl!
> >
> > There is a slight error in the above. The formula should read
> > =HOUR(A1)*60+MINUTE(A1)+ROUND(
I am connecting a Base client (Version: 6.1.3.2) to a remote mariadb
using the MySQL (JDBC) connector.
A form I had generated in Base needed a new field that had to be added
to the source (Base) query and the related (Mariadb) table.
Having added the new field to the table using the Base client,
On Tue, 2019-07-16 at 21:28 +0200, Robert Großkopf wrote:
> Hi Haevey,
> >
> > Having added the new field to the table using the Base client, I
> > expected it to appear in the query which is of the form (SELECT *
> > FROM
> > ). It didn't until I closed Base and restarted it.
>
> How did you ad
On Tue, 2019-07-16 at 22:11 +0200, Harvey Nimmo wrote:
> On Tue, 2019-07-16 at 21:28 +0200, Robert Großkopf wrote:
> > Hi Haevey,
> > >
> > > Having added the new field to the table using the Base client, I
> > > expected it to appear in the query which
On Wed, 2019-07-17 at 09:09 +0200, Robert Großkopf wrote:
> Hi Harvey,
>
> couldn't see this behaviour in LO 6.2.5.2 on OpenSUSE 15, 64bit rpm
> Linux. But my MariaDB is a local database. Think it is a problem of
> the
> remote-connection to your database. The changing of the table must
> reach
>
On Wed, 2019-07-17 at 09:54 +0200, Harvey Nimmo wrote:
> On Wed, 2019-07-17 at 09:09 +0200, Robert Großkopf wrote:
> > Hi Harvey,
> >
> > couldn't see this behaviour in LO 6.2.5.2 on OpenSUSE 15, 64bit rpm
> > Linux. But my MariaDB is a local database. Think it is
I using LibreOffice (version 6.1.2.3) Base as client to a backend
Mariadb10 via MySQL(JDBC) connector.
I have a created a Query in Base of the form SELECT * FROM
ORDER BY ASC, ASC
Why MUST these two sort fields be set to 'visible' in the query (thus
extending the above syntax accordingly), si
On Thu, 2019-07-18 at 10:48 +0200, Alexander Thurgood wrote:
> Le 18/07/2019 à 09:47, Harvey Nimmo a écrit :
>
> Hi Harvey,
>
> > I using LibreOffice (version 6.1.2.3) Base as client to a backend
> > Mariadb10 via MySQL(JDBC) connector.
> >
> > I have a
On Thu, 2019-07-18 at 10:48 +0200, Alexander Thurgood wrote:
> Le 18/07/2019 à 09:47, Harvey Nimmo a écrit :
>
> Hi Harvey,
>
> > I using LibreOffice (version 6.1.2.3) Base as client to a backend
> > Mariadb10 via MySQL(JDBC) connector.
> >
> > I have a
On Thu, 2019-07-18 at 16:53 +0200, Robert Großkopf wrote:
> Hi Harvey,
> >
> > OpenSUSE provides only the ODBC connector for mariadb, no JDBC
> > connector.
>
> I'm using only JDBC with OpenSUSE. You have to dowload it directly
> from
> MariaDB
> >
> > What I saw was:
> >
> > SELECT * .*, ., .
On Thu, 2019-07-18 at 21:14 +0200, Robert Großkopf wrote:
> Hi Harvey,
> > >
> >
> > Bugzilla? What is the link?
>
> https://bugs.documentfoundation.org/
>
> You could add an attachment with internal Firebird database. Query-
> GUI
> will show the same behaviour as in MariaDB.
>
> Regards
>
>
I'm running LO Version: 6.1.3.2 on OpenSUSE LEAP 15.1 and have run into
a snag with a query I am trying to construct.
The SQL editor is rejecting this UPDATE query that, I believe, obeys
the standard SQL syntax.
UPDATE 'Adressensammlung'.'Adressen' SET 'Adressen'.'Print_flag' = TRUE
WHERE 'Adress
On Tue, 2019-07-23 at 16:21 +0200, Robert Großkopf wrote:
> Hi Harvey,
> >
> > The SQL editor is rejecting this UPDATE query that, I believe,
> > obeys
> > the standard SQL syntax.
> >
> > UPDATE 'Adressensammlung'.'Adressen' SET 'Adressen'.'Print_flag' =
> > TRUE
> > WHERE 'Adressen'.`Xmas` = TR
On Tue, 2019-07-23 at 16:53 +0200, Robert Großkopf wrote:
> Hi Harvey,
> >
> > I'm getting "Can not issue data manipulation statements with
> > executeQuery()."
>
> Where do you start the update?
>
> Tools > SQL?
>
> Or is there a macro working? Then you have to run executeUpdate()
> instead.
On Tue, 2019-07-23 at 18:08 +0200, Robert Großkopf wrote:
> Hi Harvey,
> >
> > I am not using macros (yet...hmm). I create the queries with the
> > GUI in
> > SQL view.
> > I execute using the 'Run Query (F5)' function from the editor. The
> > SQL
> > text is not allowed to be stored with the synt
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?
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
> > sugge
Does anyone know why the function WEEK returns a zero for Tuesday, Jan
1st, 2019? i.e. WEEK('19-01-01')
According to my calendar it should be week 1 and, in Calc, the WEEKNUM
and ISOWEEKNUM both return 1. (WEEKNUM starts the week on Sunday,
ISOWEEKNUM on Monday, but otherwise no difference)
Cheer
On Sun, 2019-08-25 at 08:21 +0200, Robert Großkopf wrote:
> Hi Harvey,
>
> > Does anyone know why the function WEEK returns a zero for Tuesday,
> > Jan
> > 1st, 2019? i.e. WEEK('19-01-01')
>
> Must be WEEK('2019-01-01'), if you are using the internal HSQLDB.
> Gives
> '1' here.
> Must be EXTRACT(
On Sun, 2019-08-25 at 14:32 +0200, Harvey Nimmo wrote:
> On Sun, 2019-08-25 at 08:21 +0200, Robert Großkopf wrote:
> > Hi Harvey,
> >
> > > Does anyone know why the function WEEK returns a zero for
> > > Tuesday,
> > > Jan
> > > 1st, 2019? i.e.
On Sun, 2019-08-25 at 15:34 +0200, Robert Großkopf wrote:
> Hi Harvey,
> >
> > I am using Mariadb10 as backend from a Base client via JDBC. I have
> > created the function within a Base Query (GUI).
>
> So it isn't a LO-problem. WEEK gives (in MariaDB/MySQL) 0 - 53, if
> you
> start the week with
I wonder if anyone knows how to solve this little problem?
I am trying to construct a report from a Table/Query in Base. Amongst
other data there are five boolean flags (Type Yes/No[BIT] to be printed
from each record.
Thinking that it would take up too much space on the paper together
with the l
On Thu, 2019-12-12 at 19:46 +0100, Robert Großkopf wrote:
> Hi Harvey,
>
> try this:
> Write into Data > Data field
>
> IF([NameOfBoolField];"y";"n")
>
> Regards
>
> Robert
> --
> Homepage: https://www.familiegrosskopf.de/robert
Hi Robert,
I was just about to answer that I had tried that and
On Thu, 2019-12-12 at 20:28 +0100, Robert Großkopf wrote:
> Hi Harvey
> >
> > I was just about to answer that I had tried that and it did not
> > work,
> > until I noticed your square brackets []. That did the trick!! You
> > are
> > wonderful.
> >
> > But where is that documented?
>
> Don't kno
My intention was to use the header function to describe each page of a
29 page document separately, with a couple of exceptions where two
pages may have the same header.
I thought that it would just be a simple question of telling the header
of each page to copy (or not) the header of the previous
1 - 100 of 209 matches
Mail list logo
