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

>> You will be told MySQL doesn't set the standard :-) > the same query in postgresql have have same result of Mysql. And nor does Postgresql. > Mysql and postgresql have the same behavior and sqlite is different. > > what do you think about this? > where I am mistaking? You are making a mistake

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. You will be told MySQL doesn't se

Re: [sqlite] problem with auto increment of ROWID

> 9,223,372,036,854,775,807 / (1,000,000 * 60seconds * 60minutes * 24hours * > 365days) = 292471 years > > On 8/30/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: >> >> The maximum rowid is 9223372036854775807. You're going to take >> a long time to reach that value if you start with 1. >> >> Do

Re: [sqlite] Re: R: Re: [sqlite] How to compile sqlite3 C sample code

Try providing a -I directive followed by the path to the include files. > > Hi, > I am also one of SQLilte User. I am struggling to compile c code for > sqlite. > If you don't mind , please send me c code to compile. > i am waiting for ur reply. > thanks > -