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
recommende
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
1|y|
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 COLUMN ADD COLUMN.
>
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.
__
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
Wolfgang
__
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
6 matches
Mail list logo