Re: [sqlite] v3 pragmas

2004-07-26 Thread Miguel Angel Latorre Díaz
"sqlite" <[EMAIL PROTECTED]> Sent: Monday, July 26, 2004 2:59 PM Subject: RE: [sqlite] v3 pragmas > > Is there any way to know the type of the current statement, > > i.e.: select, > > insert, delete, etc? > > I would like to know it to retrieve the sqlite3

RE: [sqlite] v3 pragmas

2004-07-26 Thread CARIOTOGLOU MIKE
> Is there any way to know the type of the current statement, > i.e.: select, > insert, delete, etc? > I would like to know it to retrieve the sqlite3_changes() > value after the > statement has finished to return that value to the user. > (almost) what you need : ** Return the number of column

[sqlite] v3 pragmas

2004-07-22 Thread Miguel Angel Latorre Díaz
I just discovered that malformed pragma's statements return SQLITE_DONE. For instance "pragma table_info (foo);" if table "foo" does not exist, SQLITE_DONE is returned. Also occurs in completely malformed pragma's like "pragma x;". Also verified in v.2.8.13 One question: I'm returning a recordset