u...and so quickly we reach the limits of my understanding here. Whoops.
So I thought I was demonstrating that command with that one line I
referenced. Does it help to put the whole table setup? Or would all the
tables be helpful? Again here I used the Mental Health Clinic Database
(from
Hi,
On Thu, 2011-08-18 at 04:52 -0700, ncreamer wrote:
CREATE TABLE Vulnerability (
Vuln ID INTEGER NOT NULL,
Vulnerability INTEGER NOT NULL,
VulnInstance NUMERIC(10) DEFAULT 1,
CONSTRAINT PK_ISSUE PRIMARY KEY (Vulnerability, Vuln ID ),
CONSTRAINT FK_ISSUE FOREIGN KEY (Vulnerability)
Le 17/08/11 20:53, ncreamer a écrit :
Hi,
Helpful thread - thank you. Any idea why not even the SQL tool will set a
default value for me? I spent lots of time in the Base_Tutorial and created
tables with SQL. The field that follows does NOT have a default value of 1
and, as this thread
Le 17/08/11 20:53, ncreamer a écrit :
And this :
http://user.services.openoffice.org/en/forum/viewtopic.php?f=61t=26194#p119217
Alex
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Helpful thread - thank you. Any idea why not even the SQL tool will set a
default value for me? I spent lots of time in the Base_Tutorial and created
tables with SQL. The field that follows does NOT have a default value of 1
and, as this thread confirms, I can't set it in design mode.
Hi,
On Wed, 2011-08-17 at 11:53 -0700, ncreamer wrote:
Helpful thread - thank you. Any idea why not even the SQL tool will set a
default value for me? I spent lots of time in the Base_Tutorial and created
tables with SQL. The field that follows does NOT have a default value of 1
and, as
Le 04/06/11 17:41, Tom Davies a écrit :
Hi all,
Better off looking here first :
https://bugs.freedesktop.org/buglist.cgi?quicksearch=libreoffice+database
As you can see, there are a good number of Base bugs, many of which have
are still unresolved since the very first releases of
I'm suffering the same problem.
OO Base 3.2 workd fine. Having upgraded to LO 3.3 (and tried OO 3.3), any
date format field cannot have a default date set.
My prior embedded HSQL database (from OO2.x, used in OO3.2) doesn't work -
the set default date enters nonsense in the field, which obviously
luck and regards from
Tom :)
- Original Message
From: ugm6hr ugm...@hotmail.com
To: users@libreoffice.org
Sent: Sat, 4 June, 2011 8:59:37
Subject: [libreoffice-users] Re: Base Field Defaut Disables Save
I'm suffering the same problem.
OO Base 3.2 workd fine. Having upgraded to LO
On Tue, May 3, 2011 at 3:05 AM, Alexander Thurgood
alex.thurg...@gmail.comwrote:
Le 03/05/11 00:24, John Shabanowitz a écrit :
Try the solution suggested in this thread :
http://user.services.openoffice.org/en/forum/viewtopic.php?f=61t=26194
i.e. Go to the Tools - SQL menu entry
Enter an
Le 06/05/11 13:42, John Shabanowitz a écrit :
Hi John,
Good Info.
I thought it was a bug because of inconsistent behavior. When you connect
to a MySQL database using Base and Oracle's MySQL connector, you can ALTER,
CREATE, and DROP tables from the GUI in Base. I need to use a reference
Le 03/05/11 14:55, Tod Hopkins a écrit :
Hi Tod,
I would very much like to use Base, but I'm at the edge of having sufficient
knowledge to make it work. It appears that in order to make Base work for
me, I will have to study MySQL and use it as my backend, with base as a front
end.
Thanks for the advice. By mixed-mode you mean the use of HSQLDB front end
with MySQL (or other) backend?
I've been trying to read what documentation there is. Not much. I find that
as soon as I get beyond what I already understand, there is a presumption that
I that I have a working
, 3 May, 2011 15:17:59
Subject: Re: [libreoffice-users] Re: Base Field Defaut Disables Save
Thanks for the advice. By mixed-mode you mean the use of HSQLDB front end
with MySQL (or other) backend?
I've been trying to read what documentation there is. Not much. I find that
as
soon as I get
MySQL is quite simple once you get started. Makes it much easier with a
tool like Webmin.
We started extensively with the old Lotus Approach and then migrated to
PHP/MySQL for general cross platform browser access. I keep looking at
Base, but it hasn't reached the state of Approach so haven't
Le 03/05/11 21:25, John Shabanowitz a écrit :
Hi John,
Why can't Windows screen shots be accepted for the documentation? Is the
Windows
version of LibO that much different from the Linux and Mac versions?
It has nothing to do with differences in versions, but rather Microsoft
Corp's
Le 03/05/11 19:46, Steve Edmonds a écrit :
Hi Steve,
MySQL is quite simple once you get started. Makes it much easier with a
tool like Webmin.
We started extensively with the old Lotus Approach and then migrated to
PHP/MySQL for general cross platform browser access. I keep looking at
Base,
Hi John,
On Tue, 3 May 2011 15:25:35 -0400
John Shabanowitz john...@gmail.com wrote:
On Tue, May 3, 2011 at 10:42 AM, Tom Davies tomdavie...@yahoo.co.uk wrote:
[...]
Why can't Windows screen shots be accepted for the documentation? Is the
Windows
version of LibO that much different
18 matches
Mail list logo