Hi Joseph, Instead of "Mandatory", try "NOT NULL", which means a value must be entered.
However, if a string is set to "", it'll get by this constraint, so you'll still have to check for blank strings programatically if they are mandatory. Ian On Tue, August 15, 2006 16:16, Joseph wrote: > I looked on the sqlite website and I can't find how to implement the > 'mandatory' keyword. The RB database editor has a checkbox for mandatory > so > it must exist in some form. I'm currently using it after the field name > and > field type like this: name varchar Mandatory, address varchar, etc. > > When I pull the created database into the realbasic IDE to look at it the > mandatory boxes are not checked. Could this be a RB database editor issue > or is my sql incorrect? I'm pretty sure that's the standard syntax (at > least it is in the book I'm using as a reference). > > Suggestions? Help? > > ~joe > > > > _______________________________________________ > Unsubscribe or switch delivery mode: > <http://www.realsoftware.com/support/listmanager/> > > Search the archives of this list here: > <http://support.realsoftware.com/listarchives/lists.html> > > -- Ian M. Jones ________________________________________ IMiJ Software http://www.imijsoft.com http://www.ianmjones.net (blog) _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html>
