Hi Edwin,
On Wed, 2024-05-22 at 16:01 +1000, Edwin Humphries wrote:
> Hi all
>
> I need to copy the first word from an existing field and place it
> into a
> new field. Is there a way to do that autoagically?
This might work for you, assuming the field with the text is called
SELECT
Hi Robert,
On Sun, 2024-05-19 at 19:18 +0200, Robert Großkopf wrote:
> Hi Harvey,
> >
> > I can confirm that with my current LO 24.2.1.2 this is NOT the
> > behaviour. Removing ANY ONE table in the Table Filter followed by
> > Refresh Tables causes ALL Table to disappear, and the Table Filter
> >
Hi Robert,
On Sun, 2024-05-19 at 09:15 +0200, Robert Großkopf wrote:
> Hi Harvey,
>
> have tested with LO 24.2.3.2 on OpenSUSE (original packages from LO):
>
> Started
> Tools → Table Filter
> Marked "All views" → OK
> Started
> View → Refresh Tables
> All tables and view could be seen, special
The Table Filter in Base doesn't seem to work well in my configuration.
I am running Base as frontend to a network server with mysql/mariadb
containing several databases, connected via MySQL(JDBC)
Logging in to the mysql server causes Base to show ALL the tables of
these databases (including the
On Wed, 2024-05-15 at 09:15 +0200, Robert Großkopf wrote:
> Hi Thomas,
>
> > Probably I am a little stupid, but what is the difference between
> > "24.2.3" and "7.6.7" (in my case 7.6.6).
> > These number look VERY different.
>
> Version numbering had been changed.
> 24 → Year 2024
> 2 →
Henschel wrote:
> Hi Harvey,
>
> Harvey Nimmo schrieb am 30.04.2024 um 09:34:
> > Each month I have to prepare a contribution to a presentation.
> > I write my contribution in LO-Impress as .odp, save it and send it
> > as
> > .pptx for a colleague to integrate it us
-6185.patch
* CVE-2023-6186-1.patch
* CVE-2023-6186-2.patch
* CVE-2023-6186-3.patch
* CVE-2023-6186-4.patch
* CVE-2023-6186-5.patch
On Thu, 2024-05-02 at 13:39 +0200, Regina Henschel wrote:
> Hi Harvey,
>
> Harvey Nimmo schrieb am 30.04.2024 um 09:34:
> > Each month I
not be repaired and is removed. I am trying
to find out which content may have been removed, as that would be the
potential culprit.
Cheers
Harvey
On Tue, 2024-04-30 at 10:48 +0200, Harvey Nimmo wrote:
> Thanks. One of the pictures is in wmf format (whatever that is!). All
> the others are
eck the pictures, I am sure there is one which creates the issue.
>
> On 30/04/24 10:13, Harvey Nimmo wrote:
> > Hallo Italo,
> >
> > Thank you very much for your offer. Unfortunately, the slides
> > contain
> > personal data, that I cannot really share.
> >
To provide a more precise opinion, though, I should see the file.
>
> If you can send it to my address as attachment (the list doesn't
> accept
> attachments) I can double check.
>
> On 30/04/24 09:34, Harvey Nimmo wrote:
> > Each month I have to prepare a contribution to a
a ppt (the old
> powerpoint format). No complaints from my co-workers yet. Admittedly
> my presentations are very simple (text, some tables, PNG images); ppt
> may not work if you need more features.
>
> HTH,
>
> Peter
>
> On Tue, Apr 30, 2024 at 3:36 PM Harvey Nimmo
)
CPU threads: 2; OS: Linux 5.14; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-GB
Calc: threaded
I expect an input from the colleague about his Office/Windows versions.
Best regards
Harvey Nimmo
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems
The phenomenon you describes suggests that the label size might be set
wrongly. Even if the label size is set to match the published values.
Maybe you should try reducing the label height by a millimeter or two,
(deviating a little from the published value)
Cheers
Harvey
On Fri, 2024-03-22 at
Don't give up...Base is a powerful tool for managing all kinds of data.
and Robert Großkopf is an excellent advisor!
Happy new year to all!
Harvey
On Sun, 2023-12-31 at 13:43 -0500, Jonathan Ames wrote:
> In trying to reopen table I'd created, I cannot add records -- says
> ERROR
> "Attempt to
On Tue, 2023-11-21 at 08:54 +0100, Robert Großkopf wrote:
> Hey Harvey,
>
> > The next question, though, is how do I ensure that only complete
> > records are printed on a page? I.e. How do I prevent the records
> > being
> > split between the bottom of one page and the top of the next?
> > The
, 2023-11-20 at 18:08 +0100, Harvey Nimmo wrote:
> Sorry to trouble you. 'Auto grow' is the answer to my question. I
> failed to notice this improvement since I generated the report
> originally many years ago!
>
> Cheers
> Harvey
>
> On Mon, 2023-11-20 at 17:54 +0100, Harv
Sorry to trouble you. 'Auto grow' is the answer to my question. I
failed to notice this improvement since I generated the report
originally many years ago!
Cheers
Harvey
On Mon, 2023-11-20 at 17:54 +0100, Harvey Nimmo wrote:
> When creating a Base report consisting of a list of sddres
When creating a Base report consisting of a list of sddresses, for
example, some of the text fields occupy more than the fixed space
allowed by the Base report editor. The overlarge texts are highlighted
with red triangles and the field sizes can be edited with Writer. This
editing task is
023-07-08 14:43, Harvey Nimmo wrote:
>
> > I had this problem with any email sent to a gmail account. ...
>
> I doubt it's so simple, Harvey. I have no such problem with my own
> gmail account (which has no outlook.com server in the mix).
> jk
>
--
To unsubscrib
Hello Budge,
I had this problem with any email sent to a gmail account. As indicated
by the email rejection message, the solution is to login to your email
account at your ISP and set the SPF parameters for your email domain. I
needed help from my ISP to make the right settings in my case.
Hi Robert,
> Hi Harvey,
> >
> > I am running mariadb 10 on the backend. File mysql-connector-
> > java.jar
> > is registered under Options -> LibreOffice -> Advanced -> Class
> > Path at
> > /usr/share/java/
>
> For MariaDB I would use the JDBC-connector fro MariaDB, not from
> MySQL.
> You
In Writer, place your cursor at the place you want the page number to
appear. If you want it in the footer or header you will first have to
select the blue footer or header marker on your page. Click Insert ->
Page Number.
If you want "page of total page count", you will have to add e.g. the
word
On Tue, 2023-05-23 at 15:05 +0200, Robert Großkopf wrote:
> Hi Harvey,
> >
> > I connect daily to a MySQL database located on a network server
> > from
> > the LO-Base front-end on my desktop. The connection type is
> > MySQL(JDBC). However, today, the "driver class
> > 'com.mysql.jdbc.Driver'
>
What can have gone wrong here?
I connect daily to a MySQL database located on a network server from
the LO-Base front-end on my desktop. The connection type is
MySQL(JDBC). However, today, the "driver class 'com.mysql.jdbc.Driver'
could not be loaded". There seems to be no way to make the
I'm not a windows user, but perhaps the LibreOffice process is running
in the background and not able to access a foreground window. In that
case, you should try to kill the LibreOffice that is running in the
background by opening the process manager (what's its correct
name,anyone?) look for
Hi Robert,
the thought occurs to me that the existing quotes within the SQL
statements may need their own treatment. The statements that work under
the LOBase Tools>SQL... function have different type of single
quotemarks for the column names (e.g. containing two separate words) or
the text to be
Hi Robert,
how would this work for me, where I only want to create a SQL statement
as a string and execute it. Can it be that the string is not recognised
as SQL? (In my MSAccess days it worked). Here the run-time error
indicates that the "Object variable is not set" although it is valid
SQL text
2/BG7209-Macros.html
>
> Sorry, not much help :-(
>
>
> On Tuesday, January 24, 2023 15:50 EST, Harvey Nimmo
> wrote:
> Thanks. Not sure I can understand how that should work...hmmm
>
> I based my syntax on the example here
>
> https://learn.microsoft.com/en-
Thanks. Not sure I can understand how that should work...hmmm
I based my syntax on the example here
https://learn.microsoft.com/en-us/office/vba/api/access.docmd.runsql
On Tue, 2023-01-24 at 20:39 +, Dave Howorth wrote:
> On Tue, 24 Jan 2023 20:32:18 +0100
> Harvey Nimmo
andom DB
> Ramblins, and yes that is spelled incorrectly).
>
>
> On Tuesday, January 24, 2023 14:32 EST, Harvey Nimmo
> wrote:
> Where can I find the syntax of the DoCmd.RunSQL command to be used
> with
> a LOBase Macro in Basic?
>
> My assumption was
> X =
Where can I find the syntax of the DoCmd.RunSQL command to be used with
a LOBase Macro in Basic?
My assumption was
X = "SQL string"
DoCmD.RunSQL X
The SQL string runs correctly is correct when executed as SQL Command
in the Base Tools/SQL window.
The Basic Macro with the above statemsnt
registration (during OS/LO updates?)
Problem solved.
On Mon, 2022-12-12 at 20:44 +0100, Harvey Nimmo wrote:
> I need help to print address labels from my database. I have had it
> working e.g. a year ago, but now I am having trouble. My database
> Mariadb10 on a backend server and Base on my fronten
I need help to print address labels from my database. I have had it
working e.g. a year ago, but now I am having trouble. My database
Mariadb10 on a backend server and Base on my frontend desktop.
I have followed the following procedure (as last year)
1. From Base (adresslisten database)
On Thu, 2022-09-01 at 17:39 +1000, Stephen Morris wrote:
> On 29/8/22 09:21, Regina Henschel wrote:
> > Hi Matthias,
> >
> > Matthias Lammer schrieb am 29.08.2022 um 00:24:
> > > Dear LibreOffice team,
> > >
> > > I want to file a very severe bug as follows:
> > >
> > > I create a simple
Yes that works, too. I notice that Base strips off the 'AS' keywords.
Cheers
Harvey
On Tue, 2022-08-16 at 16:02 +0200, Robert Großkopf wrote:
> Hi Harvey,
>
> tested this:
>
> SELECT COALESCE ( `User`, 'Empty' ) AS `User`, COUNT( `ID` ) FROM
> `test`.`User` AS `User` GROUP BY `User`
>
> You
Just one remark on this, though. The GUI and SQL Edit views seem not to
be consistent with each other. Just opening the Query to Edit GUI,
adjusting the pane size (say) and saving the result, destroys the
query.
Cheers
Harvey
On Tue, 2022-08-16 at 10:54 +0200, Harvey Nimmo wrote:
> Thank
Thank you, Robert! As always on target.
This is better than filling the Location fields with some unneeded
value. Great stuff. Man lernt nie aus!
Cheers
Harvey
On Tue, 2022-08-16 at 10:15 +0200, Robert Großkopf wrote:
> Hi Harvey,
> >
> > SELECT `Location`, COUNT( `Location` ) FROM
> >
I have a table consisting of (unique) ITEMS and with a column LOCATION
for the land of origin of the ITEMS. Some LOCATION fields are still
empty.
A query counts the number entries in the LOCATION column for each
country present. Essentially the GUI just shows the functions LOCATION
'group' and
Hi Robert,
I have chosen the configuration LO-Base front ent to Mariadb backend
becuase of the advantage of database server with Terrabytes of disk
space.
But I am wondering seriously whether I have made a good choice. There
seem to be serious compatibilty problems between them in spite of the
OK. Thanks, Robert. That is more or less the conclusion that I had come
to. Not very user-friendly, but it works.
Cheers
Harvey
On Fri, 2022-08-12 at 08:36 +0200, Robert Großkopf wrote:
> Hi Harvey,
> >
> > I cannot confirm the Firebird icon. My database backend is
> > MySQL(JDBC),
> >
Hi Robert,
I cannot confirm the Firebird icon. My database backend is MySQL(JDBC),
(actually Mariadb). I prefer to continue for the time being with the
OpenSUSE packages delivered with my Linux Leap 15.4.
Cheers
Harvey
On Thu, 2022-08-11 at 18:06 +0200, Robert Großkopf wrote:
> Hi Harvey,
>
Hi Robert,
Thanks, so far...;-) I understand that a View would be more efficient
in execution than the equivalent query. And this seems to be more or
less the practical extent of justification for view over query.
My version:
Version: 7.3.4.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU
I'm unsure of the practical implications of the difference between Base
implementation of Views and Queries. Perhaps someone can enlighten me.
One thing, however, does hit me.
Initial design of a View with the GUI, is done similar to a Query,
which is OK. However, when the View is stored, then
That is marvellous. Thank you, Robert!!
I must get used to visiting the Document Foundation website, as I tend
to stick with the help function and otherwise OpenSUSE. Excellent tip.
The Base Guide answers my question precisely, listing as it does the
built-in functions together with a remark in
Hi Robert,
I suppose my question could be reformulated: what version of SQL does
Base support? To what extent is that SQL supported in the BASE
query/view graphical interface?
I haven't been able to find an answer in the LO Help (yet).
Cheers
Harvey
On Wed, 2022-08-10 at 08:31 +0200, Robert
I wonder if anyone knows a simple way in Base to calculate a value for
a view and/or query field entry from the contents of other data fields
of a record. (I know this feature from MSAccess)
For example, I would like to extract a text string from a field in each
record and display it in an extra
Thanks for all the good tips. I have it working.
This last one from Robert works, too. I had tried it before but for
some reason only one record was imported that time. Anyway, good this
time, although patience was needed to import more than 7000 records
(felt like a minute, maybe only half).
Dear formum,
I believe my objective should be rather simple, but I need to be
pointed in the right direction.
I have a column of text data (unique values) in Calc that I want to
transfer to a Base table. The Base table has been set up with three
columns, two of which I expect to remain empty
I, as mere LO user, would like to understand the significance, actual
or surmised, of the closure of the LO Online repository. Does this
potentially signal the end of LO?
Cheers
Harvey
On Sun, 2022-07-10 at 19:42 -0300, Daniel A. Rodriguez wrote:
> I've sent a message to the BoD Discuss mailing
. Thanks.
Cheers
Harvey
On Sun, 2022-06-26 at 06:40 +0100, Brian Barker wrote:
> At 21:41 25/06/2022 +0200, Harvey Nimmo wrote:
> > I wanted to count the number of non-blank items in a list of items
> > using COUNTA. Cell A1 has the formula =COUNTA(A$2:A$1,
> > ISBLANK=
I wanted to count the number of non-blank items in a list of items
using COUNTA.
Cell A1 has the formula =COUNTA(A$2:A$1, ISBLANK=0) above an
otherwise empty column. It returns the value 1!
Is that supposed to mean something? Has anyone notice this?
It's obviously not a big problem,
I see that the rpm Version on the LO site is up to 7.2.7, or even
7.3.3. Can I take either as is?
Cheers
Harvey
On Fri, 2022-05-20 at 18:04 +0200, Harvey Nimmo wrote:
> Thanks for the quick reply. Would this bug be picked up automatically
> by the OpenSUSE integrators?
>
> Rega
Thanks for the quick reply. Would this bug be picked up automatically
by the OpenSUSE integrators?
Regards
Harvey
On Fri, 2022-05-20 at 17:30 +0200, Robert Großkopf wrote:
> Hi Harvey,
> > I am using LO on OpenSUSE Linux Leap 15.3
> > Version: 7.2.5.1 / LibreOffice Community
> > Build ID:
I am using LO Base client to a backend MySQL database (on my local
network). I created a set of reports with Base that worked in the past.
For some reason now when opening a report an error message crops up and
the report cannot be generated.
"[jni_uno bridge error] UNO calling Java methode
Just guessing, Thomas, but I suspect the first questions the experts
will ask you next is: What LO version are you using on what operating
system.
you will find it under Help > AboutLibreOffice and click Version
Information and paste that to a mail. That way you might pre-empt the
experts'
Hallo Robert,
this seems to work, but somewhat counter-intuitively, in the sense that
the selected objects appear to become grouped, prior to aligning them.
In other words, It becomes impossible to identify which objects have
been selected for alignment.
But thanks for the tip. It kinda helps to
Yes, I did. Crtl-Shift groups the chosen elements
On Wed, 2022-02-23 at 08:42 -0500, Dan Lewis wrote:
> Have you tried Crtl+Shift to select separate elements?
>
> Dan
>
> On 2/23/22 6:52 AM, Harvey Nimmo wrote:
> > While trying to edit form elements for LO Base I am exp
While trying to edit form elements for LO Base I am expecting to be
able to select individual form elements, e.g. to align them, and size
them together. However, using the Ctrl button to select more than one
form element (e.g. text boxes) causes a second box, say, to be selected
and a previous box
I'm not quite sure how I understand this answer to sleepy's question.
Is it "No, macros are off by default" or "Yes...but..."?
"Excel VBA not likely to run..": I assume it is not designed to run
Excel VBA?
Cheers
Harvey
On Wed, 2021-10-06 at 09:05 -0400, Alan B wrote:
> Default in LO 7.1.5.2
>
Dunkel wrote:
> > A two-column TABLE seems to be a very smart solution for this.
> > Thank you, Harvey.
> >
> > - - - - -
> >
> > Am 15.04.21 um 12:09 schrieb Harvey Nimmo:
> > > Hi,
> > > I sometimes have to translate documents. So that I can see t
Hi,
I sometimes have to translate documents. So that I can see the
relationship of the texts I put one language on the right and the other
left on the page. For that I use a two-column table which works quite
well. Not sure if that is the most elegant solution for what you want.
Of course you can
the blank pages.
Many thanks, again
Harvey
On Tue, 2020-12-15 at 09:42 -0800, Richard England wrote:
> Is there a page break inserted at the end of the template page?
>
> ~~R
>
>
> On 12/15/20 8:53 AM, Harvey Nimmo wrote:
> > and finally
> > It is not
-15 at 17:39 +0100, Harvey Nimmo wrote:
> Sorry, I forgot to provide the LO version I am using:
> LO Version: 6.4.5.2Build ID: 40(Build:2)CPU threads: 2; OS: Linux
> 5.3; UI render: default; VCL: gtk3; Locale: en-GB (en_GB.UTF-8); UI-
> Language: en-GBCalc: threaded
> And additionall
in the statistics at the foot of the window, but fails to show
the blank pages, i.e. only 7 pages are shown.
CheersHarvey
On Tue, 2020-12-15 at 17:30 +0100, Harvey Nimmo wrote:
> What could be going wrong here? Can anyone help?
> I am trying to print a set of address labels (3x5 per page) us
What could be going wrong here? Can anyone help?
I am trying to print a set of address labels (3x5 per page) using LO
Base connected to a remote MariaDB. The report facilities correctly
show the data I want to be printed.
The label procedure apparently produces the label report corresponding
to
was expecting some simple implementation but, to my surprise, did not
find such. In the meantime Remy has made a suggestion that show how
much more complex it could be, than expected.
Greetings
Harvey
On Sat, 2020-05-30 at 22:49 +0200, Regina Henschel wrote:
> Harvey Nimmo schrieb am 30-
k on a style and then New...)
> I hope this helps.
> Rémy.
>
>
> Le samedi 30 mai 2020 à 18:54 +0200, Harvey Nimmo a écrit :
> > My intention was to use the header function to describe each page
> > of a29 page document separately, with a couple of exceptions where
>
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
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
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
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
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
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 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
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)
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
> >
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 a
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
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 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` =
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
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
>
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 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
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),
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 a pr
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 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 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
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 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(
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
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
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
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 o
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
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 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"?
you 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.
>
>
1 - 100 of 166 matches
Mail list logo