On 7 November 2011 21:58, Richard D Watkins <richard.d.watk...@seagate.com> wrote: > I am trying to compile extension-functions.py so that I may use the > stdev function in SQLite queries. However, I keep getting errors that > indicate failure to compile. > > First, I compiled the code for pysqlite, which created a directory that > contains the following files: > > amalgamation build cross_bdist_wininst.py cross_bdist_wininst.pyc doc > lib LICENSE MANIFEST.in PKG-INFO setup.cfg setup.py src > > Then, I fetched and added these two files to the above directory: > sqlite3ext.h and extension-functions.c . > Then, I made this directory the current working directory, and executed the > following command > > gcc -fPIC -lm -shared extension-functions.c -o libsqlitefunctions.so > > This displays a long list of error messages, some of which are copied > below. Pysqlite works fine. I can create tables, insert data and fetch it > back out. However, I cannot compile the extension-functions.c file. I am > running gcc version 3.4.5. > > Does any one know what is going wrong? > > > # gcc -fPIC -lm -shared extension-functions.c -o libsqlitefunctions.so > In file included from extension-functions.c:124: > sqlite3ext.h:22:21: sqlite3.h: No such file or directory <==== > sqlite3.h is required > In file included from extension-functions.c:124: > sqlite3ext.h:37: error: syntax error before '*' token . . . > > > Regards, > Richard Watkins > Product Development & Systems Engineering
Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
