On Oct 6, 2009, at 4:40 PM, Emyr Thomas wrote: > On Oct 5, 8:09 pm, Nuno Lucas <ntlu...@gmail.com> wrote: >> Emyr Thomas wrote: >>> Could you please provide some info as to how you would build this as >>> an extension module on Linux? >> >> "make" ? >> >> It would be easier if you stated why that doesn't work for you. > > Apologies, my question was very vague. Here are the details... > > I've tried to get the CSV virtual table extensions to compile on 3 > different architectures (OS X, RHEL5 and Cygwin) without luck. I'm no > expert at this, so I may be missing something obvious. > > I tried first on Mac OS X with version 3.6.18 of sqlite installed via > MacPorts. > > macbook:~ emyr$ sqlite3 -version > 3.6.18 > macbook:~ emyr$ otool -L `which sqlite3` > /opt/local/bin/sqlite3: > /opt/local/lib/libsqlite3.0.dylib (compatibility version 9.0.0, > current version 9.6.0) > /opt/local/lib/libreadline.6.dylib (compatibility version 6.0.0, > current version 6.0.0) > /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current > version 111.1.4) > /opt/local/lib/libncurses.5.dylib (compatibility version 5.0.0, > current version 5.0.0) > /usr/lib/libgcc_s.1.dylib (compatibility version 1.0.0, current > version 1.0.0) > > So looks like I'm using the most recent version of sqlite...
You have the most recent version installed. But perhaps the pre- processor is finding an older sqlite3.h. Try adding -I/usr/local/include to the gcc command. > macbook:~ emyr$ cd csvfile > macbook:csvfile emyr$ make > gcc -c -o virtual_csv.o -s -O2 -Wall -Wextra virtual_csv.c > virtual_csv.c:377: error: syntax error before ‘sqlite3_int64’ > virtual_csv.c: In function ‘csv_rowid’: > virtual_csv.c:379: error: ‘pCursor’ undeclared (first use in this > function) > virtual_csv.c:379: error: (Each undeclared identifier is reported only > once > virtual_csv.c:379: error: for each function it appears in.) > virtual_csv.c:381: error: ‘pRowid’ undeclared (first use in this > function) > make: *** [virtual_csv.o] Error 1 > > Any ideas what's going wrong here? > > Thanks again > > --Emyr > _______________________________________________ > 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
