Re: [sqlite] SQLite Explorer (singular) is missing the STDEV function (standard deviation)
Am 01.04.2011 15:44, schrieb Mr. Puneet Kishor: >> See http://www.sqlite.org/contrib extension-functions.c > > Is there a guide on how to compile the above extension-functions.c > into sqlite, so it is always available without have to do load the > extension explicitly? > > Pointers appreciated. My component wxSQLite3 (a SQLite wrapper for wxWidgets applications) includes the sources for SQLite with support for the mentioned extension functions without requiring to load the extension. All what's required is to compile a single C source file (which in turn includes all other necessary source files) with the symbol SQLITE_ENABLE_EXTFUNC defined. The source code can be downloaded from here: http://sourceforge.net/projects/wxcode/files/Components/wxSQLite3/ And here you find some additional information which might be helpful for building SQLite: http://wxforum.shadonet.com/viewtopic.php?t=27217 Regards, Ulrich ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Explorer (singular) is missing the STDEV function (standard deviation)
On Mar 31, 2011, at 2:28 PM, Doug Currie wrote: > On Mar 31, 2011, at 2:27 PM, Mike Rychener wrote: > >> I have tried the latest Explorer and it gets a syntax error on STDEV. >> However, that function works in Eclipse just fine, to take the standard >> deviation of a column (like min, max, avg). Is there a workaround or >> other fix available? > > See http://www.sqlite.org/contrib extension-functions.c > Is there a guide on how to compile the above extension-functions.c into sqlite, so it is always available without have to do load the extension explicitly? Pointers appreciated. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Explorer (singular) is missing the STDEV function (standard deviation)
On Mar 31, 2011, at 2:27 PM, Mike Rychener wrote: > I have tried the latest Explorer and it gets a syntax error on STDEV. > However, that function works in Eclipse just fine, to take the standard > deviation of a column (like min, max, avg). Is there a workaround or > other fix available? See http://www.sqlite.org/contrib extension-functions.c e ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Explorer (singular) is missing the STDEV function (standard deviation)
On 3/31/2011 2:27 PM, Mike Rychener wrote: > I have tried the latest Explorer and it gets a syntax error on STDEV. > However, that function works in Eclipse just fine, to take the standard > deviation of a column (like min, max, avg). Is there a workaround or > other fix available? Explorer doesn't recognize VAR or VARIANCE > either. I tried some alternate spellings with no luck. These functions are not built into SQLite. Eclipse must be adding them. -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQLite Explorer (singular) is missing the STDEV function (standard deviation)
I have tried the latest Explorer and it gets a syntax error on STDEV. However, that function works in Eclipse just fine, to take the standard deviation of a column (like min, max, avg). Is there a workaround or other fix available? Explorer doesn't recognize VAR or VARIANCE either. I tried some alternate spellings with no luck. -- Mike Rychener 919-929-5091 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users