Re: [sqlite] A problem with 'pragma table_info(...)'

2016-09-27 Thread Zsbán Ambrus
On Wed, Sep 21, 2016 at 9:57 AM, Stepan Zakharov wrote: > We are using VFS however, may be that can be ill-implemented somehow so it > makes PRAGMA not to work.. It can. And I think you're the third person on the mailing list to fall into that trap. From an earlier mail

Re: [sqlite] A problem with 'pragma table_info(...)'

2016-09-21 Thread Dan Kennedy
ate: Wed, 21 Sep 2016 13:47:41 +0700 From: danielk1...@gmail.com To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] A problem with 'pragma table_info(...)' On 09/21/2016 01:44 PM, Stepan Zakharov wrote: Yes, of course it looks different.pragma table_info(TABLENAME);Where TABLENAME is

Re: [sqlite] A problem with 'pragma table_info(...)'

2016-09-21 Thread Clemens Ladisch
Stepan Zakharov wrote: > Nothing & Nothing. Just returns SQLITE_OK, doesn't enter into Callback. This program: #include #include static int callback(void *p, int cols, char **data, char **names) { printf("%s %s %s %s %s %s\n", data[0], data[1], data[2], data[3], data[4],

Re: [sqlite] A problem with 'pragma table_info(...)'

2016-09-21 Thread Stepan Zakharov
what to think anymore. It looks like will have to parse the SQL Create statement, eventually.. > Date: Wed, 21 Sep 2016 13:47:41 +0700 > From: danielk1...@gmail.com > To: sqlite-users@mailinglists.sqlite.org > Subject: Re: [sqlite] A problem with 'pragma table_info(...)' > >

Re: [sqlite] A problem with 'pragma table_info(...)'

2016-09-21 Thread Dan Kennedy
behaviour. Does "PRAGMA table_info('sqlite_master');" return any results? What does "PRAGMA compile_options;" say? Dan. To: sqlite-users@mailinglists.sqlite.org From: clem...@ladisch.de Date: Wed, 21 Sep 2016 08:27:32 +0200 Subject: Re: [sqlite] A problem with 'pragma tabl

Re: [sqlite] A problem with 'pragma table_info(...)'

2016-09-21 Thread Stepan Zakharov
org > From: clem...@ladisch.de > Date: Wed, 21 Sep 2016 08:27:32 +0200 > Subject: Re: [sqlite] A problem with 'pragma table_info(...)' > > Stepan Zakharov wrote: > > it does not return any results > > That is because the table name is not correctly quoted: &g

Re: [sqlite] A problem with 'pragma table_info(...)'

2016-09-21 Thread Clemens Ladisch
Stepan Zakharov wrote: > it does not return any results That is because the table name is not correctly quoted: sqlite> pragma table_info(...); Error: near ".": syntax error Or does your statement look different? Regards, Clemens ___

[sqlite] A problem with 'pragma table_info(...)'

2016-09-20 Thread Stepan Zakharov
Hello all,I am struggling the whole day with this pragma. The problem is it does not return any results (I am using C api).Tried both with self-compiled amalgamation and pre-compiled binaries for Windows x64 (downloaded latest from SQLite.org).Just even not a single row this call returns.Tried