Kees Nuyt wrote:
Will
PRAGMA table_info(tablename);
do?
>>> from pysqlite2 import dbapi2
>>> db = dbapi2.connect('/data/mariof/test.db')
>>> cr = db.cursor()
>>> cr.execute('pragma table_info(test3)')
>>> cr.fetchall()
[(0, u'd', u'date', 0, None, 0),
(1, u'h', u'time', 0, None, 0),
(2, u't'
Hi Gerry, thanks for this info, much appreciated.
John.
On 07/08/06, Gerry Snyder <[EMAIL PROTECTED]> wrote:
John Newby wrote:
> Hi, can anyone direct me to the right page relating to the sqlite_master
> table please, I am unable to find it on the website.
I do not know of a single complete de
Hi everyone.
I am thinking about upgrading sqlite version, and I found lots of things
changed in sqlite3, for example, sqliteBtreeUpdateMeta(Btree *pBt, int
*aMeta) changed to sqlite3BtreeUpdateMeta(Btree *p, int idx, u32 iMeta),
What should I put in idx and iMeta? and old code require call
Begi
John Newby wrote:
Hi, can anyone direct me to the right page relating to the sqlite_master
table please, I am unable to find it on the website.
I do not know of a single complete description (other than the source code).
The table is discussed near the bottom of the CREATE TABLE page in the
sy
Hi, can anyone direct me to the right page relating to the sqlite_master
table please, I am unable to find it on the website.
Many thanks
John
That is correct -- it is ASP and COM object. I'll go ahead and report it to
that forum. Thanks.
-Original Message-
From: Robert Simpson [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 06, 2006 4:40 PM
To: sqlite-users@sqlite.org; [EMAIL PROTECTED]
Subject: RE: [sqlite] Connection error t
You'll have to report this on the forum where you got the wrapper you're
using. It looks like ASP and COM objects?
> -Original Message-
> From: Artie Pagan [mailto:[EMAIL PROTECTED]
> Sent: Sunday, August 06, 2006 12:09 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Connection err
I am using the following to connect to a SQLite3 database:
***
Set db = server.CreateObject("newObjects.sqlite.dbutf8")
db.AutoType = True
8 matches
Mail list logo