While one of the databases is under a lengthy writing process, I
don't want other databases to be locked by the BEGIN
TRANSACTION...COMMIT lock.
Is this possible? Thanks.
___
sqlite-users mailing list
sqlite-users@sqlite.org
Try NEW.table1.type and NEW.table2.type
This works with my old 3.6 version but not on 3.7.8
I still get : Error: no such column: NEW.table1.type
___
sqlite-users mailing list
sqlite-users@sqlite.org
You haven't given the view explicit column names
How ?
try this instead:
CREATE VIEW my_view AS SELECT table1.type as table1_type, table2.type
as table2_type FROM
Yes this works on latest version. But I wonder why the other syntax is
not accepted anymore. Because I'll have to rewrite my
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
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
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
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 =. The
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, the
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
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.
How
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
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
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
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 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 * FROM mytable
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 setup is
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
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
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
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
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
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
On Wed, Oct 26, 2011 at 5:01 PM, Jay A. Kreibich j...@kreibi.ch 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
23 matches
Mail list logo