Re: [sqlite] Where statements are they case sensitive?

I checked a few systems and there doesn't seem to be a standard. As was said Oracle is case sensitive but all the Microsoft products I check SQL, Access , MS Query where all case insensitive. I think a PRAGMA would be a great idea for this. What do other people think? Using a like (which

Re: [sqlite] Read Notifications

Bert Verhees wrote: Hi, Since we are using the new List-headers on sqlite-list, I am experiencing two disadvantages. I recieve many emails twice, please do not send your emails twice, but manually remove one from the To or CC when your emailer does not support List-reply. But at least we can

Re: [sqlite] Where statements are they case sensitive?

Hi! > I just checked something and noticed that the WHERE statement is case sensitive. I have check this in SQL Server and it is not case sensitive. > > I am using 2.8.5 and 2.8.6. > > As an example in the northwind DB I have for SQLite . There is a table called Orders > select * from sqlite_mas

Re: [sqlite] Where statements are they case sensitive?

I just checked something and noticed that the WHERE statement is case sensitive. I have check this in SQL Server and it is not case sensitive. I am using 2.8.5 and 2.8.6. As an example in the northwind DB I have for SQLite . There is a table called Orders select * from sqlite_master where Na

Re: [sqlite] Making sqlite support unicode?

On Mon, 2003-10-27 at 10:27, [EMAIL PROTECTED] wrote: > On Sun, 26 Oct 2003 23:36:55 -0500 > "Mrs. Brisby" <[EMAIL PROTECTED]> wrote: > > It's good to use null-terminated in many cases; especially in collating > > and sorting. It helps to understand that in those cases you stop > > processing _aft

Re: [sqlite] Checking the busy state

Hi, > The application is actually supposed to run on a network and all copies will > access the database file at some central location. I'm currently playing > around with SQLITE_BUSY and SQLITE_LOCKED values and they work 90% of the > time, but then sometimes they don't work for some reason and I

Re: [sqlite] Checking the busy state

Thank you Tito, The application is actually supposed to run on a network and all copies will access the database file at some central location. I'm currently playing around with SQLITE_BUSY and SQLITE_LOCKED values and they work 90% of the time, but then sometimes they don't work for some reason a

Re: [sqlite] Checking the busy state

Well, this is more an application implementation issue, not SQLite-only. There are probably many possible solutions, but one I would implement is something like this: 1) Keep track of the db timestamp. That would let you know if something has changed. 2) This "something" is (please people corr

Re: [sqlite] Checking the busy state

Yes, that's possible, but then I wouldn't know if I need to update the whole database (if something was deleted) or just one row if it was updated and it could make a difference (time-wise). I was thinking of trying out the approach of creating a special table, for example: network(busy,action,nam

Re: [sqlite] Checking the busy state

Hello Dennis, On miércoles, octu 29, 2003, at 09:16 Europe/Paris, Dennis Volodomanov wrote: That issue is, if I query a row before I want to change it, and I get some values, and reading from a database is allowed by all, even if the database is locked for writing, then how will I know that th

[sqlite] Import data from a SQLite-database to Excel through SQLite-ODBC

Hi Folks, please i need your help. I'm triying since 3 weeks to import some data from a SQLite-database to an excel-sheet via the interface "SQlite-ODBC"; But it's don't work. I already install an configure SQLite-ODBC and every thing is okay with MS-Query BUT! I write a makro on the excel-sheet

Re: [sqlite] Checking the busy state

Maybe I'm really slow today, but I don't understand one important issue :-) That issue is, if I query a row before I want to change it, and I get some values, and reading from a database is allowed by all, even if the database is locked for writing, then how will I know that the database was chang

[sqlite] Read Notifications

Hi, Since we are using the new List-headers on sqlite-list, I am experiencing two disadvantages. I recieve many emails twice, please do not send your emails twice, but manually remove one from the To or CC when your emailer does not support List-reply. I am often asked to cancel the read notif