Fabien Bodard ha scritto:
> Le 11 février 2010 15:23, Benoît Minisini
> <gam...@users.sourceforge.net> a écrit :
>
>>> sql = "CREATE TABLE Aplianikis ("
>>> "aa BIGINT(20) NOT NULL auto_increment,"
>>> "Eponimia VARCHAR(40) NOT NULL,"
>>> "AFM VARCHAR(18) NOT NULL,"
>>> "Hmerominia DATE NOT NULL,"
>>> "Checkbox TINYINT(1) NOT NULL,"
>>> "primary key(aa)"
>>> ")"
>>> "DEFAULT CHARSET=utf8"
>>>
>>> DB.Exec(sql)
>>>
>>> gambas version :
>>>
>>> Dim htable As Table
>>> htable = db.Tables.Add("Aplianikis")
>>>
>>> htable.Fields.Add("aa", db.Serial, 10)
>>> htable.Fields.Add("Eponimia", db.String, 40)
>>> htable.Fields.Add("AFM", db.String, 18)
>>> htable.Fields.Add("Hmerominia", db.Date)
>>> htable.Fields.Add("Checkbox", gb.Boolean,, False)
>>> htable.PrimaryKey.Add("aa")
>>>
>>> htable.Update
>>>
>>> Query to Benoit ... is there a way to define 'NOT NULL' entry via gambas
>>> code ?
>>>
>>>
>> You have to define the default value. What's the point of having a mandatory
>> field (NOT NULL) without a default value?
>>
> just say i want something ... but i can't say what because there is
> not default rules.
> and then advise the user that he need to say someting by himself
>
> for example my age can't be 0
>
A default value does not imply that a value is required, and a "not
null" clause does not imply a default value.
It seems, indeed, very reasonable: all the four cases have a useful
meaning, and any simplification, I think, would be limiting. Another
example, after the one from Fabien, is the Name field of a private
person. I am sure I want the name of the person, but which name would be
a suitable default? John Smith? And a default value with no "not null"
clause makes sense too in many cases.
Just a thought... regards,
Doriano
------------------------------------------------------------------------------
SOLARIS 10 is the OS for Data Centers - provides features such as DTrace,
Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW
http://p.sf.net/sfu/solaris-dev2dev
_______________________________________________
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user
