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
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
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,
> 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
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
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
> 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,
> 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
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
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
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.
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
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
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 =
14 matches
Mail list logo