Hi there,
I'm aware of the HSQLDB documentation and the list of available functions.
However, I am not looking for this.
What I want is to understand well for what are used the functions Collect,
Fusion, Intersection.
To understand them, I would like to see an example in the Design View, with
an
Yes, I suspect this is impossible, we cannot have a currency variable,
because we would have to have thousands of different variables according the
thousands of currencies in the world. What BASE can do is to format the way
the output is presented to the user, however, sadly I've discovered that
Hello I'm having some problems creating a query in DesigView mode. I'm trying
to calculate a field with an Alias.
So I have a field in which I have MonthlyGrossWage, that field is numeric,
has no decimals (for simplicity), only 5 digits, and its format is currency
$
In my table, I have a the
Hi there, yes that is right, but what is completely weird is that LibreOffice
Base, using a modified SQL don't have a reference book showing all these
modifications and notations? then where can we find reference for that
modification of the SQL language?
--
View this message in context:
Hello
I need to insert the current date from my computer into a field from a
database.
SQL has a function called NOW() which introduce the current date into a
field. However, I don't know very well how this work. I tried to visit a
website giving code examples in SQL... w3schools.com however I
Hi, seems to be LibreOffice base it's using HSQLDB...
However, I don't know if there is available any website describing examples
of code of HSQLDB for LibreOffice Base...
someone here knows any?
--
View this message in context:
Hello I'm starting with queries and functions. Right now I know how to tackle
queries, but I don't know very well how may I use functions on queries. I
would like to master all functions, so I need examples with functions. The
problem is I don't know where may I find help with this? *I'd like to
Hi Andreas, thanks for the amazing info you gave me.
Well, I was not meaning to SQL, because what I want to do right now are
queries using the gird, the queries window.
I wanted some examples of this, with already created queries.
Exactly the last link you gave me...