I have searched the web and I have looked through the subjects of all the archived posts and I cannot find any examples showing me how to use the "extension_functions.c" code in a C/C++ program with "sqlite3.c". I am aware of the compilation instructions included in the "extension_functions.c" source file and I have studied the example found in the wiki (http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions). Unless I am mistaken, these instructions are set up to create a *.dll file to be used/dynamically linked by "sqlite3.c" at run time.
I use CodeGear C++ Builder and I have absolutely no trouble using "sqlite3.c". As huge as the amalgamation is, not even as much a single warning is raised (I AM VERY IMPRESSED!). Within the last two years I wrote a C++ wrapper around "sqlite3.c", but the hard drive went up in smoke, so my goal is to re-create the wrapper and to include support for extended aggregate functions, such as standard deviation, hence the desire to use "extension_functions.c". The goal is also to avoid dependencies. Question 1.) Can "exentension_functions.c" be compiled along with "sqlite3.c" into one executable? Question 2.) If so, how? Question 3.) If "exentension_functions.c" be compiled into one executable along with "sqlite3.c", do I need to do anything special or will sqlite3_exec() know what to do with queries like: "SELECT AVG(V_OUT) AS V_OUT_AVG, STDEV(V_OUT) AS V_OUT_STDEV FROM test_data_table GROUP BY TargetInputVoltage" Thanks, Steve. This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users