Re: [sqlite] [sqlite-dev] Implementing per-value custom types

On 2014-11-26, 7:53 AM, RSmith wrote: > The fact that inside of SQLite an Integer can be stored in different > ways is simply a code/data/space optimisation for SQLite, it is > transparent to the user and transparent to the SQL - it is in no way > intended as a data-feature or extension of the SQL

Re: [sqlite] DLL WITH SAMPLE CODE FOR VISUAL BASIC 6 TO ACCESS AN SQLITE3 DATABASE

Sang Wong writes: > Do you have a .DLL LIBRARY and > SAMPLE CODE showing how to use VISUAL BASIC 6 with an sqlite3 > DATABASE? Thank You. Check this out - highly recommended: http://www.vbforums.com/showthread.php?726437-VB6-SQLite-DB-Demos-%28based-on-the-RichClient-Framework%29

[sqlite] DLL WITH SAMPLE CODE FOR VISUAL BASIC 6 TO ACCESS AN SQLITE3 DATABASE

Dear Sir, I cannot get my copy of AGS_SQLite.dll to work with Visual Basic 6 and a DATABASE created with sqlite3 .. Do you have a .DLL LIBRARY and SAMPLE CODE showing how to use VISUAL BASIC 6 with an sqlite3 DATABASE? Thank You. Yours Truly, Sang Wong.

Re: [sqlite] PRAGMA table_info incomplete

My apologies, I was accessing the wrong database :( Thanks. Staffan On Fri, Nov 28, 2014 at 12:29 PM, Clemens Ladisch wrote: > Staffan Tylen wrote: > > I've just found out that the column data returned by PRAGMA table_info > does > > not include columns added using ALTER

Re: [sqlite] PRAGMA table_info incomplete

Staffan Tylen wrote: > I've just found out that the column data returned by PRAGMA table_info does > not include columns added using ALTER COLUMN ADD COLUMN. sqlite> create table t(x); sqlite> pragma table_info(t); 0|x||0||0 sqlite> alter table t add y; sqlite> pragma table_info(t); 0|x||0||0

[sqlite] PRAGMA table_info incomplete

I've just found out that the column data returned by PRAGMA table_info does not include columns added using ALTER COLUMN ADD COLUMN. I guess this is either a bug or the documentation is incomplete. If it's a bug I would welcome a fix. If on the other hand it's 'by design', what method is