> Benoît Minisini ha scritto:
> >>>>> 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.
> >
> > Mmm. You may be right. :-) But that needs some change in the gb.db
> > component and in all database drivers.
>
> A general idea could be to add a further optional argument "Flags".
> Those bit-mask flags could have a name like "db.bNotNull" for flags
> valid for every database, and names like MySql.bAutoincrement, for
> example, for flags only valid for certain databases. If, in code,
> someone uses a feature with the wrong backend, an error is generated by
> the compiler (unknown symbol). The definition of a field would be, for
> example:
>
> htable.Fields.Add("AFM", MySql.SpecialInteger, 18, db.bNotNull +
> MySql.bAutoIncrement)
>
> Just an idea.
> Regards,
> Doriano
>
The gb.db interface is database independent, so no database specific flag
please.
And if there are only one flag (Not Null), auto-increment being just a special
integer field, I will add just an extra boolean argument, after the default
value.
Regards,
--
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
