See extension-functions.c in http://sqlite.org/contrib.
On Sat, Jun 19, 2010 at 10:52 PM, Sam Carleton <[email protected]> wrote: > I need to add a new where clause to my query, one that checks to see > if the file actually exits. I am thinking the correct solution is a > user defined function, something like: > > bool DoesFilesReallyExist(char* rootPath, char* relativePath, char* filename) > > Where I could do a query like this: > > Select relativePath, filename, DoesFilesReallyExist("some path", > relativePath, filename) as exists from table where exists = 1 > > Where might I find some examples of creating user defined functions in SQLite? > > Sam > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
