Re: [sqlite] System.Data.SQLite blob column exception

2011-05-06 Thread Robert Simpson
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 <sqlite_l...@bcsft.com> wrote: > How are you fetching the data?  Are you using the gener

Re: [sqlite] System.Data.SQLite blob column exception

2011-05-06 Thread Robert Simpson
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:

Re: [sqlite] Sqlite .NET 4.0 provider available?

2011-02-16 Thread Robert Simpson
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.

Re: [sqlite] SQLite 3.7.x for Pocket PC 2003 SDK (VS2005) does not compile

2010-08-25 Thread Robert Simpson
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

Re: [sqlite] Proposed new sqlite3_open_v3() interface

2010-05-03 Thread Robert Simpson
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,

Re: [sqlite] Question on the VdbeCursor structure changes

2010-04-17 Thread Robert Simpson
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

Re: [sqlite] Locking under various Windows versions

2010-04-16 Thread Robert Simpson
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

Re: [sqlite] SQLite in C# .NET

2009-11-11 Thread Robert Simpson
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:

Re: [sqlite] low-level view of data values?

2009-10-12 Thread Robert Simpson
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:

Re: [sqlite] SQLite Encryption Extensions(SEE) for SQLite

2009-10-03 Thread Robert Simpson
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

Re: [sqlite] Code problem

2009-09-20 Thread Robert Simpson
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:

Re: [sqlite] How secure is encrypted sqlite database

2009-07-28 Thread Robert Simpson
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

Re: [sqlite] Repost: Accessing a DB while copying it causes Windows to eat virtual memory

2009-07-08 Thread Robert Simpson
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

Re: [sqlite] ATTACH Database

2009-06-30 Thread Robert Simpson
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

Re: [sqlite] Two simple questions

2009-06-24 Thread Robert Simpson
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

Re: [sqlite] sqlite Exception System.InvalidCastException: Specified cast is not valid.

2009-06-17 Thread Robert Simpson
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- From

Re: [sqlite] SPAM: SQLLite support for Silverlight

2009-03-05 Thread Robert Simpson
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:

Re: [sqlite] SPAM: Database path in widows

2009-02-17 Thread Robert Simpson
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

Re: [sqlite] SPAM: Re: Question on missing Entry Point for Sqlite 3

2009-02-10 Thread Robert Simpson
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

Re: [sqlite] SPAM: Re: Question on missing Entry Point for Sqlite 3

2009-02-10 Thread Robert Simpson
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

Re: [sqlite] SPAM: Re: How to create a Datatable [first steps of newbie]

2009-01-11 Thread Robert Simpson
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

Re: [sqlite] SPAM: sqlite3_open16 fails on Windows Vista 64b

2008-11-25 Thread Robert Simpson
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

Re: [sqlite] OLE DB provider for SQLite

2008-11-17 Thread Robert Simpson
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

Re: [sqlite] Trouble with Visual Studio Express

2008-11-02 Thread Robert Simpson
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:

Re: [sqlite] Visual Basic Programming to SQlite

2008-10-03 Thread Robert Simpson
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

Re: [sqlite] Does sqlite caches data to speed up transaction

2008-09-29 Thread Robert Simpson
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

Re: [sqlite] Issue when enabling fts3 in sqlite3

2008-09-27 Thread Robert Simpson
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

Re: [sqlite] Crazy performance difference between Mac and Windows

2008-09-23 Thread Robert Simpson
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

Re: [sqlite] Vista frustrations

2008-09-18 Thread Robert Simpson
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 Discussion of SQLite Database

Re: [sqlite] Program is crashed on sqlite3_finalize(pStmt);

2008-09-18 Thread Robert Simpson
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()

Re: [sqlite] Vista frustrations

2008-09-17 Thread Robert Simpson
-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 already been proven that &g

Re: [sqlite] Vista frustrations

