[Gambas-user] SHELL command with python does not execute!

[Fabien Bodard]

Le 11 février 2010 15:23, Benoît Minisini
<gambas at ...1...> 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 at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>