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 ?
2010/2/11 Vassilis K <vka...@otenet.gr>:
> I am using python because it executes the table creation commands with
> the same type like in terminal mode. For example in python we write:
>
> 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
> """
>
> cursor.execute(sql)
>
> Because of this I assume that there is less possibility of errors.
>
> Do you suggest to use the Gambas code for table and database creation?
>
>
>
> ------------------------------------------------------------------------------
> 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
