t
the column number, calling reader.GetBytes to get the size of the
data, allocating the byte[], and then calling reader.GetBytes to read
into the buffer.
Tim
On Fri, May 6, 2011 at 11:12 AM, Robert Simpson
wrote:
> How are you fetching the data? Are you using the generic reader[x] on a
>
How are you fetching the data? Are you using the generic reader[x] on a
datareader? Are you using a DataSet/DataTable?
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Tim Butterfield
Sent: Friday, May 06, 2011 8:58 AM
To:
SQLite.NET is being transitioned to sqlite.org ... you'll notice the new
site is http://system.data.sqlite.org -- it's being taken over by the fine
folks at sqlite.org, specifically Shane Harrelson who has the lead on the
project. I've been working with Dr. Hipp and Shane on the transition.
I'll
There have been several posts on this issue just this week, and suggested
workarounds.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joachim Wickman
Sent: Wednesday, August 25, 2010 12:37 AM
To: sqlite-users@sqlite.org
Subjec
My only request would be that you add some kind of flag that allows us to
specify opening the database in UTF-16 mode via this interface.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of D. Richard Hipp
Sent: Monday, May 03, 201
I was using it to get the rowid of a given cursor in a SQLite statement.
Given a table schema like CREATE TABLE foo (A,B)
And an arbitrary select such as SELECT * FROM foo
I was able to return the rowid as a hidden column for the statement. This
included statements with multiple cursors (as a r
WinCE has no lockfile support, so it's fudged on the device by means of a
shared memory block to handle the locking. If you open a SQLite database on
a network share from a CE device, then it will not be able to use the
network share's locking mechanisms. In short, don't do it.
-Original Mes
This has been asked and answered several times in the forums:
http://sqlite.phxsoftware.com/forums
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Matthew Pulis
Sent: Wednesday, November 11, 2009 6:40 AM
To: sqlite-users@sqli
I'm pretty sure I do store them as strings -- SQLite doesn't have a
"decimal" datatype, and "double" doesn't cut the precision mustard for
emulating "decimal".
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Dan Phillips
Sent:
If there were problems, then Dr. H wouldn't sell it ...
The SEE extensions add a couple new API calls, specifically sqlite_key() and
rekey() functions to specify the password (or change the password) for an
encrypted database. Other than that, your code remains the same.
I'm pretty sure the lice
You've got single quotes in the body of your text that need to be doubled:
'Rule 404. Character Evidence not Admissible to
Prove Conduct; Exceptions; Other Crimes(A)
Character evidence generally. Evidence of a person'[<-- right here]s
character .
-Original Message-
From: sqlit
The .NET provider uses RC4 encryption. The entire file is encrypted,
including the metadata. SQLite (the engine) may store unencrypted pages in
its internal cache, but I don't really know for sure.
The bottom line is that nothing is safe from a hacker who has your binaries
and database on his/he
I believe the issue was resolved in this ticket:
http://www.sqlite.org/cvstrac/tktview?tn=3387
You're being bitten by Vista and Win2008's aggressive cacheing of the
database.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of M
What is D2.Table?
Also what is the _fileName referred to in the code?
And finally ... what platform? Mono or Windows? I'm just wondering about
the use of slashes instead of backslashes in the attach filename.
Oh, and http://sqlite.phxsoftware.com is more suited for handling
.Net-related questi
You'll have to call sqlite3_column_name() in a loop to find the named column
returned from a prepared select statement.
As for the default values, to get that information you'll have to execute a
"PRAGMA TABLE_INFO(tablename)" query and examine the 5th column "dflt_value"
for the row matching the
The best place to get answers to .NET-related issues with the
System.Data.SQLite provider is:
http://sqlite.phxsoftware.com
I've got plenty of forums over there so we don't clutter up the list with
wrapper issues unrelated to the engine itself.
Robert Simpson
-Original Message
It can't be done, sorry. There's no support for P/Invoke in Silverlight
(requires full trust). Since SQLite is a native library, there's no way to
use it without p/invoke unless someone took the entire engine and rewrote it
in fully managed code.
-Original Message-
From: sqlite-users-bou
The best place to ask for help is in the forums
http://sqlite.phxsoftware.com
Is the path in your connection string relative or absolute? If you're using
a relative path, check the Environment.CurrentDirectory and make sure its
pointing to the right place. Things such as using an OpenFileDialog
I can't build a native SQLite .so for all flavors of *nix and OSX and
include it in my package -- its just beyond the scope of what I'm trying to
do. For Windows, .NET supports me merging the managed and unmanaged code
into a single mixed-mode assembly. Mono doesn't support this at all, so I
have
I can try and make my System.Data.SQLite provider fail gracefully if this
API function doesn't exist -- but it may not be an error I can catch easily.
.NET tends to link these calls when the class is referenced, and it happens
in a place at runtime that I don't think I can put try/catch blocks arou
Since you're using a relative directory in your connection string (a
filename with no path), make sure your Environment.CurrentDirectory is
pointing to the right place at all times.
For example, if you use an OpenFileDialog or SaveFileDialog, those classes
change the CurrentDirectory. Once your c
This can happen if you're accessing the precompiled sqlite library from a
64-bit application. The binary provided by sqlite.org is 32-bit. A lot of
.NET managed people get tripped by this, since .NET programs are (by
default) compiled as "Any CPU" which means on a 64-bit machine, the .NET
program
Agreed. There may be some scenarios in which the C interface or some
C++/OLEDB interface to SQLite outperforms the ADO.NET provider significantly
-- but in most cases there is only a negligible performance impact that can
only be measured through thousands of iterations.
-Original Message
Yep. VS has a hell of time debugging and stepping through the amalgamated
source. I use the split source for debugging purposes.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Sunday, November 02, 2008 9:00 PM
To: sqlite-users@sq
Depends on what version of VB and what type of data access underpinnings
you're using. If it's ADO.NET, you'll want to use the free open-source
SQLite ADO.NET provider from http://sqlite.phxsoftware.com
Robert
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
This isn't unexpected at all. The overhead of using a database (even SQLite)
is much much higher than seeking to an area of an open file and reading some
bytes out of it.
From: devesh tiwari <[EMAIL PROTECTED]>
Sent: Monday, September 29, 2008 12:15 PM
and don't forget to call sqlite3_close() again after iterating and finalizing
the remaining prepared statements.
From: "SQLite List" <[EMAIL PROTECTED]>
Sent: Saturday, September 27, 2008 9:48 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Issue whe
Looks to me like you've forgotten the biggest performance factor of all ...
starting a transaction before you begin the loop and committing it
afterwards.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Gavin Kistner
Sent: Monday, September 22, 2008 9:45
e] Vista frustrations
Is a sad day when an application program is forced to compensate for pitiful
OS design and performance :-(
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Robert Simpson
Sent: Thursday, September 18, 2008 10:31 AM
To: 'General
You can't. The memory pStmt points to is freed and invalid after the call
to finalize. Worse, that freed memory could've already been reallocated for
some other purpose by the time the call to finalize() returns control to
you.
So your solution is to NULL your pointer after calling finalize() an
After watching Molly Brown's Channel9 videos on the cache manager, I'm
convinced the behavior for SQLite should be to not give the filesystem any
hints about caching and let the cache manager itself figure it out. The
exception being Windows CE, where we can confirm that when this flag is not
set,
ustrations
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Robert Simpson wrote:
> Ideally, at least on non-CE platforms, I'd like see SQLite not give the OS
> any hints about caching. However, I'm not sure what kind of performance
hit
> (if any) that would have on Windows. It's al
ssage-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Roger Binns
Sent: Wednesday, September 17, 2008 2:02 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Vista frustrations
-BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Robert Simpson wrote:
> The purpos
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jay A. Kreibich
Sent: quarta-feira, 17 de setembro de 2008 13:01
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Vista frustrations
On Wed, Sep 17, 2008 at 01:17:51AM -0700, Roger Binns scratched on the wall:
>
It's been reproduced on Vista x64 and x86 OS's. I don't have a pre-SP1
installation to verify if it happens against pre-patched versions.
Getting a database should be easy enough ...
CREATE TABLE FOO(a, b, c, d, e, f);
Then do this about 16 million times or so ... whatever it takes to pump the
BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Robert Simpson wrote:
> To me this seems like an obvious bug in Vista,
Actually I'd argue that it is behaving as designed. Generally
filesystem code will try to detect what is going on under the hood. In
particular if it looks like you are doi
:[EMAIL PROTECTED] On Behalf Of Roger Binns
Sent: Wednesday, September 17, 2008 1:18 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Vista frustrations
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Robert Simpson wrote:
> To me this seems like an obvious bug in Vista,
Actually
I recently had a user of the ADO.NET provider report a problem on Vista.
His database is 5gb, and he's doing a full table scan of 16 million rows.
Yea.
I ran some tests using the command-line sqlite3.exe, and observed that
Windows Vista (SP1) is actually trying to cache the entire 5gb file into
There's not enough information in your post for us to comment -- which is
probably why nobody responded earlier. The unit tests for SQLite create
thousands of connections and run hundreds of thousands of commands without
leaking. So there's a probability that you may be doing something wrong,
yes
Slight change so you can see the order by results more clearly:
(Sql Server 2005)
CREATE TABLE #t1(a int, b int);
INSERT INTO #t1 VALUES(1,6);
INSERT INTO #t1 VALUES(9,5);
SELECT a AS b, b AS a FROM #t1 ORDER BY a;
b a
--- ---
9 5
1 6
SELECT b AS a,
Sql Server 2005:
SELECT a AS b, b AS a FROM #t1 ORDER BY a;
b a
--- ---
1 2
9 8
SELECT b AS a, a AS b FROM #t1 ORDER BY a;
a b
--- ---
2 1
8 9
SELECT a, b AS a FROM #t1 ORDER BY a;
Msg 209, Level 16, Sta
Show and tell time! Lets see some code :)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, August 19, 2008 8:15 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] "Database is Locked"
I haven't changed anyt
Coinciding with Visual Studio 2008 SP1 going RTM today, I've put out a new
version of the SQLite ADO.NET provider. The LINQ bits are fairly solid, but
still officially in beta. Nonetheless, it gains the distinction of being
the very first ADO.NET provider publically released (other than Sql Serve
using (DbTransaction trans = connection.BeginTransaction())
{
// loop goes here
//
// loop ends here
trans.Commit();
}
Best place to get answers to .NET-related SQLite questions (and more) is at
http://sqlite.phxsoftware.com/forums
Robert
-Original Message-
From: [EMAIL PROTECTE
I have never really liked #3 and agree wholeheartedly with its demise.
Removing it in a subsequent release will force all those people using them
for string literals to fix their code -- which isn't a bad idea at all!
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
The new VFS implementation is probably the way to go. If you wrote some
wrapper code around the default VFS, you could capture all the writes that
go to the main db and clone/wirexfer those writes to a 2nd sync file.
Just an idea -- haven't worked with VFS's yet, though I plan on implementing
the
oft.com/EvtMgrRequestx05A
you have all given me more help then i deserve... very appreciative
thanks
On Sat, Aug 2, 2008 at 5:17 PM, Robert Simpson <[EMAIL PROTECTED]>wrote:
> Nothing stands out ... is your callback being called at all? What's it
> look
> like?
>
> -O
m_pdbData, strSql, &Callback, this, &lpszErr );
sqlite3_close( m_pdbData );
(note m_strMotionData are strings -- small values work, and around 64 chars
each the following query fails)
here's the query:
sqlite3_open( m_strFile, &m_pdbData );
sqlite3_exe
you are querying.
>
> Maybe some Windows folks will be able to help you.
>
> >
> >
> > On Sat, Aug 2, 2008 at 3:03 PM, Robert Simpson <[EMAIL PROTECTED]
> >wrote:
> >
> >
> > > Can you give us a download link to the database? Does your sel
Can you give us a download link to the database? Does your select statement
fail in the sqlite3.exe command-line util?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Nelson
Sent: Saturday, August 02, 2008 11:44 AM
To: [EMAIL PROTECTED]; General Dis
I don't think the sqlite3.exe command-line tool converts its input strings
to utf8 before parsing them. I think its because non-Windows platforms have
utf8 console sessions, and Windows consoles use the default Windows
codepage.
So when you're inserting from the console, you're inserting
codepage
What should be the expected behavior of existing connections when
sqlite3_enable_shared_cache() is enabled, and then another database is
ATTACH'ed to the pre-cache-enabled connection?
And further complicate things by saying that the attached database is using
vtables and the original connection
No, but that would be wicked cool and bring stored procs a lot closer to
reality.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Alexey Pechnikov
Sent: Friday, July 25, 2008 11:08 AM
To: General Discussion of SQLite Database
Subject: [sqlite] Return a row
ined collation UNIQUE INDEX
No, assigning collation during index creation makes no difference. I also
tried
REINDEX with no luck.
I am using verison 3.5.9 on a winxp box (forgot to mention that).
csmith
Robert Simpson wrote:
> Does this work?
>
> CREATE UNIQUE INDEX myidx ON test(str
Does this work?
CREATE UNIQUE INDEX myidx ON test(str COLLATE path);
Robert
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of C. Smith
Sent: Sunday, July 20, 2008 9:05 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] User-defined collation UNIQUE INDEX
I
compact framework?
--- On Wed, 7/16/08, Robert Simpson <[EMAIL PROTECTED]> wrote:
From: Robert Simpson <[EMAIL PROTECTED]>
Subject: [sqlite] ANN: SQLite .NET provider updated
To: "'General Discussion of SQLite Database'"
Date: Wednesday, July 16, 2008, 8:22 PM
I
I don't normally announce releases here, but this one's got some great stuff
in it. Those of you using the SQLite ADO.NET provider will want to check
out.
Some highlights in the 52 release:
3.6.0 code merge
Table and View designers - you can now create and design tables and views,
indexes and for
Without causing a rehash of that long-debated topic, I'll say this: As it
relates to SQLite, generally you will get better performance out of an
optimized C application talking to SQLite than you will out of .NET talking
to SQLite.
The difference can be insignificant to a user application however
om: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Robert Simpson
Sent: Monday, June 30, 2008 9:10 PM
To: 'General Discussion of SQLite Database'
Subject: [sqlite] Rigging up SQLite over LINQ (Entity Framework)
Just when I thought I was hitting the home stretch, I came across an
agg
select p;
Aside from this little issue involving aggregates, SQLite is working nicely
with Microsoft's new Entity Framework.
Robert Simpson
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
erations).
http://sqlite.phxsoftware.com
Thanks,
Sam
-
We're Hiring! Seeking passionate Flex, C#, or C++ (RTSP, H264) developer in
the Washington D.C. Contact [EMAIL PROTECTED]
On Wed, Jun 25, 2008 at 8:17 PM, Robert Simpson <[EMAIL PROTECTED]>
wrote:
>
I'm not exactly sure what they've built on top of my (free) provider, but it
looks like a good portion of their core codebase is my code. It's a bummer
they decided to split with the free spirit of SQLite and charge for their
provider (based on my public domain code), but to each his own.
Robert
Sounds like the new journal_mode pragma might be a solution for you.
http://www.sqlite.org/pragma.html#pragma_journal_mode
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Filip Navara
Sent: Wednesday, June 04, 2008 2:54 PM
To: General Discussion of SQLi
ted another poster to the url below, which I was unaware of:
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
I'm currently using the phxsoftware ado.net 2.0 wrapper for sqlite by
Robert Simpson, which is excellent. However, I am surprised to see that
the Mono project recently imported Sim
MAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Robert Simpson
Sent: Wednesday, May 14, 2008 7:58 AM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] Proposed SQLite C/C++ interface behavior change.
I wrote this behavior into the SQLite.NET provider as well. Howeve
I wrote this behavior into the SQLite.NET provider as well. However, I make
a temp copy of the open statements in the db->Vdbe and finalize the copies
so that subsequent calls to sqlite3_finalize() on the original pointer will
not fail, but be a no op.
int ret = sqlite3_close (db);
if (ret =
> -Original Message-
> From: Lothar Scholz [mailto:[EMAIL PROTECTED]
> Sent: Friday, January 18, 2008 3:50 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Is there a difference between NULL und zero
> byte length BLOB/TEXT?
>
> Hello,
>
> The last question for today:
> Is there a d
I was a die-hard Amiga programmer years ago and swore never to put a PC on
my desk at home. Unfortunately they used them at work, so I was forced to
learn it.
After a few years of being a broke enthusiast on the Amiga, I wrote a
business app on the PC in Visual C and VB3. It was my first Windows
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 30, 2007 7:19 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Proposed sqlite3_initialize() interface
>
> As currently implemented, SQLite3 requires no initialization.
> You just start c
> -Original Message-
> From: Cyrus Durgin [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 09, 2007 5:02 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] how to get file handle from sqlite3 object?
>
> i'm wondering if there's a "standard" way to get an open file
> handle from an
>
I'm still testing fixes to these issues, and verifying the last one as I'm
not convinced its an issue with the wrapper. Although I try and reply to
all forum posts in a timely manner, sometimes one or two slip through the
cracks.
Robert
> -Original Message-
> From: Yves Goergen [mailto:
ge-
> From: Michael Martin [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 19, 2007 8:29 AM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] SQLite.Net
>
> Ok, but why I can't use this wrapper
> http://www.phpguru.org/static/SQLite.NET.html ?
>
&g
I am using this http://www.phpguru.org/static/SQLite.NET.html
>
> I have the "attempted to read or write protected memory"
> exception with this wrapper.
>
> If I try to define my own wrapper with sqlite3.dll it crashes
> on select statement.
>
> -Message d'
software.com
Robert
> -Original Message-
> From: Michael Martin [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 19, 2007 7:42 AM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] SQLite.Net
>
> SQLite.NET.2.0.1
>
> -----Message d'origine-
>
What .NET wrapper are you using?
> -Original Message-
> From: Michael Martin [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 19, 2007 7:13 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] SQLite.Net
>
> Hi all,
>
>
>
> I try to use SQLite (sqlite3.dll) in DotNet; this is
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 28, 2007 8:14 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Skype client using SQLite?
>
> In reference to
>
>http://www.sqlite.org/cvstrac/tktview?tn=2592
>
> This is the first p
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 09, 2007 8:38 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Proposed incompatible change to SQLite
>
> We are considering a change to the SQLite API which is
> technically not backward
> -Original Message-
> From: Gilles Ganault [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 03, 2007 11:12 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] [VC++ 6] Error compiling VBified source
>
> At 09:53 03/08/2007 -0700, Joe Wilson wrote:
> >This has come up before on the l
> -Original Message-
> From: Stephen Sutherland [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 03, 2007 10:33 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] How to Speed of Inserts
>
[snip]
>
>So it makes me a bit concerned that when I have to drop my
> XML repository wit
> -Original Message-
> From: Meftah Tayeb [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 24, 2007 3:04 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Begining SQLite
>
> Hello
>
> i create my SQLite Database, but it is blank
> ho to Create my Table, view, Query and procedure ?
> -Original Message-
> From: Meftah Tayeb [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 23, 2007 3:33 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Begining SQLite
>
> Hello
>
> Thank you for this SQLite ADO .Net Data provider
> is working very correctly
> but ho to Create my
> -Original Message-
> From: Meftah Tayeb [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 23, 2007 12:27 PM
> To: sqlite-users@sqlite.org; [EMAIL PROTECTED]
> Subject: [sqlite] Begining SQLite
>
> hello
>
> please help me:
> i am New to SQLITE
> i want to begin Using SQLite with my Enterp
> -Original Message-
> From: Steinmaurer Thomas [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 23, 2007 1:12 AM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] SQLite Version 3.4.1
>
> Hi!
>
> has anybody tried to compile SQLite for the ARM CPU architecture?
>
Yup.
http://sqlite
> -Original Message-
> From: James Forrester [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 20, 2007 6:37 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] sqlite Text fields Vista/ 64 bit/core 2 duo machines
>
> This may be a problem specific to Vista alone, but I'm
> running 64 bit
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 16, 2007 9:14 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Does Transaction object roll back
> automatically on exceptions?
>
> "Ahmed Sulaiman" <[EMAIL PROTECTED]> wrote:
> > Hi all
> -Original Message-
> From: Yves Goergen [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 26, 2007 4:55 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Introducing... ManagedSQLite
>
> On 26.06.2007 00:24 CE(S)T, WHITE, DANIEL wrote:
> > The main advantage of mine is that it is l
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 25, 2007 2:39 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Trouble compiling with MSVC++ 6.0
>
> Ticket #2457 reports difficulty building SQLite version 3.4.0
> using MSVC++ 6.0. This ap
> -Original Message-
> From: WHITE, DANIEL [mailto:[EMAIL PROTECTED]
> Sent: Saturday, June 23, 2007 7:29 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Introducing... ManagedSQLite
>
> Howdy all!
>
> I am just writing tonight to let you know that a project of mine has
> opened up
> -Original Message-
> From: John Stanton [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 31, 2007 4:08 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Re: CAST
>
> You have explained the problem, which is .NET not Sqlite. You have
> apparently done a fine job marrying the two bu
> -Original Message-
> From: John Stanton [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 29, 2007 3:56 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Re: CAST
>
> You are looking for a fit to one particular restrictive, proprietary
> environment. Our approach has been to work wit
> -Original Message-
> From: John Stanton [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 29, 2007 8:40 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Re: CAST
>
> You have just given an excellent explanation of why the wrapper
> approach
> is flawed. Think about it.
Every approa
> -Original Message-
> From: John Stanton [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 29, 2007 6:18 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Re: CAST
>
> Your comments endorse the approach we took which was to avoid the
> wrapper concept entirely with its inherent limitat
> -Original Message-
> From: John Stanton [mailto:[EMAIL PROTECTED]
> Sent: Monday, May 28, 2007 4:21 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Re: CAST
>
> We actually do that with our Sqlite interfaces. We use the declared
> type to specify the type and perform a conversio
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, May 28, 2007 9:11 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Re: CAST
>
>
> > SQLite does not have a dedicated DATE type.
>
> I know that, but why it does't create appropriate column de
> -Original Message-
> From: Christian Schwarz [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 18, 2007 7:25 AM
> To: sqlite-users@sqlite.org
> Subject: AW: [sqlite] Still getting "Insertion failed because database
> isfull." errors
>
> > the database residing on removable media. When
Issued from the 3.3.12 comand-line:
CREATE TABLE blah (ID INTEGER PRIMARY KEY, STUFF string NOT NULL);
INSERT INTO blah (STUFF) VALUES('00302');
SELECT * FROM blah;
1|302
Same query, slightly different table definition:
CREATE TABLE blah (ID INTEGER PRIMARY KEY, STUFF text NOT NULL);
> -Original Message-
> From: Robert Simpson [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 07, 2007 8:25 AM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] Is there a SQLiteSpy-like thing that will let me
> change data from a grid?
>
> __declsp
For the SQLite ADO.NET wrapper, I actually wrote two functions into the core
engine to help me retrieve key information. My requirements were a little
more complex than just getting rowid, but here's what I did to get me that
far at least:
Given a sqlite_stmt pointer consisting of a SELECT on one
http://sqlite.phxsoftware.com is the site where I develop and maintain the
SQLite ADO.NET 2.0 wrapper. The project is 2 years old and is pretty
mature. You'll find the forums pretty informative and I try and answer
every question there fairly quickly.
Robert Simpson
> -Original
imple, and logical user interface developed by working with
experienced first responders
More info can be found here:
http://wiser.nlm.nih.gov/
Robert Simpson
Programmer at Large
http://sqlite.phxsoftware.com
-
To uns
1 - 100 of 275 matches
Mail list logo
