Yes, of course it looks different.pragma table_info(TABLENAME);Where TABLENAME
is my table name.I've tried it with single-quotes as well: pragma
table_info('TABLENAME');No results in any case.And no errors. Returns
SQLITE_OK.A very strange behaviour.
> 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 table_info(...)'
>
> 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 mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
