Ow! I'm stupid it's sqlite3 not sqlite
Thank you to all for your help
-----Message d'origine-----
De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
De la part de Robert Myers
Envoyé : jeudi 12 avril 2012 18:15
À : sqlite-users@sqlite.org
Objet : Re: [sqlite] error compilation with Sqlite in C program
On 4/12/2012 11:07 AM, Sako Youssouf wrote:
> Here my step and the result.
>
> # gcc -c sqlite3.c
> # ar -rvs libsqlite3.a sqlite3.o
> ar: creating libsqlite3.a
> a - sqlite3.o
>
> # gcc -L. -lsqlite -L/usr/lib/ -ldl -lpthread -o compil compil.c
Here's your problem. You want -lsqlite3
> /tmp/ccfdSnPR.o: In function `main':
> compil.c:(.text+0xc3): undefined reference to `sqlite3_open'
> compil.c:(.text+0xda): undefined reference to `sqlite3_errmsg'
> compil.c:(.text+0x101): undefined reference to `sqlite3_close'
> compil.c:(.text+0x138): undefined reference to `sqlite3_exec'
> compil.c:(.text+0x16d): undefined reference to `sqlite3_free'
> compil.c:(.text+0x179): undefined reference to `sqlite3_close'
> collect2: ld a retourné 1 code d'état d'exécution
>
> compil.c :
>
> 01 #include<stdio.h>
> 02 #include<sqlite3.h>
> 03
> 04 static int callback(void *NotUsed, int argc, char **argv, char
> **azColName){
> 05 int i;
> 06 for(i=0; i<argc; i++){
> 07 printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
> 08 }
> 09 printf("\n");
> 10 return 0;
> 11 }
> 12
> 13 int main(int argc, char **argv){
> 14 sqlite3 *db;
> 15 char *zErrMsg = 0;
> 16 int rc;
> 17
> 18 if( argc!=3 ){
> 19 fprintf(stderr, "Usage: %s DATABASE SQL-STATEMENT\n", argv[0]);
> 20 return(1);
> 21 }
> 22 rc = sqlite3_open(argv[1],&db);
> 23 if( rc ){
> 24 fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
> 25 sqlite3_close(db);
> 26 return(1);
> 27 }
> 28 rc = sqlite3_exec(db, argv[2], callback, 0,&zErrMsg);
> 29 if( rc!=SQLITE_OK ){
> 30 fprintf(stderr, "SQL error: %s\n", zErrMsg);
> 31 sqlite3_free(zErrMsg);
> 32 }
> 33 sqlite3_close(db);
> 34 return 0;
> 35 }
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
