On 16/10/2013 22:04, Igor Tandetnik wrote:
On 10/16/2013 4:49 PM, dean gwilliam wrote:
if I have two tables
1 aliases (std_name, raw_name)
2 items (name..)
what would the query look like to select all name fields in itms
that match neither std_name or raw_name in aliases
and where the
Hi --
Okay. It looks like sqlite3_win32_mbcs_to_utf8() is being called from a
number of functions, including sqlite3_value_blob, sqlite3_randomness,
sqlite3_extended_errcode, and sqlite3_os_init.From a spot check of the
execution trace it looks like sqlite3_os_init is probably the most
On Thu, Oct 17, 2013 at 8:31 AM, Mike Clagett mike.clag...@mathworks.comwrote:
Hi --
Okay. It looks like sqlite3_win32_mbcs_to_utf8() is being called from a
number of functions, including sqlite3_value_blob, sqlite3_randomness,
sqlite3_extended_errcode, and sqlite3_os_init.From a spot
Hi --
Okay. This is helpful. It appears the profiler is not doing such a good job
at name resolution. So I've been looking down a wrong path. However, there
definitely is a problem; whether or not I run the profiler, the app is taking a
huge amount of time to execute. So I don't think
On 10/17/2013 3:35 AM, dean gwilliam wrote:
On 16/10/2013 22:04, Igor Tandetnik wrote:
On 10/16/2013 4:49 PM, dean gwilliam wrote:
if I have two tables
1 aliases (std_name, raw_name)
2 items (name..)
what would the query look like to select all name fields in itms
that match neither
On Thu, Oct 17, 2013 at 9:37 AM, Mike Clagett mike.clag...@mathworks.comwrote:
Hi --
Okay. This is helpful. It appears the profiler is not doing such a good
job at name resolution. So I've been looking down a wrong path. However,
there definitely is a problem; whether or not I run the
Joseph L. Casale wrote:
CREATE TABLE t (
id INTEGER NOT NULL,
a VARCHAR NOT NULL COLLATE 'nocase',
b VARCHAR COLLATE 'nocase',
c VARCHAR CHECK (c IN ('foo', 'bar', NULL)) COLLATE 'nocase',
PRIMARY KEY (id)
);
How does one
On 17/10/2013 14:45, Igor Tandetnik wrote:
On 10/17/2013 3:35 AM, dean gwilliam wrote:
On 16/10/2013 22:04, Igor Tandetnik wrote:
On 10/16/2013 4:49 PM, dean gwilliam wrote:
if I have two tables
1 aliases (std_name, raw_name)
2 items (name..)
what would the query look like to select all
L'accesoire indispensable :
http://www.adafruit.com/products/1533
On 17 October 2013 16:29, dean gwilliam mgbg25...@blueyonder.co.uk wrote:
On 17/10/2013 14:45, Igor Tandetnik wrote:
On 10/17/2013 3:35 AM, dean gwilliam wrote:
On 16/10/2013 22:04, Igor Tandetnik wrote:
On 10/16/2013
oups, sorry !
On 17 October 2013 16:36, Noel Frankinet noel.franki...@gmail.com wrote:
L'accesoire indispensable :
http://www.adafruit.com/products/1533
On 17 October 2013 16:29, dean gwilliam mgbg25...@blueyonder.co.ukwrote:
On 17/10/2013 14:45, Igor Tandetnik wrote:
On 10/17/2013
If I have decoded correctly what you were trying to say, use a trigger
like this, and duplicate it for UPDATE:
Thanks Clemens, this got me sorted out.
jlc
___
sqlite-users mailing list
sqlite-users@sqlite.org
If you have any issues with the current code, please report them via this
mailing
list (and/or by creating a ticket on https://system.data.sqlite.org/;)
prior to
next Friday, October 25th.
Thanks.
--
Joe Mistachkin
___
sqlite-users mailing list
Was there any current or future resolution to this issue:
http://www.mail-archive.com/sqlite-users@sqlite.org/msg57117.html
We seem to be hitting the same problem.
We have a series of servers on AWS that use sqlite for backend storage.
Under relatively rare circumstances (suddenly we have a lot
13 matches
Mail list logo
