Thanks Igor! At first I thought that LTRIM you were refering to VB6, but then I noticed this is in a Create Table statement which then implied to me SQL stuff. I did a search and found that LTRIM is also a SQLite function/expression. Now is the expression 'check' also some predefined function in SQLite. Can you direct me to some resource on the web for this.
Sincerely, Palmer > To: sqlite-users@sqlite.org > From: [EMAIL PROTECTED] > Date: Mon, 19 May 2008 13:25:53 -0400 > Subject: Re: [sqlite] SQLite : text datatype and referential integrity > > palmer ristevski <[EMAIL PROTECTED]> > wrote: > > Say one defines a column to be of text type, > > but you want only 'text' to contain only alphabetic characters, > > no numeric characters, how would one create this rule and enforce it > > in SQLite SQL or does one have to use triggers. > > Perhaps something like this: > > create table t(x check (ltrim(x, 'ABC...Zabc...z') = '')); > > (with full alphabet in place of ellipsis, of course). > > > Another question I have is, has proper referential integrity been > > finally established > > and things like full joins and other joins. > > No. Still no foreign keys, and only left outer joins. > > Igor Tandetnik > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _________________________________________________________________ E-mail for the greater good. Join the i’m Initiative from Microsoft. http://im.live.com/Messenger/IM/Join/Default.aspx?source=EML_WL_ GreaterGood _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
