Re: [sqlite] SQLite Linq not being loaded

2013-09-12 Thread Steve Palmer
e;")); > > > And that’s it! Now you should be able to write Linq queries against your > Sqlite database just like you would with a Sql Server database." > > > -- > -- > -- > --Ô¿Ô-- > K e V i N > > > On Mon, Sep 9, 2013 at

Re: [sqlite] SQLite Linq not being loaded

2013-09-09 Thread Steve Palmer
ember 2013 12:00, Kevin Benson wrote: > On Sun, Sep 8, 2013 at 2:36 AM, Steve Palmer wrote: > > > Hi! > > > > Has anybody successfully used System.Data.SQLite.Linq in their project > and > > can perhaps help me with this? > > > > Even after including

Re: [sqlite] SQLite Linq not being loaded

2013-09-09 Thread Steve Palmer
a different C# sqlite wrapper with Linq support that actually does work, so I'm switching to that. On 8 September 2013 07:36, Steve Palmer wrote: > Hi! > > Has anybody successfully used System.Data.SQLite.Linq in their project and > can perhaps help me with this? > > Even af

[sqlite] SQLite Linq not being loaded

2013-09-07 Thread Steve Palmer
Hi! Has anybody successfully used System.Data.SQLite.Linq in their project and can perhaps help me with this? Even after including this DLL in my project reference, it is apparent that Linq is calling the wrong provider when building the appropriate SQL statements. It is throwing an exception in

[sqlite] Sqlite corruption

2007-11-19 Thread Steve Palmer
Some of our users have been reporting corruption in their SQLite database. Running pragma-integrity check on the database yields the following results: Guinevere:corrupted-messages Steve$ sqlite3 messages.db SQLite version 3.4.0 Enter ".help" for instructions sqlite> pragma integrity-check; SQL err

Re: [sqlite] SQLite 3.2.5 and Mac OSX network folders

2005-10-28 Thread Steve Palmer
ion (i.e., the standard SQLite distribution), which would help combine Apple's changes and the changes from 3.1.3 to 3.2.5. I've never used that feature of Subversion, so I can't offer much more at the moment. Keep us posted, I'm curious to know how this goes for you

Re: [sqlite] SQLite 3.2.5 and Mac OSX network folders

2005-10-28 Thread Steve Palmer
d to set sqlite3_os_trace to 1 in SQLite3/src/ os_common.h Extra_CC_Flags += -DASSERT_VIA_CALLBACK=1 -DENABLE_LOCKING_CALLBACKS=1 HTH, Aaron On Oct 25, 2005, at 12:45 PM, Steve Palmer wrote: What are those reasons and is there any expectation that they can be made available as patches f

Re: [sqlite] SQLite 3.2.5 and Mac OSX network folders

2005-10-25 Thread Steve Palmer
find. - Steve On Oct 25, 2005, at 4:57am, [EMAIL PROTECTED] wrote: Steve Palmer <[EMAIL PROTECTED]> wrote: I'm currently investigating a problem with my application, SQLite 3.2.5 and a database located on a Mac OSX Server network share that does not seem to repro with the SQLite

[sqlite] SQLite 3.2.5 and Mac OSX network folders

2005-10-24 Thread Steve Palmer
I'm currently investigating a problem with my application, SQLite 3.2.5 and a database located on a Mac OSX Server network share that does not seem to repro with the SQLite 3.1.3 that ships with Mac OSX 4.1. Specifically if I place a SQLite database file on a folder on a remote network shar

[sqlite] Mailing list problem

2004-08-06 Thread Steve Palmer
According to the instructions at http://www.sqlite.org/support.html... "For additional information about operating and using this mailing list, send a message to [EMAIL PROTECTED] and instructions will be sent by to you by return email." This doesn't seem to be working. I've tried twice. - Steve

Re: [sqlite] the 2.8 database ananysis tool

2004-06-18 Thread Steve Palmer
I see versions of this for Linux and Windows, but not for Mac OSX. Are the sources going to be made available so that we can build for our platform? On Jun 17, 2004, at 11:41pm, Darren Duncan wrote: At 7:15 AM -0400 6/17/04, D. Richard Hipp wrote: Also tomorrow, I will be making available a dat

Re: [sqlite] row size limit

2004-04-18 Thread Steve Palmer
That info is actually incorrect. WinFS is still scheduled for Longhorn. The tech media misinterpreted something. On Apr 18, 2004, at 8:31 PM, Greg Miller wrote: Greg Obleshchuk wrote: I know the MS is looking at replacing the file system with the SQL engine in Longhorn so they must have solved

[sqlite] Getting max column on empty table

2004-03-17 Thread Steve Palmer
If I have a table that is empty and I want to compute an incrementing value in a non-unique column (I cannot use integer primary key since the column value won't be unique): (select max(c) from t where n=20)+1 where c is unique only within (n==20), then this works as long as the table has at l

Re: [sqlite] Checking for read-only

2004-03-10 Thread Steve Palmer
Thanks! I'll grab the next version when it comes out and try again. On Mar 10, 2004, at 5:44 AM, D. Richard Hipp wrote: Steve Palmer wrote: Hmm... I don't get an error when I execute that statement (substituting appropriate table name and also field name) against a r/o database. Sp

Re: [sqlite] Checking for read-only

2004-03-09 Thread Steve Palmer
readonly database sqlite> update info set version=1 where 0; sqlite> What am I missing? My platform is Mac OSX 10.3 and I'm using the libsqlite.a library. Thanks for the explanation of how read-only works though! On Mar 9, 2004, at 3:02 PM, D. Richard Hipp wrote: Steve Palmer wrote: &g

Re: [sqlite] Checking for read-only

2004-03-09 Thread Steve Palmer
readonly database sqlite> update info set version=1 where 0; sqlite> What am I missing? Thanks for the explanation of how read-only works though! On Mar 9, 2004, at 3:02 PM, D. Richard Hipp wrote: Steve Palmer wrote: > I was going by the comment at http://www.sqlite.org/c_interface.html whi

Re: [sqlite] Checking for read-only

2004-03-09 Thread Steve Palmer
sume that since one of the error codes is SQLITE_READONLY then it is probably accurate. In which case an extra function that returns the state of the read-only flag would be nice. On Tuesday, March 09, 2004, at 11:22AM, Peter <[EMAIL PROTECTED]> wrote: >Steve Palmer wrote: >> I

[sqlite] Checking for read-only

2004-03-09 Thread Steve Palmer
Is there an easy way I can open a database via sqlite_open and then find out if sqlite has opened it in read-only mode without first needing to do any sort of modification and get an error code? I want to adjust the UI in my application to disable certain functionality if the database is read-on

Re: [sqlite] Contains

2004-02-20 Thread Steve Palmer
Thanks Kurt and Derrell. I'm sorted now! On Feb 20, 2004, at 5:16 PM, Kurt Welgehausen wrote: like '%%' That's not the only way, but it's the std SQL way. Regards - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional comm

[sqlite] Contains

2004-02-20 Thread Steve Palmer
I'm probably missing something fundamental but it's late and my brain is fried so please bear with me. How do I select rows where a column contains some text as opposed to matching the text exactly? Thanks! - To unsubscribe, e