[sqlite] Error code inconsistency

2012-09-03 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The functions sqlite3_status and sqlite3_db_status do substantially the same thing (in different scopes) and have exactly the same signature and semantics. However the error code they return is gratuitously different when provided with a (currently un

Re: [sqlite] sqlite error: file is encrypted or is not a database

2012-09-03 Thread Richard Hipp
On Mon, Sep 3, 2012 at 5:43 PM, Tal Tabakman wrote: > Hi, > my SQLite based app is writing an database(single thread, no concurrency, > on top of NFS , network is involved) > when opening the database for read we get the following error "file is > encrypted or is not a database" when executing a

[sqlite] sqlite error: file is encrypted or is not a database

2012-09-03 Thread Tal Tabakman
Hi, my SQLite based app is writing an database(single thread, no concurrency, on top of NFS , network is involved) when opening the database for read we get the following error "file is encrypted or is not a database" when executing a simple pragma: "PRAGMA cache_size=1;" I would like to note t

Re: [sqlite] How do you load a ".csv" and skip the first line?

2012-09-03 Thread danap
> Is there some way to load a ".csv" file into a SQLite database table > when the first row (record) of the file contains headers? > > This does not work? > -- > .separator , > .import test.csv ld_assay > > Here's my database / table: > CREATE TABLE [ld_a

Re: [sqlite] how to re_update the id item

2012-09-03 Thread Simon Slavin
On 3 Sep 2012, at 7:53am, YAN HONG YE wrote: > my database have a column named id auto_increament inter primary key, when I > delete any rows , the id item may be indiscriminate , how to update it and > reorder the > column from 1 to max(id) order by id asc? Can you think through why you're

Re: [sqlite] Need to Increase sql parameter limit more than 999

2012-09-03 Thread Richard Hipp
On Mon, Sep 3, 2012 at 8:54 AM, Bhardwaj Amit Kumar < kumaram...@johndeere.com> wrote: > Hi, > > We are working on .NET application which deals with huge amount of data. > We are using SQLite as database for this application. We are getting "too > many sql parameters" exceptions frequently. >

[sqlite] Need to Increase sql parameter limit more than 999

2012-09-03 Thread Bhardwaj Amit Kumar
Hi, We are working on .NET application which deals with huge amount of data. We are using SQLite as database for this application. We are getting "too many sql parameters" exceptions frequently. We need to perform various types of queries on database which generates more than 999 parameters

Re: [sqlite] how to re_update the id item

2012-09-03 Thread Igor Tandetnik
YAN HONG YE wrote: > my database have a column named id auto_increament inter primary key, when I > delete any rows , the id item may be indiscriminate > , how to update it and reorder the column from 1 to max(id) order by id asc? It's not quite clear what you are trying to achieve. Perhaps som

Re: [sqlite] More bugs

2012-09-03 Thread Joe Mistachkin
Jan Slodicka wrote: > > a) File operations on Windows platforms have a number of other problems. For > example SQLite fails to report if given folder is write-able on WinRT. (This > is a handy test for below mentioned directories.) > This issue was recently fixed on trunk. See: http:/

[sqlite] More bugs

2012-09-03 Thread Jan Slodicka
Didn't get any reaction to my previous report, hence just briefly: a) File operations on Windows platforms have a number of other problems. For example SQLite fails to report if given folder is write-able on WinRT. (This is a handy test for below mentioned directories.) b) Global variables sqli