Re: [sqlite] Error in FTS documentation?

On 02/05/2012 09:07 AM, Nils D. wrote: Maybe this is old, but there is - as far as I understand the descriptions and the results - an error in the fts documentation. In section 4.3 http://www.sqlite.org/fts3.html#matchinfo in the example it says: "-- The format string for this query is "nl".

Re: [sqlite] Accessing temporary tables

Each database has a SQLITE_TEMP_MASTER table for temp tables and temp triggers. See http://www.sqlite.org/faq.html#q7 Best regards, Peter From: Pete To: sqlite-users@sqlite.org Sent: Sat, February 4, 2012 5:26:21 PM Subject:

[sqlite] Error in FTS documentation?

Maybe this is old, but there is - as far as I understand the descriptions and the results - an error in the fts documentation. In section 4.3 http://www.sqlite.org/fts3.html#matchinfo in the example it says: "-- The format string for this query is "nl". The output array will therefore -- contain

Re: [sqlite] Accessing temporary tables

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 04/02/12 16:26, Pete wrote: > How do I get a list of any temporary tables in a database? There is a separate database named 'temp' that contains temporary tables. (The main database is named 'main' and you can omit its name.) sqlite> pragma

[sqlite] Accessing temporary tables

I'd like to get some guidance on accessing and using temporary tables, i.e. those created using the TEMPORARY keyword. How do I get a list of any temporary tables in a database? They don't appear in the sqlite_master table. Once I have a list, can I use some form of PRAGMA table_info to get a

Re: [sqlite] SQLite and EF and Generate DB from Model

Based on the attached exception you provided, it looks like you are trying to run the "test.exe" application included in the precompiled binary package? Since that application attempts to create a database in the same directory as the application, it would need to be run with administrator

Re: [sqlite] Re; update problem

self.con.commit() wins the prize. Thanks, now if I can just find () on the keyboard jd On Saturday, February 04, 2012 03:04:27 PM Black, Michael wrote: > I think I found your problem. > > > > Change > > self.con.commit > > To > > self.con.commit() > > > > In your Fupdate

Re: [sqlite] Re; update problem

Thanks for responding, Every time this module runs, it calls the Kupdate class. In the Kupdate class the data in the collumn named "row_1" should be updated to contain the value, '1) Add New Name' see >> self.divAddName = '1)Add New Name' << in Kupdate When finished

Re: [sqlite] Re; update problem

I think I found your problem. Change self.con.commit To self.con.commit() In your Fupdate function sqlite> .dump PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE abc800_111__FIRST (pink varchar,

[sqlite] Segmentation fault on sqlite3_create_module

> > change this code: > > typedef struct NiuRoutingStruct { > > sqlite3_vtab vtab; > > } NiuRouting; > > to this: > > struct NiuRouting : public sqlite3_vtab vtab { > > ... // your implementation, eventually > > }; > > > > This way, the casting is unnecessary

[sqlite] SQLite and EF and Generate DB from Model

** Exception Text ** System.Data.SQLite.SQLiteException (0x80004005): Unable to open the database file at System.Data.SQLite.SQLite3.Open(String strFilename, SQLiteOpenFlagsEnum flags, Int32 maxPoolSize, Boolean usePool) in

Re: [sqlite] Re; update problem

I don't know python for squatso this is what I get with your codewhat do you expect? ./py abc800_111__FIRST ## tablename sql_test 24 ## locate sql_test 34 [] ## Rcount sql_test 69 ['abc', '800 111 ', 'FIRST'] ## vRecordKey sql_test 97 [(u'1)No Row Name',)] ## divcolinfo

[sqlite] About new ticket "Per page/region checksums"

It's very important but there are some questions about http://www.sqlite.org/src/info/72b01a982a Some times ago DRH wrote that checksum calculation don't slow down SQLite significantly. But can be this realized in current SQLite 3.x branch? When checksum can help to restore damaged pages/database?