Hello, A main remark to SQLite developers : - Does it exist a Help file .chm for SQLite ? I am quite new user with Database and SQLite and find very hard to get information and documentation. My opinion is that it is totaly NOT intuitive on the web to find information. For comparison I am quite new on Autohotkey software (autohokey.com) and I have no problem to find information and answer on problem (most of the time I find the answer without posting a question).
-> Did I miss something on SQLite web ? or does other users think like me that some improvment should be done ? MaxMax14 -----Message d'origine----- De : [email protected] [mailto:[email protected]]de la part de Wolfgang Enzinger Envoye : dimanche 15 mars 2009 18:39 A : [email protected] Objet : Re: [sqlite] SQLITE : Constraint question > Date: Wed, 11 Mar 2009 19:10:26 -0600 > From: Dennis Cote <[email protected]> > Subject: Re: [sqlite] SQLITE : Constraint question [...] > However, you can explicitly add the equivalent constraints to your table > definitions if you really want them. For example: > > create table t ( > a varchar(15) check (length(a) <= 15), > b integer check (typeof(b) = 'integer') > ); That kind of CHECK constraint is actually a cunning way to enforce strict affinity for a column, isn't it? If so, I think that paragraph 6 (Other Affinity Modes) in http://sqlite.org/datatype3.html should be updated or completed accordingly. AFAIK there are no plans to implement the modes "strict affinity" and "no affinity" that are mentioned there ... but maybe I missed something? BTW, is there a document that explains in more detail what operations the CHECK constraint is capable of? Best, Wolfgang Enzinger _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
