Re: [sqlite] Can I dynamically select a table ?

2011-05-11 Thread Woody & Yuni Ho
It won't work due to syntax. Try putting a select statement as the when part of the case statement. Woody wizard at large(I'm in shape. Round is a shape) Connected by MOTOBLUR™ on T-Mobile -Original message- From: John To: General Discussion of SQLite Database Sent: Wed, May 11, 2011

Re: [sqlite] sqlite3_step to select and update the same table

2010-11-08 Thread Woody & Yuni Ho
Sql can do it. It just takes a properly designed query. Woody wizard at large(I'm in shape. Round is a shape) Connected by MOTOBLUR™ on T-Mobile -Original message- From: cricketfan To: sqlite-users@sqlite.org Sent: Mon, Nov 8, 2010 19:24:54 PST Subject: Re: [sqlite] sqlite3_step to sele

Re: [sqlite] In memory database and locking.

2010-09-08 Thread Woody & Yuni Ho
Have you tried issueing a vacum after n deletes? Woody wizard at large(I'm in shape. Round is a shape) Connected by MOTOBLUR™ on T-Mobile -Original message- From: Hemant Shah To: General Discussion of SQLite Database Sent: Wed, Sep 8, 2010 21:03:21 PDT Subject: Re: [sqlite] In memory d

Re: [sqlite] Removing duplicate entries from a database

2010-07-15 Thread Woody & Yuni Ho
Uhh its cool but been around for over a decade at least. Sorry Woody wizard at large(I'm in shape. Round is a shape) Connected by MOTOBLUR™ on T-Mobile -Original message- From: "Ted Rolle Jr." To: SQLite Database Sent: Thu, Jul 15, 2010 11:45:35 PDT Subject: [sqlite] Removing duplicate