Re: [sqlite] Violating Primary key Constraint

I copied and pasted the lines from your email into SQLite and got a different response from SQLite than you claim you got. sqlite3 SQLite version 3.3.8 Enter ".help" for instructions sqlite> create table secondtable (recid INT PRIMARY KEY NOT NULL, label ...> text); sqlite> insert into

Re: [sqlite] Violating Primary key Constraint

Hi! You Said me to create the field as "INT PRIMARY KEY NOT NULL" instead of "INTEGER PRIMARY KEY NOT NULL".Even we spell differently they are working same.it is also auto incrementing. sqlite> create table dummytable (recid integer PRIMARY KEY NOT NULL, label text); sqlite> insert into

Re: [sqlite] Violating Primary key Constraint

Hi Igor! You Said me to create the field as "INT PRIMARY KEY" instead of "INTEGER PRIMARY KEY".Even we spell differently they are working same.it is also auto incrementing. Regards, Satish.G -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Igor

[sqlite] Foreign Key

Hi All! I have a small question that Foreign key Constraint is now supported by SQLite or not.I had this question because in an SQLite table for a Foreign key "ON DELETE CASCADE or ON UPDATE CASCADE " are not working.Is there any problem with my database or with SQLite. Regards,

Re: [sqlite] Violating Primary key Constraint

Hi Satish, I just re-read your original email and Igor's response seemed appropriate. The original email read as if you were reporting a problem rather than asking a question. As for you question: sqlite> create table dummytable (recid integer PRIMARY KEY NOT NULL, label text); sqlite> insert

Re: [sqlite] Violating Primary key Constraint

"Satish" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] >Thanks for the reply.The thing I need is I don't want the field to > be > auto incremented Spell the field in some way other than precisely "INTEGER PRIMARY KEY". E.g. "INT PRIMARY KEY" would work as you expect. Igor

Re: [sqlite] Violating Primary key Constraint

Hi Igor! Thanks for the reply.The thing I need is I don't want the field to be auto incremented it should show me the error that constraint violated even if I give NULL or empty value.how can I do this.Don't send me links which doesn't have matter at all.First try to understand the problem

Re: [sqlite] Violating Primary key Constraint

On 11/24/08, Satish <[EMAIL PROTECTED]> wrote: > Hi All! > > > > I have created a table in sqlite.Upto my knowledge a column which is > declared as primary key will not accept null and even if I don't give any > value to that field an error occurs that violating the constraint > > For Example

Re: [sqlite] Violating Primary key Constraint

"Satish" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I have created a table in sqlite.Upto my knowledge a column which is > declared as primary key will not accept null and even if I don't give > any value to that field an error occurs that violating the constraint > > For

[sqlite] Violating Primary key Constraint

Hi All! I have created a table in sqlite.Upto my knowledge a column which is declared as primary key will not accept null and even if I don't give any value to that field an error occurs that violating the constraint For Example Create table emp(empno integer PRIMARY KEY,...,...) .

Re: [sqlite] self test for sqlite-amalgamation-3.6.5

Hi Shane, I am using linux and i have used these options: gcc -g -O2 -DSQLITE_OS_UNIX=1 -I. -I./src -DNDEBUG -I/devel/usr/include -DSQLITE_THREADSAFE=1 -DSQLITE_THREAD_OVERRIDE_LOCK=-1 -DTCLSH=1 -DSQLITE_NO_SYNC=1\ -DSQLITE_CRASH_TEST=1 -DSQLITE_TEST=1\

[sqlite] Wondering about SQLite and Java

What is the current wisdom about the best JDBC driver to use for SQLite in Linux? Thanks, glauber ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Return first row of database

On 11/24/08, Rick Pritchett <[EMAIL PROTECTED]> wrote: > I am trying to set my variable to the first row of my database how do you do that? > then delete the > row. Does any one have a good example? > What is your definition of the "first row" of your database. First, you obviously mean the

[sqlite] Return first row of database

I am trying to set my variable to the first row of my database then delete the row. Does any one have a good example? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Window functions

OLAP functionality includes the concept of a sliding *window* that moves down through the input rows as they are processed. Additional calculations can be performed on the data in the window as it moves, allowing further analysis in a manner that is more efficient than using semantically

