> T&B wrote: > > Last month, Mikey C wrote (in part): > > > >> I've had these functions hanging around for some > time... if anyone > >> wants the code, please take it. > >> > >> I have all the code as a MS Visual Studio 2003 > project. It is based > >> on source code 3.3.5 > > > > > >> replace(X,Y,Z) Returns the string X with every > occurence of Y > >> replaced by Z. > > > > > >> rightstr(X,Y) Returns the Y last characters of > the string X. > > > > > >> strfilter(X,Y) Returns the string X with the > characters not in Y > >> removed. > > > > > >> trim(X) Returns a string equal to X but with all > the whitespaces at > >> the begining and at the end removed. > > > > > >> median(X) Returns the value of the group such > that the number of > >> elements smaller is equal to the number of larger > elements. > > > > > >> mode(X) Returns the most frequent value in the > sample X. > > > > > >> stdev(X) Returns the standard deviation of the > sample X. > > > > > >> http://www.nabble.com/file/6285/SQLite.zip > SQLite.zip > >> -- > >> View this message in context: > http://www.nabble.com/Extension- > >> > functions-for-SQLite-in-C-for-free-tf3182921.html#a8833684 > > > > > > For the non-C programmer (but with access to > standard UNIX C compile > > tools etc), can someone please explain or point to > a step by step > > procedure to add these functions so they are > accessible within the > > sqlite3 shell command? > > > > Thanks, > > Tom > > This requires that you produce a custom version of > the sqlite3 shell > incorporating the extra functions. That requires > some basic programming > understanding.
I think you can compile the functions into a loadable library (follow the instructions on creating a sqlite loadable extension), and then load them in the console app. In linux: gcc myLoadableLibs.c -shared -o myLoadableLibs.so then sqlite3> .load /home/jp/myLoadableLibs.so I am not sure how to do that on VC though. jp. ____________________________________________________________________________________ Don't pick lemons. See all the new 2007 cars at Yahoo! Autos. http://autos.yahoo.com/new_cars.html ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------