Andrew Arnott wrote:
>
> The exception raised when I send "VACUUM" as a sql statement is:
> SQLite.SQLiteException occurred
> _HResult=-2146233088
> _message=SQL logic error or missing database
> HResult=-2146233088
> Message=SQL logic error or missing database
> Source=Dart.WinPhone8Lib
I've created a trivial repro project, which you can download here:
http://1drv.ms/N2D4gP
The exception raised when I send "VACUUM" as a sql statement is:
SQLite.SQLiteException occurred
_HResult=-2146233088
_message=SQL logic error or missing database
HResult=-2146233088
Message=SQL logic
I expect I could build a miniature repro if that would be useful to anyone.
On Mar 10, 2014 8:05 PM, "Andrew Arnott" wrote:
> It raises an error, which the sqlite.cs file that everyone uses turns into
> an exception.
> On Mar 10, 2014 6:01 PM, "Simon Slavin" wrote:
>
>>
>> On 11 Mar 2014, at 12:
It raises an error, which the sqlite.cs file that everyone uses turns into
an exception.
On Mar 10, 2014 6:01 PM, "Simon Slavin" wrote:
>
> On 11 Mar 2014, at 12:56am, Andrew Arnott wrote:
>
> > When I upgraded from the SQLite for WinPhone8 SDK v3.8.1 to 3.8.3.1, the
> > VACUUM statement quit wo
In case you didn't find one by now, here's 3.8.3.1:
http://www.sqliteexpert.com/library/
On Mon, Mar 10, 2014 at 4:43 AM, RSmith wrote:
>
> Have any of you kind folks a recent 3.8.3 (or newer) 64-bit DLL for
> SQLite3 perhaps?
>
>
>
> ___
> sqlite-u
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
this coming Friday, March 14th.
Thanks.
--
Joe Mistachkin
___
sqlite-users mailing list
On 11 Mar 2014, at 12:56am, Andrew Arnott wrote:
> When I upgraded from the SQLite for WinPhone8 SDK v3.8.1 to 3.8.3.1, the
> VACUUM statement quit working. Any idea why?
What does it do instead of work ?
Simon.
___
sqlite-users mailing list
sqlite-u
When I upgraded from the SQLite for WinPhone8 SDK v3.8.1 to 3.8.3.1, the
VACUUM statement quit working. Any idea why?
I'd be quite happy to 'rollback' to 3.8.1, but I can't find a way to
download prior versions of the SDK.
Thanks.
--
Andrew Arnott
"I [may] not agree with what you have to say, bu
I built-in an extension which defines all the standard math functions as SQL
functions.
>-Original Message-
>From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
>boun...@sqlite.org] On Behalf Of big stone
>Sent: Monday, 10 March, 2014 13:22
>To: sqlite-users@sqlite.org
>Subject:
On Mon, Mar 10, 2014 at 6:25 PM, Sandu Buraga wrote:
> Hi,
>
> I am using WAL to read/write into a database from a single process with
> several threads. For performance reasons, along with the HDD database file,
> I am attaching an in memory db for storing temporary information. Each
> thread has
Hi,
I am using WAL to read/write into a database from a single process with
several threads. For performance reasons, along with the HDD database file,
I am attaching an in memory db for storing temporary information. Each
thread has it own handle. My question is: once attached the in memory db
wi
Hi,
On Mon, Mar 10, 2014 at 6:37 PM, Dan Kennedy wrote:
> On 03/10/2014 06:49 PM, St. B. wrote:
>
>> Hi,
>>
>> I posted this question last year, but did not get any feed back. Is this
>> something that can be handled on the ML, or should I ask in another place?
>>
>> Regards,
>>
>> -- F
Hello Keith,
Thanks for the ".timer on" tip.
I only succeed to get a "Error: not such function : sqrt" from default
Sqlite.exe
How did you get that "native" sqrt working ?
regards,
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.or
On 03/10/2014 06:49 PM, St. B. wrote:
Hi,
I posted this question last year, but did not get any feed back. Is this
something that can be handled on the ML, or should I ask in another place?
Regards,
-- Forwarded message --
From: St. B.
Date: Sun, Jan 6, 2013 at 11:45 PM
Subjec
On Mon, Mar 10, 2014 at 1:06 PM, Michele Pradella <
michele.prade...@selea.com> wrote:
> Compiling on Windows 32bit VS2010
> Line 73595
> static const int iLn = __LINE__+4;
> give an error: "error C2099: initializer is not a constant"
>
This is a case of VS2010 not conforming to the C89 standard.
Compiling on Windows 32bit VS2010
Line 73595
static const int iLn = __LINE__+4;
give an error: "error C2099: initializer is not a constant"
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Mon, Mar 10, 2014 at 10:06 AM, techi eth wrote:
> Any hint will help me to identify root cause of leak.
>
Statically link against SQLite. Compile with -g. Use the
--leak-check=full option to valgrind.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite
Any hint will help me to identify root cause of leak.
Thanks
On Mon, Mar 10, 2014 at 2:58 PM, techi eth wrote:
> Hi,
>
> I come across memory leak with sqlite3 online backup api (Leak detected by
> valgrind tool). I have used reference code from below link for test.
> (Online backup for runnin
On 10 Mar 2014, at 12:58pm, Adam Devita wrote:
> Are the databases designed to allow you to perform such an operation easily?
>
> On the databases I do it with, I have designed in enough extra data in the
> db and logic in my code to handle sorting out what to do (which record to
> use) if both
Are the databases designed to allow you to perform such an operation easily?
On the databases I do it with, I have designed in enough extra data in the
db and logic in my code to handle sorting out what to do (which record to
use) if both databases have different data with the same primary key.
r
On 09 Mar 2014 at 22:48, Igor Tandetnik wrote:
> On 3/9/2014 6:37 PM, Tim Streater wrote:
>> Dammit, I looked up and down for 'strlen' and passed over 'length'! I had
>> been thinking about:
>>
>>update mytable set path='/path/from/' || substr(path, length('/path/to/')
>> + 1)
>>where pa
On 10 Mar 2014, at 12:58pm, Muhammad Bashir Al-Noimi wrote:
> May I get some help from you guys?
If you're asking how to synchronise two SQL databases which may have had
different commands executed on them, then you should know that this is an
unsolved problem which involves many difficult qu
On Mon, Mar 10, 2014 at 1:58 PM, Muhammad Bashir Al-Noimi
wrote:
> On 03/07/2014 08:28 PM, Muhammad Bashir Al-Noimi wrote:
>> I've two identical sqlite databases from structure side. I want to make a
>> synchronization for the data but I need to keep some tables away from the
>> synchronization pr
On 10 Mar 2014, at 11:57am, Stephan Beal wrote:
> The remaining questions:
>
> - How are view selects handled differently than table selects?
> - If so, then what is the reasoning behind it?
>
> This is not explained, but it's quite possibly that way so that the
> implementation has some leewa
On 03/07/2014 08:28 PM, Muhammad Bashir Al-Noimi wrote:
Howdy,
I've two identical sqlite databases from structure side. I want to
make a synchronization for the data but I need to keep some tables
away from the synchronization process.
Is there any library can do that OR I've to do it
On Mon, Mar 10, 2014 at 12:52 PM, Dariusz Wawer wrote:
> yes, that is what is written in the documentation at
> https://www.sqlite.org/c3ref/column_name.html and it is what I have read
> first when trying to find an answer. It provides a solution, but it does
> not answer the question.
It answer
W dniu 2014-03-10 12:27, Stephan Beal pisze:
On Mon, Mar 10, 2014 at 11:53 AM, Dariusz Wawer wrote:
When I obtain the column name through sqlite3_column_name() I get
different results for query on view (ALIAS.COLUMN) than for query on table
(COLUMN). The alias is included in column name for vie
Hi,
I posted this question last year, but did not get any feed back. Is this
something that can be handled on the ML, or should I ask in another place?
Regards,
-- Forwarded message --
From: St. B.
Date: Sun, Jan 6, 2013 at 11:45 PM
Subject: Exception when querying a range index
On Mon, Mar 10, 2014 at 11:53 AM, Dariusz Wawer wrote:
> When I obtain the column name through sqlite3_column_name() I get
> different results for query on view (ALIAS.COLUMN) than for query on table
> (COLUMN). The alias is included in column name for view query but not in
> table query, even tho
I am confused about the difference of handling table and view selects by
sqlite.. I have the following view query:
SELECT
TLP.name, TLP.jar_file, TLP.log_file, ...
FROM
tasks_list_page TLP
and a table query:
SELECT
TSK.name, TSK.jar_file, TSK.log_file, ...
FROM
task TSK
When I ob
Have any of you kind folks a recent 3.8.3 (or newer) 64-bit DLL for SQLite3
perhaps?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hi,
I come across memory leak with sqlite3 online backup api (Leak detected by
valgrind tool). I have used reference code from below link for test.
(Online backup for running database)
http://www.sqlite.org/backup.html
Please find below memory leak snapshot for reference.
==6084== 78,688 (880 d
Many CTE queries are just some mini-algorithms with iteration and only
last row is required. I just wondered whether it's easy to do this
without "order by ... " of the outer query (also mentioned in my reply
about CTE sqrt). There's a solution, but the good news is that
probably one rarely needs s
Muhammad wrote:
| ... two identical sqlite databases from structure side. I want to make a
synchronization for the data ...
| Is there any library can do that OR I've to do it by myself?
With an Apple you can do it within SQLite itself.
http://www.sqlite.org/pragma.html#pragma_fullfsync
To do
34 matches
Mail list logo