Am 31.05.2012 18:40, Pablo M Ibáñez wrote:
Hi all
Thanks for LO, very good!
In base, I was wondering how to have the creation date of a new entry
automaticaly inserted in the corresponding field?
Thanks a lot for your help!
Pablo
menu:Tools>SQL...
ALTER TABLE "table name" ALTER COLUMN "colum
Le 31/05/12 19:21, Andreas Säger a écrit :
Hi Andreas,
>
> menu:Tools>SQL...
> ALTER TABLE "table name" ALTER COLUMN "column name" SET DEFAULT
> CURRENT_DATE
I just tried that, and what do you know, it didn't work :
With an existing hsqldb db Table containing :
ID int autoincrement=YES
numseq
Am 31.05.2012 19:58, Alexander Thurgood wrote:
Tried entering a new tuple. Tab between fields, when I get to the last
field, i.e. the dtchg field, I leave blank and press Tab. Error !!
Non-nullable field.
"Attempt to insert null into a non-nullable column: column: ID table:
seq3 in statement [I
Le 31/05/12 20:29, Andreas Säger a écrit :
> Works for me. The error message occurs only when I send a new record
> from a form.
I was entering data directly from the table grid view.
>
> There is an option to avoid this problem if you don't want a nullable date:
> Edit>Database>Advanced Opti
: [libreoffice-users] Re: (unknown)
To: users@global.libreoffice.org
Date: Friday, 1 June, 2012, 8:26
Le 31/05/12 20:29, Andreas Säger a écrit :
> Works for me. The error message occurs only when I send a new record
> from a form.
I was entering data directly from the table grid view.
>
&