[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

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

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

2005-10-29 Thread Steve Palmer
), 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. Aaron On Oct 28, 2005, at 11:36 AM, Steve Palmer wrote: Has

[sqlite] SQLite Linq not being loaded

2013-09-08 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

Re: [sqlite] SQLite Linq not being loaded

2013-09-09 Thread Steve Palmer
with Linq support that actually does work, so I'm switching to that. On 8 September 2013 07:36, Steve Palmer <swp...@gmail.com> wrote: > Hi! > > Has anybody successfully used System.Data.SQLite.Linq in their project and > can perhaps help me with this? > > Even after

Re: [sqlite] SQLite Linq not being loaded

2013-09-09 Thread Steve Palmer
12:00, Kevin Benson <kevin.m.ben...@gmail.com> wrote: > On Sun, Sep 8, 2013 at 2:36 AM, Steve Palmer <swp...@gmail.com> wrote: > > > Hi! > > > > Has anybody successfully used System.Data.SQLite.Linq in their project > and > > can perhaps help me wit

Re: [sqlite] SQLite Linq not being loaded

2013-09-12 Thread Steve Palmer
e.db;DbLinqProvider=sqlite;")); > > > 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 > > > O

[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,

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

[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

Re: [sqlite] Checking for read-only

2004-03-09 Thread Steve Palmer
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: >> Is the

Re: [sqlite] Checking for read-only

2004-03-09 Thread Steve Palmer
only 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: > I wa

[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

Re: [sqlite] row size limit

2004-04-19 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

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

[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. -