Re: [sqlite] strange behavior of "<" and ">" operator

postgres=# SELECT * from np WHERE (42>=fromId) AND (42<=toId); fromid | toid | serviceid +--+--- 40 | 43 | 3 (1 row) please forget it,this an error. - To unsubscribe, send email

Re: [sqlite] strange behavior of "<" and ">" operator

[EMAIL PROTECTED] wrote: fromIdVARCHAR(6), toId VARCHAR(6), excuse me, this was a stupid question: *fromId* and *toId* are VARCHAR, if I use *int* the behavior is correct, excuse me again, but remain the difference behavior between sqlite and Mysql. You will

Re: [sqlite] strange behavior of "<" and ">" operator

fromIdVARCHAR(6), toId VARCHAR(6), excuse me, this was a stupid question: *fromId* and *toId* are VARCHAR, if I use *int* the behavior is correct, excuse me again, but remain the difference behavior between sqlite and Mysql. bye Andrea.

[sqlite] strange behavior of "<" and ">" operator

I have a table like this: CREATE TABLE np ( fromIdVARCHAR(6), toId VARCHAR(6), serviceId INTEGER, PRIMARY KEY (fromId, toId) ); and I insert these values: INSERT INTO np VALUES ( 0, 5, 2); INSERT INTO np VALUES ( 40, 43, 3); INSERT INTO np VALUES (440,499, 3);

Re: [sqlite] Page 2 is never used

2048 Byte. > > Following a suggestion from an old mail in this mailinglist > I have replaced the type "dev_t" present in os_unix.c with (in my case) > "unsigned long" in this way the Device number is copied correctly. I want to add this information: I

Re: [sqlite] Page 2 is never used

stion from an old mail in this mailinglist I have replaced the type "dev_t" present in os_unix.c with (in my case) "unsigned long" in this way the Device number is copied correctly. Thanks Again Andrea Federico -- ___ Play 100s of games for FREE! http://games.mail.com/

Re: [sqlite] Page 2 is never used

rPC build from source. vxWorks is in pratical like a unix operating system. thank you andrea Federico -- ___ Play 100s of games for FREE! http://games.mail.com/

[sqlite] Page 2 is never used

ble I have an error again: sqlite> insert into tbl1 values('hello!',10); SQL error: database disk image is malformed have you some idea to solve the problem? Best Regards Andrea Federico -- ___ Play 100s of games for FREE! http://games.mail.com/

Re: [sqlite] sqlite3 and vxWorks "database disk image is malformed"

Rachel thank you for your reply but your suggestion don't run for me, I still to have the same terrible message: "database disk image is malformed" and I don't understand where is the problem, thank you again Andrea Federico. -- ___

[sqlite] sqlite3 and vxWorks "database disk image is malformed"

hen I have copy this database on my vxworks system but I receive the same message. I have the same message also if I create the database in memory, can you help me? Best Regards Andrea Federico -- ___ Play 100s of games for FREE! http://games.mail.com/