Re: [sqlite] Need Help! -- SQlite database on server

2011-08-04 Thread Tim Butterfield
On Thu, Aug 4, 2011 at 12:52 PM, Stephan Beal wrote: > On Thu, Aug 4, 2011 at 7:50 PM, Stephan Beal wrote: > >> http://www.sqlite.org/whentouse.html >> > > Specifically: 2nd section, 1st list item. It may depend on the usage. After reading about the possible issues, I have just implemented some

Re: [sqlite] How to install and configure SQLite on ipad.

2011-05-17 Thread Tim Butterfield
iOS has SQLite embedded in it. Add the libsqlite3.dylib framework toyour Xcode project. This is a /usr/lib alias, not the specific version of libsqlite3.0.dylib. Include your SQLite db file in your Xcode project for copying to the target or let it get created when you open it. #import in your

Re: [sqlite] System.Data.SQLite Status

2011-05-13 Thread Tim Butterfield
On Fri, May 13, 2011 at 7:51 AM, Shane Harrelson wrote: > The bundled readme, as well as the features page, have an update in red, > describing > the decision we made to ship the SDS DLL and the Interop DLL separately for > all platforms: > > "Currently all versions provided as System.Data.SQLite.

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

2011-05-06 Thread Tim Butterfield
Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Tim Butterfield > Sent: Friday, May 06, 2011 9:31 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] System.Data.SQLite blob column excepti

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

2011-05-06 Thread Tim Butterfield
oun...@sqlite.org] On Behalf Of Tim Butterfield > Sent: Friday, May 06, 2011 8:58 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] System.Data.SQLite blob column exception > > On Fri, May 6, 2011 at 7:44 AM, Simon Slavin wrote: >> >> On 6 May 2011, a

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

2011-05-06 Thread Tim Butterfield
On Fri, May 6, 2011 at 7:44 AM, Simon Slavin wrote: > > On 6 May 2011, at 3:43am, Tim Butterfield wrote: > >> The blob values are always inserted and read as a byte[].  If those >> bytes are those of a text file, it fails.  If I add a leading 0x00 >> byte to forc

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

2011-05-05 Thread Tim Butterfield
On Thu, May 5, 2011 at 7:16 PM, Simon Slavin wrote: > > On 6 May 2011, at 12:17am, Tim Butterfield wrote: > >> Since my blob column can >> contain either text or binary file data, both cases are valid.  Does >> VerifyType need to add a valid DbType.Binary for case

[sqlite] System.Data.SQLite blob column exception

2011-05-05 Thread Tim Butterfield
. case TypeAffinity.Text: ... if (type == DbType.Binary) return affinity; break; ... } throw new InvalidCastException(String.Format("Unexpected DbType: {0} for Affinity: {1}", typ, affinity); -- Tim Butterfield http://www.timbutte