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

the 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 MacOSX

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

[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

Re: [sqlite] Accessing the datatype in SQLLite ?

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 you get the datatypes

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

[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