Simon, I liked your method of attack with the 2 tables. :)
On Nov 22, 2012 6:59 AM, "Simon Slavin" wrote:
>
> On 22 Nov 2012, at 10:47am, Bart Smissaert
> wrote:
>
> > Ignore this e-mail, it was a simple mistake from my side and nil to do
> > with SQLite.
>
> It takes a big man to admit a mistak
Sorry I should have added that I converted the project to VS 2010.
--- On Wed, 5/11/11, Kit Pat wrote:
From: Kit Pat
Subject: [sqlite] VS2010 Issue
To: sqlite-users@sqlite.org
Date: Wednesday, May 11, 2011, 12:56 PM
Any help or direction is appreciated. I have a VS 2005 application using
Any help or direction is appreciated. I have a VS 2005 application using
SQLite 1.0.66.0 and Net Framework 2.0. I'm trying to take the applicaiton to a
Windows 7 64 bit machine but not sure what I need to do to convert SQLite to
use Net Framework 4. Is this even possible and how?
The public C API is well-documented here:
http://www.sqlite.org/capi3.html
There may be other documentation of the internals, but I'd imagine the
public API will get you pretty far.
Pat
-Original Message-
From: Cesar Rodas [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 13, 2
versioned DLL could post a patch to the build
and propose having it added to the distribution.
Pat
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: Monday, December 11, 2006 12:12 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] windows dll
I agree wi
h for database changes
without polling.
Pat
-Original Message-
From: Roberto [mailto:[EMAIL PROTECTED]
Sent: Friday, December 08, 2006 4:23 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] about call back of sqlite.
On 08/12/06, hongsion <[EMAIL PROTECTED]> wrote:
> Hi sqlit
documented here:
http://www.sqlite.org/capi3ref.html
Pat
-Original Message-
From: Keiichi McGuire [mailto:[EMAIL PROTECTED]
Sent: Friday, July 28, 2006 3:36 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] outputting select in cpp file?
This sounds like a very simple problem, but I cannot
users querying it from web
browsers). There is a race condition that begins with the test for file
existence and ends with the creation of the database table based on that
condition.
Pat
-Original Message-
From: greenshire [mailto:[EMAIL PROTECTED]
Sent: Friday, July 21, 2006 7:55 PM
u are on a platform
that has Unicode strings available to you, you can go straight from those
Unicode strings to the sqlite3_*16 functions without conversion.
Pat
-Original Message-
From: Pedro J. Vivancos [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 13, 2006 12:19 AM
To: sqlite-
:
-DSQLITE_DEFAULT_FILE_FORMAT=1
Alternatively, you could get the source and build a compatible sqlite
client.
Pat
-Original Message-
From: Hartwig Wiesmann [mailto:[EMAIL PROTECTED]
Sent: Sunday, July 09, 2006 3:25 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] sqlite3 on MacOSX
Hello!
I have created a
d somewhere, I can reverse engineer
configure/make, but I was hoping that someone here might have the
answers.
Thanks again!
Pat
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: Monday, July 03, 2006 10:04 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] endian-spe
build using visual
studio and I'd like to use the same sources if possible to avoid
confusion.
Pat
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: Monday, July 03, 2006 9:24 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] endian-specific code in pur
n oracle, or STR() in MSSQL), but it looks like there is not.
SQLite is intentinonally sparse in the included functions, so you can
either write or find a custom sqlite function to do this.
Alternatively, simply use whatever number->string conversion routines
the language/platform you are us
rs? I ask this because I know that this
release is "provided as a service to MS-Windows users who lack the build
support infrastructure of Unix."
Thanks!
Pat
f you
use the right query, but it may access the disk, and it may interfere
with OS power management.
Pat
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 29, 2006 6:50 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] real time gui updates
In that
for cases where you'd like consistent reads
across multiple statements without using a BEGIN IMMEDIATE and locking
other threads doing the same out.
Pat
-Original Message-
From: A. Pagaltzis [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 07, 2006 7:01 PM
To: sqlite-users@sqlite.
ATE. For transactions where I know that I'm only
reading (select), I simply do BEGIN and let the database escalate to
SHARED.
It's entirely possible I'm reading these docs incorrectly, but this
strategy has worked quite well for me.
Pat
-Original Message-
From: A. Pagaltz
run frequently, or take a long time, you may want to consider simply
using BEGIN on these (or for single statement reads, you could leave the
transaction wrapping out altogether).
Pat
-Original Message-
From: Jiri Hajek [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 07, 2006 11:33 AM
te] BEGIN and Backup [was [sqlite] Problems with multiple
threads?]"
Discusses a similar issue.
Pat
-Original Message-
From: Jiri Hajek [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 07, 2006 9:26 AM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Problems with multiple threads?
You can use BEGIN IMMEDIATE or BEGIN EXCLUSIVE depending on the type of
lock you'd like.
SQLite BEGIN syntax:
http://sqlite.org/lang_transaction.html
SQLite locks:
http://sqlite.org/lockingv3.html
SQLite Busy Handler:
http://sqlite.org/capi3ref.html#sqlite3_busy_handler
Pat
-Ori
mine,
not SQLite when I see this issue.
Pat
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 06, 2006 6:36 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Problems with multiple threads?
Bill KING <[EMAIL PROTECTED]> wrote:
> Could t
This sounded fun, so I thought I'd give it a try. Here's a sample
pulling schema and data from an on-disk to an in-memory database in c.
I've omitted error handling and debug output to make it shorter.
int process_ddl_row(void * pData, int nColumns,
char **values, char **columns);
int
a finally block. In c++, I do it using a stack based destructor
guard.
Pat
-Original Message-
From: Florian Weimer [mailto:[EMAIL PROTECTED]
Sent: Friday, June 02, 2006 9:19 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Multithreading. Again.
> As long as no prepared s
elow. I'm glad to hear that it
really is fixed. Is this a "documentation bug" leftover from previous
versions?
Thanks!
Pat
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 01, 2006 8:38 AM
To: sqlite-users@sqlite.org; [EMA
I'm periodically seeing sqlite3_exec return SQLITE_CANTOPEN.
Unfortunately, I haven't boiled this down to a simple sample that I can
send to this list, but I thought I'd check to see if there is a known
solution before I dive too deep. I'm using sqlite version 3.2.7 on
window
t some point within
the transaction, I'd like to force an escalation to EXCLUSIVE, forcing
all SHARED and other locks to clear before continuing.
Is there a way to do this?
Thanks!
Pat
26 matches
Mail list logo