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 secondta
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 dummytable
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 Tan
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,
Sat
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 i
"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 Tande
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 and
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
"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 Exampl
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,...,...)
.
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\
-DSQLITE_SE
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
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 "
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
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 equivalen
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 repos
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
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
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
> >
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 with
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 value
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] sc
<[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
http://sqlite.or
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
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
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
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
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 t
> 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 sometimes
29 matches
Mail list logo