Hi zed,
you have to set the filter in subquery.
Could be this is what you want to get:
SELECT SUM( "No" ) FROM (SELECT * FROM "Reactor_Videos Table 1" WHERE
"First" >= '2020-12-01' AND "Last" <= '2020-12-31' )
You have to set the dates SQL-like in format '-MM-DD'
Regards
Robert
--
I have a database Reactors_Videos and three of the fields are:
No (Field Type = Number (Numeric)
First (Field Type = Date (DATE)
Last (Field Type = Date (DATE)
I successfully created a Query to display the total number of Reactions.
This Query takes the form
SELECT SUM( "No" ) FROM
Hi Zed,
>
> My first thought was to have the entire database in one Table,
> differentiating the sectors by using different titles for the ID field,
> e.g. ID as an Integer (for the Reactor), IDArtist for the artist as an
> Integer etc. I created the IDArtist as an Integer but when I tried to
>
Using LibreOffice Base v6.4.5.2 on Linux Mint v20.0
Thanks to the assistance given by members of this Mailing List, I have
made progress in creating a database using LibreOffice Base.
I have created a database Reactor_Videos which has the fields
(1) Reactor_Videos Table 1
ID
Name (of
Hi Robert
On 2/08/20 6:37 pm, Robert Großkopf wrote:
Hi Zed,
The Table has one field named "Gender" and the gender is indicated by F,
or M or M/F where a family is involved.
What I was trying to achieve was a query which extracted the total
numbers for each gender (e.g. 50, M25, M/F13)
Hi Zed,
>
> The Table has one field named "Gender" and the gender is indicated by F,
> or M or M/F where a family is involved.
>
> What I was trying to achieve was a query which extracted the total
> numbers for each gender (e.g. 50, M25, M/F13) between a particular time
> period. In this case
Attention: Robert Grosskopf
My apologies for not following convention and replying in the normal
manner but I rather foolishly deleted your advice by mistake,
The information you gave me regarding my request for help on how to
construct a query was just the guide I required to solve my
Hi zed,
>
> Thank you for your very prompt reply. I followed your instructions and
> it returned the sum of entries on the date entered. I obviously didn't
> phrase my questions clearly enough, for what I wanted was the sum of all
> entries for the period 01/07/2020 to 31/07/2020. I cannot find
On 1/08/20 2:14 pm, Dan Lewis wrote:
Comments inline:
On 7/31/20 20:14, zed wrote:
Thank you to all the members who replied so promptly to my request for
help. It is very much appreciated.
One member sent me advice of another method to achieve what I wanted
and I am delighted to say it
Comments inline:
On 7/31/20 20:14, zed wrote:
Thank you to all the members who replied so promptly to my request for
help. It is very much appreciated.
One member sent me advice of another method to achieve what I wanted
and I am delighted to say it worked and I now have a database with the
Thank you to all the members who replied so promptly to my request for
help. It is very much appreciated.
One member sent me advice of another method to achieve what I wanted and
I am delighted to say it worked and I now have a database with the
fields I need, with one Table and one Form.
Hi Harvey,
>>
> Yes, I can enter data directly into a table.
Now create a form (without subform) by the wizard for this table.
Could you enter data there? Then have a look to the datasource of the
other forms ...
Regards
Robert
--
Homepage: http://robert.familiegrosskopf.de
LibreOffice
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
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, not a form. Could you input data here? If not:
Base is missing a primary
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
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_DatenbankErstellen.xhtml#__RefHeading__875_19302748411
Its part of the German Base-Handbuch.
Older (bad) translated versions:
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
Also,
In the issue be sure to show which version of PostgreSQL you are using?
Thanks
On Mon, Oct 1, 2018 at 8:08 AM Drew Jensen
wrote:
> Hi,
>
> You would want to open an issue in the LibreOffice bug tracker and the
> module would be Base.
> postgreSQL should be in the summary of course.
>
>
I have two simle mysql tables with no relationships set between them.
The database containing those tables is MariaDb and the JDBC driver I use to
connect is mariadb-java-client-2.2.6.
Both have a field named "num_vin" among various other fields.
And I created a simple form containing a subform.
Hi all:
I use LibreOffice 6.0.1 on Ubuntu/Debian to access a PostgreSQL database. The
document contains several forms, which shall have a different (optimised
according to the elements in them) size.
However, when I resize one form the a convenient size, all other forms open
with the same
Ubuntu 16.04 LTS
LibreOffice Base
Start with LibreOffice Base ver. 5.1.6.2
Start LibreOffice Base Create new Database > Finish page opens to save the
file name Click on Save and LibreOffice Base Crashes.
Tried various online suggestions but nothing worked, I now install the
latest LO ver. 5.3.4.2
On 04/21/2017 07:00 AM, lismurn wrote:
> 1. Is Base being supported or is it dead in the water.
Base is, and will continue to be supported.
The embedded database engine is in the process of changing from HSQLdb
to FireBird. This change has caused some users to be confused, and think
that the
1. Is Base being supported or is it dead in the water. I have read some
comments in the forums and wonder.
I am trying to assemble a small database but wonder should I continue if it
is not being supported.
I actually enjoy working with Base and only wish I was more computer
literate.
2. In my
Hi,
I am running Libreoffice Version: 5.1.3.2 with Linux Mint 17.3 32 bit and
trying to connect Base to SQLite.
I am using the tutorial at:
https://wiki.openoffice.org/wiki/Documentation/How_Tos/Using_SQLite_With_OpenOffice.org
as I cannot seem to find an equivalent tutorial for Libreoffice.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Bruce,
> On form Form_Filter, is it possible to define the List Box using
> General - List Entries and Data - ValuelList
No problem to define it separately. But I would only use this kind of
entries if I would knew all entries, which ever should
On form Form_Filter, is it possible to define the List Box using General -
List Entries and Data - ValuelList (without using the separate table Filter
and query Query_Filter)? The Base Handbook has brief comments on the List
Entries & ValueList but only defining those items does not produce a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Alanon,
could be you are looking for something like this:
http://robert.familiegrosskopf.de/download/Filter_Database.odb
One table "Table" with the content you will list, one other table
called "Filter" with only one row. A query lists the
thank you Bruce.
I have the Query setup as well as the stand alone or unbound form with the
listbox in it.
I find a way to get the form to execute the Query. In the controls window,
I am finding where actions can trigger, but it only appears to allow me to
add macros...I can't type anything in
> What would I need to write as a criteria so that when the QUERY is run, it
prompts the user to select from a listbox
You must create a form to use the List Box control. If you really only
need a query you can add the choices to the query parameter name. For
example: SELECT "F1", "F2" FROM
Hi,
Thank you in advance for your help!
I'm trying to build a query that would list the records in a database where
the user selects from an existing list of categories.
IE
there are 12 existing categories, each with a bunch of records.
the user wants to review just the records under the category
charles meyer wrote:
That data ended up in that fashion because I was trying to create a
simple list of file names of files located on a flash drive and the
only way I recall doing that in Windows XP - now 7 - is to use the DOS
command which then generates that info as I shared.
I was just
Hi Libre Folks,
Happy New Year to you all.
I have many music files which appear as thus after creating a list of
file names using DOS command and saving in a word processor file:
12/31/2015 10:40 PMFile Size in MBs 1-25-2016 Bryan Ferry - Dont
Stop The Dance Art.mp3
01/09/2016 07:31 PM
You can import your mp3's into iTunes, and from there you can export a
xml with all the necessary data, which you can import in base or calc.
Met vriendelijke groeten, Salutations distinguées, Kind Regards,
DRIES FEYS
CORPORATE SERVICES • Specialist Software Developer
TVH GROUP NV
Brabantstraat
njoy using,
From: charles meyer <reachmepl...@gmail.com>
Date: Thu, Jan 21, 2016 at 2:48 PM
Subject: [libreoffice-users] LibreOffice Base - music cataloging
To: users@global.libreoffice.org
Hi Libre Folks,
Happy New Year to you all.
I have many music files which appear as thus after creat
here's a listing from Gizmo's of the ones they recommend -
> http://www.techsupportalert.com/search/node/music%20sorting
>
>Hope you locate one you enjoy using,
>
>
>
> From: charles meyer <reachmepl...@gmail.com>
> Date: Thu, Jan 21, 2016 at 2:48 PM
Maybe this a really stupid question: but - have you defined the table before
trying to
upload the csv-file ? The LOAD DATA procedure I mentioned before assumes that a
correctly
defined table (CREATE TABLE tablename (col1,col2,...)) with the correct data
types of your
columns exists in the DB.
On Wednesday, 20 January 2016, Ian "Witty" Whitfield <
edi...@federalsaints.net> 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
Hello,
Maybe I don't understand your problem, but...
LO lets you store your calc-spreadsheet as a csv-file. I have just tried that
out.
The format is just fine for then loading into a table as I described earlier.
Regards
H.S.
On Wed, 20 Jan 2016 17:38:12 +0100, Heinrich Stoellinger
Hello again, Ian,
FIELDS ENCLOSED BY '"' does of course only apply to character type fields
(CHAR, DATE,...), not to numeric values.
mysql command client should read mysql command line client...
Regards
H.S.
--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/
--
To
Hello again,
Can you use the LOAD DATA command under the mysql command client? You should
be able to fire this command also under phpmyadmin.
like so...
-
LOAD DATA INFILE "/directory/.../filename.csv"
REPLACE
INTO TABLE table1
FIELDS ENCLOSED BY
Hello
It doesn't really look like you are importing into Base as much as MySQL.
Have you tried this...
In phpMyAdmin, click the table, and then click the Import tab at the
top of the page.
Browse and open the csv file. Leave the charset as-is. Uncheck partial
import unless you have a HUGE
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
Hello Ian,
I am somewhat puzzled by the error message you get:
It seems to me that you are defining multiple columns with the name `NULL`.
To MY knowledge column names should be unique withing one table. Also NULL is
used to specify whether the value of a column may be NULL (i.e. "unknown") or
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 OpSys is PClinuxOS - 32-bit and MySQL is ver 5.1.73. Everything is
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 OpSys is PClinuxOS - 32-bit and MySQL is ver 5.1.73. Everything is
Dear sirs!
I have a problem with using of LibreOffice Base because of message about
non-working Java in my system.
Although Java is installed in my system.
My OS is Windows XP SP3 32-bit on my netbook Asus Aspire One D270k, and i tried
versions JRE-7u79 and JRE-6u45, and also latest Java 8
David Love z...@zed.net.nz wrote:
Using LinuxMint v17.0 Qiana qith the MATE DE.
Have followed with interest the recent discussins on Base and have
decided to try and learn how to use it, using PostGreSQL as the backend.
But - and there is always one of those :-) - how many of the multitude
Using LinuxMint v17.0 Qiana qith the MATE DE.
Have followed with interest the recent discussins on Base and have decided
to try and learn how to use it, using PostGreSQL as the backend. But -
and there is always one of those :-) - how many of the multitude of
postgrsql files in Synaptic do I
Using LinuxMint v17.0 Qiana qith the MATE DE.
Have followed with interest the recent discussins on Base and have
decided to try and learn how to use it, using PostGreSQL as the
backend. But - and there is always one of those :-) - how many of
the multitude of postgrsql files in Synaptic do
Does LibreOffice Base have a runtime file that would enable me to distribute an
application to users who do not have the full version of Base installed on
their computers?
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
to the documentation wiki.
Thanks and regards from
Tom :)
--- On Tue, 31/1/12, drew d...@baseanswers.com wrote:
From: drew d...@baseanswers.com
Subject: [libreoffice-users] LibreOffice Base tutorial
To: users@global.libreoffice.org
Date: Tuesday, 31 January, 2012, 23:00
Howdy List,
Just wanted to pass this URl
Howdy List,
Just wanted to pass this URl along:
http://www.fhi.rcsed.ac.uk/rbeaumont/virtualclassroom/chap8/libreoffice_base.html
Haven't had the chance to read through all of the lessons but it looks
reasonably complete.
//drew
--
For unsubscribe instructions e-mail to:
:)
--- On Tue, 31/1/12, drew d...@baseanswers.com wrote:
From: drew d...@baseanswers.com
Subject: [libreoffice-users] LibreOffice Base tutorial
To: users@global.libreoffice.org
Date: Tuesday, 31 January, 2012, 23:00
Howdy List,
Just wanted to pass this URl along:
http://www.fhi.rcsed.ac.uk
On Wed, 2012-02-01 at 01:40 +, Tom Davies wrote:
Hi :)
Thanks :) Do you think i could add a link to it from the documentation wiki
http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide
I have written to the email address given at the bottom of the page you
To be clear, Don only needs to have the Java box ticked when opening
Base AND using a backend that requires Java, like HSQL.
As for your second paragraph, I suspect you meant but opening WRITER
won't... ? If so, the answer is probably no. LO isn't a
collection of unrelated apps, it's a
Hello again,
On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC
connetcion
to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I then
save
LO-Base, CPU-usage is normal again (for a while!). I don't really know what
causes
this behaviour, could it have to
I think I can help...
On 08/05/2011 01:24 AM, 3flight wrote:
I'm trying to make a small base with a couple of forms to view and add data.
For instance, I have a table Objects and it has two fields location and
assigned to of type INTEGER, because they are linked to ID fields of
tables locations
I'm trying to make a small base with a couple of forms to view and add data.
For instance, I have a table Objects and it has two fields location and
assigned to of type INTEGER, because they are linked to ID fields of
tables locations and people respectively. It is inconvenient to enter
digits in
I'm using libreoffice 3.3.0.OOO330m19 (build:6) tag libreoffice-3.3.0.4. The
bug is the next: on libreoffice base when i try save a table and i write a
default value on a field then libreoffie don't save, but if default value is
null, then libreoffice save.
Thank you and sorry about my english.
59 matches
Mail list logo