2008-09-17 Thread Robert Simpson
: [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 purpose of a ca

Re: [sqlite] Vista frustrations

2008-09-17 Thread Robert Simpson
] [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: > Robert Simpson wrote: > &

Re: [sqlite] Vista frustrations

2008-09-17 Thread Robert Simpson
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

Re: [sqlite] Vista frustrations

2008-09-17 Thread Robert Simpson
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 doing sequ

Re: [sqlite] Vista frustrations

2008-09-17 Thread Robert Simpson
:[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

[sqlite] Vista frustrations

2008-09-16 Thread Robert Simpson
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

Re: [sqlite] SQLite 3.6.1 memory leak?

2008-08-30 Thread Robert Simpson
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,

Re: [sqlite] Correct SQL name resolution on AS clauses in a SELECT?

2008-08-19 Thread Robert Simpson
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

Re: [sqlite] SPAM: Correct SQL name resolution on AS clauses in a SELECT?

2008-08-19 Thread Robert Simpson
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,

Re: [sqlite] "Database is Locked"

2008-08-19 Thread Robert Simpson
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

[sqlite] ANN: SQLite ADO.NET Provider 1.0.56.0

2008-08-11 Thread Robert Simpson
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

Re: [sqlite] c# .net beginTrans...where is endtrans?

2008-08-08 Thread Robert Simpson
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

Re: [sqlite] SPAM: Proposed removal of (mis-)feature

2008-08-07 Thread Robert Simpson
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

Re: [sqlite] Realtime backup of database

2008-08-06 Thread Robert Simpson
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

Re: [sqlite] Resources for newbies.

2008-08-02 Thread Robert Simpson
tx05A 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? > > -Original Message- >

Re: [sqlite] Resources for newbies.

2008-08-02 Thread Robert Simpson
ome 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 select > > > statement >

Re: [sqlite] Resources for newbies.

2008-08-02 Thread Robert Simpson
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

Re: [sqlite] More on ICU extension (windows)

2008-08-01 Thread Robert Simpson
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

[sqlite] Shared cache question

2008-07-30 Thread Robert Simpson
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

Re: [sqlite] Return a rowset from function?

2008-07-25 Thread Robert Simpson
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

Re: [sqlite] User-defined collation UNIQUE INDEX

2008-07-20 Thread Robert Simpson
on 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 COLLATE path); > > Robert > > &

Re: [sqlite] User-defined collation UNIQUE INDEX

2008-07-20 Thread Robert Simpson
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

Re: [sqlite] ANN: SQLite .NET provider updated

2008-07-16 Thread Robert Simpson
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'" <sqlite-users@sqlite.org> Date: Wednesday, Jul

[sqlite] ANN: SQLite .NET provider updated

2008-07-16 Thread Robert Simpson
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

Re: [sqlite] General help, a bit OT

2008-07-15 Thread Robert Simpson
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

Re: [sqlite] Rigging up SQLite over LINQ (Entity Framework)

2008-07-01 Thread Robert Simpson
] [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 aggregate query test that I'm

[sqlite] Rigging up SQLite over LINQ (Entity Framework)

2008-06-30 Thread Robert Simpson
de 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

Re: [sqlite] Table Adapter Update Question

2008-06-25 Thread Robert Simpson
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

Re: [sqlite] CANTOPEN error on Windows systems running TortoiseSVN

2008-06-04 Thread Robert Simpson
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

Re: [sqlite] .net wrappers - mono vs. phxsoftware

2008-05-28 Thread Robert Simpson
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 Simpson's code (http://www.mono-p

Re: [sqlite] Proposed SQLite C/C++ interface behavior change.

2008-05-14 Thread Robert Simpson
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. However, I ma

Re: [sqlite] Proposed SQLite C/C++ interface behavior change.

2008-05-14 Thread Robert Simpson
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

RE: [sqlite] Is there a difference between NULL und zero byte length BLOB/TEXT?

2008-01-18 Thread Robert Simpson
> -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

[sqlite] RE: Visual Studio (was Improving performance of SQLite)

2007-12-17 Thread Robert Simpson
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

RE: [sqlite] Proposed sqlite3_initialize() interface

2007-10-30 Thread Robert Simpson
> -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

RE: [sqlite] how to get file handle from sqlite3 object?

2007-10-09 Thread Robert Simpson
> -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

RE: [sqlite] SQLite.Net

2007-09-19 Thread Robert Simpson
ichael 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 ? > > > -----Message d'o

RE: [sqlite] SQLite.Net

2007-09-19 Thread Robert Simpson
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'orig

RE: [sqlite] SQLite.Net

2007-09-19 Thread Robert Simpson
> -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- > De : Robert Simpson [mail

RE: [sqlite] SQLite.Net

2007-09-19 Thread Robert Simpson
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

RE: [sqlite] Skype client using SQLite?

2007-08-28 Thread Robert Simpson
> -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

RE: [sqlite] Proposed incompatible change to SQLite

2007-08-09 Thread Robert Simpson
> -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

RE: [sqlite] [VC++ 6] Error compiling VBified source

2007-08-03 Thread Robert Simpson
> -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

RE: [sqlite] How to Speed of Inserts

2007-08-03 Thread Robert Simpson
> -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

RE: [sqlite] Begining SQLite

2007-07-24 Thread Robert Simpson
> -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

RE: [sqlite] Begining SQLite

2007-07-23 Thread Robert Simpson
> -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

RE: [sqlite] Begining SQLite

2007-07-23 Thread Robert Simpson
> -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

RE: [sqlite] SQLite Version 3.4.1

2007-07-23 Thread Robert Simpson
> -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.

RE: [sqlite] sqlite Text fields Vista/ 64 bit/core 2 duo machines

2007-07-20 Thread Robert Simpson
> -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

RE: [sqlite] Does Transaction object roll back automatically on exceptions?

2007-07-16 Thread Robert Simpson
> -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

RE: [sqlite] Introducing... ManagedSQLite

2007-06-26 Thread Robert Simpson
> -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

RE: [sqlite] Trouble compiling with MSVC++ 6.0

2007-06-25 Thread Robert Simpson
> -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

RE: [sqlite] Introducing... ManagedSQLite

2007-06-24 Thread Robert Simpson
> -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

RE: [sqlite] Re: CAST

2007-05-31 Thread Robert Simpson
> -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

RE: [sqlite] Re: CAST

2007-05-29 Thread Robert Simpson
> -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

RE: [sqlite] Re: CAST

2007-05-29 Thread Robert Simpson
> -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

RE: [sqlite] Re: CAST

2007-05-29 Thread Robert Simpson
> -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

RE: [sqlite] Re: CAST

2007-05-28 Thread Robert Simpson
> -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

RE: [sqlite] Re: CAST

2007-05-28 Thread Robert Simpson
> -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

RE: [sqlite] Still getting "Insertion failed because database isfull." errors

2007-04-18 Thread Robert Simpson
> -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

[sqlite] Leading zeros in strings

2007-02-08 Thread Robert Simpson
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);

RE: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

2007-02-07 Thread Robert Simpson
> -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

RE: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

2007-02-07 Thread Robert Simpson
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

RE: [sqlite] sqlite / gac

2007-02-04 Thread Robert Simpson
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 Mess

[sqlite] SQLite in the wild

2007-02-01 Thread Robert Simpson
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 unsubscrib

RE: [sqlite] Re: does select reliably return insert order?

2007-01-21 Thread Robert Simpson
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Sunday, January 21, 2007 2:40 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Re: does select reliably return insert order? > > > > If you use LIMIT/OFFSET without an > > explicit ORDER BY, you are

RE: [sqlite] ETA for SQLite 3.3.9 ?

2006-12-23 Thread Robert Simpson
I've been too busy with the holidays to run any of the changes. I won't be able to do anything with the code until after the 1st. Robert > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Saturday, December 23, 2006 12:40 PM > To: sqlite-users@sqlite.org >

RE: [sqlite] Need a wince test

2006-12-20 Thread Robert Simpson
> -Original Message- > From: Brodie Thiesfield [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 20, 2006 4:43 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Need a wince test > > Robert Simpson wrote: > >> From: Brodie Thiesfield [mailto:[EMA

RE: [sqlite] Need a wince test

2006-12-20 Thread Robert Simpson
> -Original Message- > From: Brodie Thiesfield [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 20, 2006 12:17 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Need a wince test > > Robert, does the patch I provided work as is on Windows CE or not? >

  1   2   3   >