Re: [sqlite] problem of creation of a data base

Thank you for your assistance, all functions very well thanks to you! I had to add: extern "C" { #include "os.h" } Excuse me if I have a little difficulties of understanding, I am newbie with Sqlite. Yours sincerely, Denis Lurkin.

Re: [sqlite] problem of creation of a data base

I added: extern "C" { #include } and I have a problem of compilation: sqlite.h: No such file or directory I tested with: extern "C" { #include } but I always have the following error: ZeroLink: unknown symbol '__Z21sqlite3OsFullPathnamePKc' What to make? Thank you. Denis Lurkin.

[sqlite] problem of creation of a data base

Hello, I created a new project to which I included all the source files SQLITE 3.2.2 I have make a class DATABASE in which I created a method to create the base of data. int SqliteDatabase::create(const char *DbName) { int readOnly = 0; int rc = 0; char *zFullPathname =

Re: [sqlite] order of reception of results at the time of a request SQL

Thank you to all, I thus will pay attention in my code and to put the columns in the order and thus not to use the "select *". It will be more careful. Denis Lurkin.

Re: [sqlite] order of reception of results at the time of a request SQL

Hello, I have do many tests. It appears that the results of requests each time are received in the same order. This order is that of creation of the table. If I have make a CREATE TABLE X (int, char, int, char), I receive the results of my request SQL in the good order: int, char, int, char.

[sqlite] order of reception of results at the time of a request SQL

Hello, In my application, I call upon the method sqlite3_exec(). This method returns the results of request SQL in a function: callback(int argc, char **argv, char **azColName). This function "callback" displays then the results: int i; for(i=0; i

[sqlite] problem of compréhention of sqlite

Hello, I am on mac and I work with XCode. I created a data base with SQLITE: /sqlite3 lolo (the name of the data base is not important ; -) ) When I look at the name of the data base (struct sqlite3 - > aDb - > zName), I receive "main" like name! Why the name isn't "lolo"? I then created two

Re: [sqlite] beginnings with sqlite

Ok I found my error, when I launched the application with the Terminal, the executable and the data base were at the same place whereas with XCode there were no data base at the place of the executable. The application thus created a data base with the name which I passed in parameter but this DB

Re: [sqlite] beginnings with sqlite

Hello, Thanks for replied ! I am sure that XCode loads the good name of the DB. I tried with another name for my DB and with XCode I have the same problem. With the Terminal, when I try with the name without extention I receive the error message but a file with the name of the DB without

Fwd: [sqlite] beginnings with sqlite

Hi all, no ideas for my problem ? Please, help me ;-) . Regards, Denis Lurkin.

[sqlite] beginnings with sqlite

Hi all, I am new in the world sqlite. I was on the site and I looked at how to make to begin thanks to the link "quick start". I thus compiled the sources of sqlite 3.2.2. I have to create a data base test.db. I have to create a table "personne" and I added data there. I have write the small