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
>
> --
> Benoît Minisini
>
> ------------------------------------------------------------------------------
> 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
>
------------------------------------------------------------------------------
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
