On Wed, Oct 26, 2011 at 5:01 PM, Jay A. Kreibich wrote:
> The use of IS is causing the query optimizer to use a full table
> scan, essentially turning the query into a O(n) operation. This has
> to do with how IS differs from = in the handling of NULLs. Since it
> is possible bind a NULL to
On 10/26/2011 9:49 PM, G. J. Weinberger wrote:
Please remove me from mailing list. One kind person helped me; as for the rest,
the issues discussed are way over my head.
Every message you get from the list displays a link at the bottom where
you can go to edit your membership. Here it is agai
Please remove me from mailing list. One kind person helped me; as for the rest,
the issues discussed are way over my head.
Cordially,
GJW
G. J. Weinberger
9 Mulberry Lane
Farmington, CT 06032
USA
___
sqlite-users mailing list
sqlite-users@sqlite.org
h
Oh, that *is* funny.
Peter
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Jean-Christophe Deschamps
> Sent: Wednesday, October 26, 2011 6:12 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Error
Funny coincidence in time, I just posted on the same subject while your
post was being received!
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Dear list,
It seems that after sqlite3_prepare_v2() and sqlite3_step() we have
that sqlite3_errcode() returns meaningful result right away when some
function invokes sqlite3_result_error() during sqlite3_step(). OK so far.
The issue is with sqlite3_errmsg(). If a function post an ad-hoc
m
This may be a known thing, but I can't find anything on it on-line. I finally
figured out a solution by examining the code to shell.c.
OK, I have a user-defined function in an extension that calls
sqlite3_result_error() when an out-of-bounds argument is passed in. I called
sqlite3_prepare16_v
On Wed, Oct 26, 2011 at 11:35:33PM +0200, Tobias Mohrl?der scratched on the
wall:
> On Wednesday, Oct 26, 2011 at 02:26PM Jay A. Kreibich wrote:
>
> > On Tue, Oct 25, 2011 at 11:51:46PM +0200, Tobias Mohrl?der scratched on the
> > wall:
> >> Hello everybody,
> >>
> >> I strongly believe that my
On Wednesday, Oct 26, 2011 at 02:26PM Jay A. Kreibich wrote:
> On Tue, Oct 25, 2011 at 11:51:46PM +0200, Tobias Mohrlüder scratched on the
> wall:
>> Hello everybody,
>>
>> I strongly believe that my setup is somehow wrong, I just can't figure
>> out how.
>
>
>> sqlite3_prepare_v2(db, "SELECT
Here are the opcodes generated for each operation using the EXPLAIN command
sqlite> explain select offsets(pasta_text), DataPasta from pasta_text where
past
a_text match 'andamento*';
addr opcode p1p2p3p4 p5 comment
-
On 26 Oct 2011, at 7:05pm, G. J. Weinberger wrote:
> Can anyone out there help me?
The instructions you quoted are fairly clear. Do you understand what
~/Library/Application Support/GarageSale/garagesale.sqlite
means ? '~' means your home folder. Then inside that folder, look for a
folder
Hello.
I use GarageSale as my ebay listing tool.
Suddenly, I am unable to post, duplicate templates etc., getting this message
(screen shot):
file://localhost/Users/bill/Desktop/Screen%20shot%202011-10-26%20at%2010.01.20%20AM.pngG.
J. Weinberger
Garage sale has only sent me this message re some
Not sure what is causing the problem..and thus my suggestion(s) can be
labelled as trial and error ---
1. Check the target platform (try with x64 if it is 'any cpu').
Thanks & Regards
Taleeb Anwar
*Ghurbat men Hon Agar Hum, Rehta Hai Dil "Chicken" men!!*
On Wed, Oct 26, 2011 at 11:09 PM, J Tr
J Trahair wrote:
>
> Works on my development 64bit machine, not on the customer's 64bit.
>
The most likely cause for it working on your development machine and not on
your
customer's machine is that you have the Microsoft Visual C++ 2010 Runtime
Library
installed and your customer does not.
>
>
HI.
There's no SQLite.Interop.dll, anywhere.
I downloaded sqlite-netFx40-setup-bundle-x64-2010-1.0.76.0.exe which gave me
System.Data.SQLite.dll.
Works on my development 64bit machine, not on the customer's 64bit.
How do I get the interop?
Thank you.
Jonathan Trahair
- Original Messag
J Trahair wrote:
>
> However, I have installed the same installation setup.exe on a separate
Windows
> 64bit computer, and it comes up with the error message 'Could not load
file or
> assembly System.Data.SQLite.dll or one of its dependencies, the specified
module
> could not be found.' However,
On Tue, Oct 25, 2011 at 11:51:46PM +0200, Tobias Mohrlüder scratched on the
wall:
> Hello everybody,
>
> I strongly believe that my setup is somehow wrong, I just can't figure
> out how.
> sqlite3_prepare_v2(db, "SELECT * FROM mytable WHERE MyKey IS ?", -1, &stmt,
> 0);
Don't use "IS", use
Hi.
I want to install a VB.Net application onto a customer's Windows 64bit computer.
I have my own Windows 64bit laptop with Visual Studio 2010 installed. I have a
VB.Net application which uses SQLite successfully, both in the development
runtime, and as an 'installed' program in a separate fol
Hello everybody,
I'm currently experimenting with SQLite (3.7.8) and am a complete newbie in the
field of SQL databases.
Running performance comparisons between a C++ std::map< int, std::string > and
an in-memory SQLite database, I found SQLite to be astonishingly slow when
selecting single ro
Well, if the statements within your BEGIN TRANSACTION ... COMMIT only really
affects one database (hereafter called the main database) only that database
should be locked.
If you experience otherwise, it could be because:
1. The locking_mode for the databases has been set to EXCLUSIVE (see
http://
20 matches
Mail list logo