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 ("http://mailinglists.s

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

2016-09-21 Thread Dan Kennedy
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(...)' On 09/21/2016 01:44 PM, Stepan Zakharov wrote: Yes, of course it looks different.prag

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], data[

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

2016-09-21 Thread Stepan Zakharov
GMA not to work.. I don't know 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

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

2016-09-20 Thread Dan Kennedy
.A very strange 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

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

2016-09-20 Thread Stepan Zakharov
nglists.sqlite.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

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

2016-09-20 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-users