Ocke Janssen wrote:
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.
Alright went and tried a few variations. I see it now, the value is a
literal that must make sense to
the formatting specification for the column.
OK, then the ONLY way to create default settings for any data type, at
the engine, is by entering DDL directly in
the SQL window - or of course designing your database in some tool other
then OOBase.
Is that correct?
I can understand the path of least resistance on this, but I am a little
disappointed.
I suppose the way to say this is that OOBase is not indended to be a
general purpose database admistration tool.
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
