Hi Andrew,
the default value you enter in the table design will not be transfered
to the database. This value is used in the control you bind to that column.
E.g. when you open the table you'll see the value in the grid cell.
But you may write an RFE that SQL functions should be allowed as well in
this field.
Best regards,
Ocke
PS: It isn't the default value of the db column because every database
has it's own behavior. :-(
Andrew Jensen wrote:
This came up recently on the OOOForum site.
I know that there is already an issue for the GUI table editor not
passing default values along for bit fields but it seems not
to do so for time, date or timestamp columns also.
If I try to create a timestamp column and set the default to
NOW, using the GUI it failes. If I enter the create table DDL
command in the SQL window using DEFAULT NOW, it works
just fine. Looking at this table later in the table design window,
the default value field is again empty.
So, should I add this to the issue for bit fields or enter a new
issue? Or is there already one there.
Actually this is my other problem. Is it me (i.e. a bear of small brain)
or is it really hard to actually find things in issuzilla using the
search function?
Thanks
Andrew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Ocke Janssen Tel: +49 40 23646 661, x66661
Dipl. Inf(FH) Fax: +49 40 23646 550
Sun Microsystems Inc.
Sachsenfeld 4 mailto:[EMAIL PROTECTED]
D-20097 Hamburg http://www.sun.com/staroffice
Example isn't another way to teach,
it is the only way to teach.
Albert Einstein
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
