[sqlite] Compact Framework

2003-12-08 Thread Eric Pankoke
Hi, I'm back to bug everyone again. First off, I want to say thanks to those who helped me out with getting SQLite working in the Pocket PC world with eVC++. Now I'd like to move up to .NET and the Compact Framework, and I've seen several links on the Wiki site that deal with .NET, but nothing sp

Re: [sqlite] autoincrement ... primary-key bug

2003-12-08 Thread D. Richard Hipp
Kurt Welgehausen wrote: D.R.Hipp: "I concur. The uniqueness constraint is not being enforced for multi-column primary keys. Why don't you write a ticket." --- [1]If you're intending to follow SQL92, this is definitely a bug, since th

Re: [sqlite] autoincrement ... primary-key bug

2003-12-08 Thread Kurt Welgehausen
> CREATE TABLE User ( Name VARCHAR (40), > UID INTEGER, > DeviceID VARCHAR (64) DEFAULT 'Unknown', > PRIMARY KEY (Name, UID, DeviceID) ); > INSERT INTO User (Name,DeviceID) VALUES ('M

Re: [sqlite] autoincrement columns & primary key

2003-12-08 Thread D. Richard Hipp
Michael Hunley wrote: 1. In order to actually get autoincrement functionality, the table creation has to specify the column explicitly as INTEGER without further "decoration". I had tried specifying "UNSIGNED INTEGER (10)" and "INTEGER (10)" as I would for mysql and I could not get autoinc to

[sqlite] autoincrement columns & primary key

2003-12-08 Thread Michael Hunley
I have just begun experimenting with SQLite for an embedded project. I am relatively new to this list, so apologies if this is old news. Is there an archive of the emails with a good search facility so I can check for old questions? I was trying out some table creation and insert semantics in

[sqlite] back in the saddle

2003-12-08 Thread SQLite Admin Support
For those of you who might have been wondering what happened to SQLite Admin (.NET) if you were trying to check for updates or download it for the first time I encountered a domain expiry problem (which still hasn't been resolved) so everything has moved to http://www.winextra.com . The direct

Re: [sqlite] User Functions / Graphs

2003-12-08 Thread Kurt Welgehausen
>> Is it http://citeseer.nj.nec.com/dong99maintaining.html ? Yes, that's it. Regards - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] Case-Sensitive Queries

2003-12-08 Thread Raymond Irving
Hi Everyone, I think is expedient that we look into this case-sensitive issues. I think that queries should not be case-sensitive, but if that's how things are with SQLite then I would suggest that a PRAGMA be made available to turn on/off case-sensitive queries. When searching a database the wil

RE: [sqlite] User Functions

2003-12-08 Thread Jarosław Nozderko
Is it http://citeseer.nj.nec.com/dong99maintaining.html ? Regards, Jarek Jaroslaw Nozderko GSM +48 601131870 / Kapsch (22) 6075013 [EMAIL PROTECTED] IT/CCBS/RS - Analyst Programmer > -Original Message- > From: Kurt Welgehausen [mailto:[EMAIL PROTECTED] > Sent: Friday, December 05, 2003

Re: [sqlite] SQLITE under AIX

2003-12-08 Thread Christian Smith
On Sun, 7 Dec 2003, laurent Blanquet wrote: >Hello, > >Has somebody ever compiled SQLITE under AIX (4.1 or further) ? >Any comment would be appreciated. Just tried 2.8.4 on AIX 4.2 (using configure) using AIX compiler. Compiles and runs fine. Not extensively tested, but I may be using it in the