Re: [sqlite] How to install SQLite for use in XCode (MacOSX) ?

source in your XCode project, as done with the QuickLite wrapper (check http://www.webbotech.com/ for an example). Philip On Oct 2, 2004, at 3:16 PM, b.bum wrote: On Oct 2, 2004, at 10:29 AM, Eric Morand wrote: I'm currently on the process to use an SQLite database on my new XCode project, for M

[sqlite] How to install SQLite for use in XCode (MacOSX) ?

Hi to all ! I'm currently on the process to use an SQLite database on my new XCode project, for MacOSX Panther. But I have no idea on how I should install the database framework... Can someone explain me the entire process ? Thanks by advance, Eric.

Re: [sqlite] Re: [inbox] [sqlite] About ORDER BY results...

This was a mistake by me ! Here is the order actually returned by SQLite : Celine Céline Eric Marc Zoe céline eric Éric éric Do someone know how to have the ORDER BY statement return values ordered with anything else that memcmp() order ? This method completely make the ORDER BY useless when de

Re: [sqlite] Re: [inbox] [sqlite] About ORDER BY results...

This was an error when I copied the list...sorry. Le 25 févr. 04, à 00:19, Michael Hunley a écrit : Moreover, it does not appear correct! "Éric" appears twice, once before "Zoe" and again before "éric". Why is that? - To unsub

[sqlite] About ORDER BY results...

Hi to all, I've noticed a strange behavior with the SELECT...ORDER BY... statement. Maybe this is a feature but that still bugs me... Here is a part of my database : Table : Thirds Column : Name Entres : Eric, Céline, éric, Éric, Celine, Marc, eric, céline, Zoe. When I perform this query to the

Re: [sqlite] Accessing the datatype in SQLLite ?

before ? Le 20 févr. 04, à 15:09, Gerhard Häring a écrit : Eric Morand wrote: Hi to all ! Is there a way to access to the datatype used in the CREATE TABLE statement dynamically ? [...] http://sqlite.org/lang.html#pragma_show_datatypes If you're using the new, non-callback based API y

Re: [sqlite] Accessing the datatype in SQLLite ?

Thanks Will & Gerhard !!! Your combined help was exactly what I needed ! I don't even know how I missed this part about the Pragma... Again, thanks to both of you... - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional co

[sqlite] Accessing the datatype in SQLLite ?

Hi to all ! Is there a way to access to the datatype used in the CREATE TABLE statement dynamically ? For instance, let's say I have created this table : CREATE TABLE myTable VALUES ( aText TEXT, anInteger INTEGER) Later, I want to be able to access the values of each row and store them in the