Re: [sqlite] SQLite Viewer Tool

P/Vista/7 product only. > > Simon. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Regards, 灵感之源 ___

Re: [sqlite] offical full list of valid data types?

thanks guys, I got it. I am making a data convert function for my free tool, so I need an official list, I mean the sqlite engine, not other wrappers. just curious abou it. 2008/11/4, Brad Stiles <[EMAIL PROTECTED]>: > > >I found that the ado.net provider for sqlite support some types that

Re: [sqlite] offical full list of valid data types?

t; size definition? let's say CHAR(50), VARCHAR(100), > > TEXT(200), BLOB(500) etc? > > Yes, syntactically they do, but the size definition is > simply ignored. > > If you want strict typing, you will have to add that layer > in your application or enforce

[sqlite] offical full list of valid data types?

Hi, I found an offical mention here: http://www.sqlite.org/datatype3.html but seems not a "full list", because it only mention some "Affinity". I want a full list of ALL VALID data types that sqlite really support, here is my result, does anyone could make it really full list? REAL

[sqlite] how to add multiple columns at a time

Hi, I want to add multiple columns, the following works for only one column: ALTER TABLE Data ADD COLUMN Password TEXT but not this: ALTER TABLE Data ADD COLUMN (Password TEXT, User TEXT) nor this: ALTER TABLE Data ADD (Password TEXT, User TEXT) --

[sqlite] how to add multiple columns at a time

Hi, I want to add multiple columns, the following works for only one column: ALTER TABLE Data ADD COLUMN Password TEXT but not this: ALTER TABLE Data ADD COLUMN (Password TEXT, User TEXT) nor this: ALTER TABLE Data ADD (Password TEXT, User TEXT) --