> 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?
--
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
