Re: [sqlite] SQLite support on windows

2012-08-25 Thread Simon Slavin
On 26 Aug 2012, at 5:30am, Arbol One wrote: > I am glad someone asked this question, we are almost finish with a small > application that is best suited for a hand held device. Is there a device > anyone here could suggest? > As I said, the application is very small and uses

Re: [sqlite] What Windows versions are supported by SQLite3

2012-08-25 Thread Mohit Sindhwani
On 26/8/2012 3:38 AM, Klaas V wrote: Mohit wrote: SQlite3 works fine on Windows CE (at least 5.0 and 6.0) and Windows Mobile 6.x >or so. Windows Phone 7 doesn't support end-users compiling native C/ C++ code >and accessing it from their applications - but there is a C# port that does work

Re: [sqlite] SQLite support on windows

2012-08-25 Thread Mohit Sindhwani
On 26/8/2012 12:30 PM, Arbol One wrote: I am glad someone asked this question, we are almost finish with a small application that is best suited for a hand held device. Is there a device anyone here could suggest? As I said, the application is very small and uses SQLite as its RDB. The

Re: [sqlite] SQLite support on windows

2012-08-25 Thread Arbol One
I am glad someone asked this question, we are almost finish with a small application that is best suited for a hand held device. Is there a device anyone here could suggest? As I said, the application is very small and uses SQLite as its RDB. The application resembles a questionnaire... fill in

Re: [sqlite] unique constraints

2012-08-25 Thread Simon Slavin
On 26 Aug 2012, at 4:13am, Roger Binns wrote: > On 25/08/12 13:04, John Taylor wrote: >> insert into tbl values("john"); > > You should use single quotes for string literals in SQL not double quotes. > >> Error: near line 9: column name is not unique > > It does tell

Re: [sqlite] unique constraints

2012-08-25 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 25/08/12 13:04, John Taylor wrote: > insert into tbl values("john"); You should use single quotes for string literals in SQL not double quotes. > Error: near line 9: column name is not unique It does tell you the name of the column. Under what

[sqlite] unique constraints

2012-08-25 Thread John Taylor
Greetings, This is my first time posting to this list, so I am not sure if this is the correct list or not for this request. If it is not, please let me know the best place for it. Version 3.7.12 has added the following feature: "Report the name of specific CHECK constraints that fail."

[sqlite] What Windows versions are supported by SQLite3

2012-08-25 Thread Klaas V
Mohit wrote: >SQlite3 works fine on Windows CE (at least 5.0 and 6.0) and Windows Mobile 6.x >or so.  Windows Phone 7 doesn't support end-users compiling native C/ C++ code >and accessing it from their applications - but there is a C# port that does work (as >far as I know). We used 3.6.x

Re: [sqlite] Fw: create table question

2012-08-25 Thread Kees Nuyt
On Fri, 24 Aug 2012 20:22:43 -0700 (PDT), u okafor wrote: >We am still working on the CREATE TABLE exercise .. our Visual Studio project >will not  >breakpoint in certain places - something about pre-processor directives and/or >compile/link >optimization techniques used;

Re: [sqlite] interesting deadlock.

2012-08-25 Thread Jonathan Engle
No, the deadlock is deeper than that, it's stuck trying to lock mutexes. My current theory is that the thread trying to update the page in the backup destination database is what's causing trouble. I also forgot to mention, each thread is using a different connection object and that it's

Re: [sqlite] interesting deadlock.

2012-08-25 Thread Patrik Nilsson
Do you test for the backup errors, i.e. SQLITE_BUSY and SQLITE_LOCKED? Do you test for step errors, i.e. SQLITE_BUSY? If you get the busy error, you can wait a while and try again or start over. /Patrik On 08/24/2012 05:46 PM, Jonathan Engle wrote: > Ran into this recently, it's happened on

[sqlite] Fw: create table question

2012-08-25 Thread u okafor
We am still working on the CREATE TABLE exercise .. our Visual Studio project will not  breakpoint in certain places - something about pre-processor directives and/or compile/link optimization techniques used; for an alternative, we want to trace the flow from the begining to end for CREATE

Re: [sqlite] SQLite support on windows

2012-08-25 Thread Mohit Sindhwani
On 22/8/2012 11:49 PM, Rajahariharan Jayam wrote: Dear, What are the windows O/S version does the SQLite supports? As far as I know, it should support any version of Windows that you can compile it for... I don't remember seeing any posts in the past that support for any specific version