Re: [sqlite] self test for sqlite-amalgamation-3.6.5

Can you provide more details? What platform (Windows, Linux, etc.)? What version of TCL? What compilation options did you use for the testfixture? On Mon, Nov 24, 2008 at 1:30 AM, Avinash Mittal <[EMAIL PROTECTED]>wrote: > Hi, > > I tried to execute the test for sqlite-amalgamation-3.6.5

Re: [sqlite] sqlite crash with "WHERE x in ()" query

Thanks for the report. The current test suite has many cases testing queries of the form you mention. I added one specifically for the query you suggested to in4.test. Everything passes for the current version. If you could test with the latest version of SQLite, it might help show where the

Re: [sqlite] Which TCL distrabution for Windows XP for running SQLite tests?

Shane Harrelson wrote: > >It wasn't a loss of precision, it was mearly a display issue. The Windows >ActiveTCL 8.5 >distribution might display the floating point value as "5.4e-018" while the >"unix" >TCL 8.5 version would display "5.4e-18" (or something similar). There's >probably >an option

Re: [sqlite] Which TCL distrabution for Windows XP for running SQLite tests?

On Mon, Nov 24, 2008 at 9:30 AM, Michael Schlenker <[EMAIL PROTECTED]> wrote: > Shane Harrelson schrieb: > > Sorry for the late reply. I use both the ActiveTCL and the Cygwin > > distributions for testing on Windows. > > It should be noted that both versions have limitations that will cause > >

Re: [sqlite] Which TCL distrabution for Windows XP for running SQLite tests?

Shane Harrelson schrieb: > Sorry for the late reply. I use both the ActiveTCL and the Cygwin > distributions for testing on Windows. > It should be noted that both versions have limitations that will cause > "false positives" in the test suite. > > Be on the look out especially for problems

Re: [sqlite] Which TCL distrabution for Windows XP for running SQLite tests?

Sorry for the late reply. I use both the ActiveTCL and the Cygwin distributions for testing on Windows. It should be noted that both versions have limitations that will cause "false positives" in the test suite. Be on the look out especially for problems with 64-integers and floating point

Re: [sqlite] Request to check UNICODE support

Hi, sqlite supports unicode. Internally, thext is stored in UTF-8 or UTF-16, depending on sqlite3_open or sqlite3_open16, respectively. See http://www.sqlite.org/c3ref/funclist.html, There functions named sqlite3_xxx16 are described , which take UTF-16 as arguments. Martin [EMAIL PROTECTED]

Re: [sqlite] Request to check UNICODE support

<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Is SQLite support UNICODE Character set Yes. All SQLite API functions accept UTF-8 or UTF-16 strings. Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Fwd: test error

please discard the previous message. the error which i got during sqlite-amalgamation test execution is : incrblob_err-7.8.1... Error: disk I/O error ./testfixture: disk I/O error while executing "$db eval { SELECT name, type, sql FROM sqlite_master order by name }" (procedure

Re: [sqlite] test error

hi, attachments do not reach this list, please specify the error. Martin AVINASH MITTAL schrieb: > > Hi, > > while executing tests for amalgamation for version 3.6.5 i got this error, > can somebody help me in this regard > > Regards > ___ >

[sqlite] test error

Hi, while executing tests for amalgamation for version 3.6.5 i got this error, can somebody help me in this regard Regards ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Request to check UNICODE support

Hi all This is krishnakumar i am using SQLite as data base in my application as meta data storage i want use it to store CString how can i deal with UNICODE. Is SQLite support UNICODE Character set Krishna Kumar T M 9886454481

[sqlite] contstraint failed problem

Hello, i have a rtree table which I dynamically opulate with results. Sometimes however, I get a "constraint failed" error from SQLite. After some poking, I found that it occurs whenever my statement tries to insert a record which has an ID that is already in the rtree-table, which is ok, as

Re: [sqlite] optimizing a multiple select statement

> insert or ignore into idlookup > select * from ( > select * from cl1 > UNION ALL select * from cl2 > UNION ALL select * from cl3 > UNION ALL select * from cl4 > UNION ALL select * from cl5 > ) > where (lomi>13.96 and loma<13.96 and lami>53.23 and lama<53.23); > Thanks, but