Re: [sqlite] How to insert control characters into a table

2011-12-31 Thread Luuk
On 31-12-2011 22:16, Kai Peters wrote: > > Hi, > > how can I insert a control character like carriage return? > > Something like: > > update fielddefs set choices = 'Male' || '\r' || 'Female' where id = 2 > > Thanks for any help > Kai on a Windows-machine, this works: press, and keep

[sqlite] How to insert control characters into a table

2011-12-31 Thread Kai Peters
Hi, how can I insert a control character like carriage return? Something like: update fielddefs set choices = 'Male' || '\r' || 'Female' where id = 2 Thanks for any help Kai ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] transparent compression implementations for SQLite?

2011-12-31 Thread Simon Slavin
On 31 Dec 2011, at 8:37pm, Ivan Shmakov wrote: >> Simon Slavin writes: >> On 31 Dec 2011, at 4:56pm, Ivan Shmakov wrote: > >>> The integers could take up to 32 bits long, but I deem them likely >>> to “cluster”, like, e. g.: 1, 1, 1, 1, 2, 2, 2, 3, 3, 3, 101, 101,

Re: [sqlite] transparent compression implementations for SQLite?

2011-12-31 Thread Ivan Shmakov
> Simon Slavin writes: > On 31 Dec 2011, at 4:56pm, Ivan Shmakov wrote: >> The integers could take up to 32 bits long, but I deem them likely >> to “cluster”, like, e. g.: 1, 1, 1, 1, 2, 2, 2, 3, 3, 3, 101, 101, >> 102, 102, 102, 103, 103, 768, 768, etc. My

Re: [sqlite] transparent compression implementations for SQLite?

2011-12-31 Thread Kees Nuyt
On Sat, 31 Dec 2011 23:56:18 +0700, Ivan Shmakov wrote: > However, this makes me wonder, is there a way to determine the > filesystem space occupied by a particular table, or index, in > SQLite? For that purpose, the download page

Re: [sqlite] transparent compression implementations for SQLite?

2011-12-31 Thread Simon Slavin
On 31 Dec 2011, at 4:56pm, Ivan Shmakov wrote: > The integers could take up to 32 bits long, but I deem them > likely to “cluster”, like, e. g.: 1, 1, 1, 1, 2, 2, 2, 3, 3, 3, > 101, 101, 102, 102, 102, 103, 103, 768, 768, etc. My guess is > that such sequences should be

Re: [sqlite] transparent compression implementations for SQLite?

2011-12-31 Thread Ivan Shmakov
> Roger Binns writes: > On 30/12/11 20:10, Ivan Shmakov wrote: >> The problem is that I have a table, each row holding something like >> 64 bytes of data (of BLOB and INTEGER types), which don't seem too >> compressible, but these rows themselves tend to be similar to each >> other,

Re: [sqlite] transparent compression implementations for SQLite?

2011-12-31 Thread Ivan Shmakov
> Simon Slavin writes: > On 31 Dec 2011, at 7:11am, Ivan Shmakov wrote: >> Download the code and prebuilt DLL. > It includes both. In other words, the vfs_compress.c file you asked > for is in there. Indeed. Thanks! -- FSF associate member #7257

Re: [sqlite] error message

2011-12-31 Thread Richard Hipp
On Fri, Dec 30, 2011 at 12:59 PM, Duane Mullen wrote: > Whenever I restart my computer I get an error message that the > "sqlite3_wal_checkpoint could not be located in dynamic link library > SQLite3.dll." > Would you please help me fix this problem? > Reinstall iTunes

[sqlite] error message

2011-12-31 Thread Duane Mullen
Whenever I restart my computer I get an error message that the "sqlite3_wal_checkpoint could not be located in dynamic link library SQLite3.dll." Would you please help me fix this problem?  ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] About Joining Multiple Tables

2011-12-31 Thread Simon Slavin
On 31 Dec 2011, at 8:36am, Sushil Dudhalkar wrote: > You are right :-) The lengths are different. I will correct that. Thank > you Simon. Will remember this for the rest of my life. No problem. Common mistake when importing data. Good luck with it. Simon.

[sqlite] About Joining Multiple Tables

2011-12-31 Thread Sushil Dudhalkar
You are right :-) The lengths are different. I will correct that. Thank you Simon. Will remember this for the rest of my life. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] About Joining Multiple Tables

2011-12-31 Thread Simon Slavin
On 31 Dec 2011, at 8:04am, Sushil Dudhalkar wrote: > Thanks Simon. I did the lookup which goes straight from the PO to the > Suppliers table. But again the same result. All the fields from the PO table > are returned but nothing from the Suppliers table. Where could i be wrong? > Thanks again

[sqlite] About Joining Multiple Tables

2011-12-31 Thread Sushil Dudhalkar
Try doing a lookup which goes straight from the PO to the Suppliers table: SELECT PO.Po_ID, PO.Po_Date, PO.QuoteNum, PO.PayTerms, PO.DeliveryDate, PO.VAt, PO.SrvcTax, PO.Amount, Suppliers.SName, Suppliers.Address1, Suppliers.Address2, Suppliers.City, FROM PO LEFT JOIN Suppliers ON PO.SuppID =