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
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
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],
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(...)'
>
>
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
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
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
___
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
8 matches
Mail list logo