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
Re: [sqlite] Sqlite explorer
D. Richard Hipp wrote: mike cariotoglou wrote: > if DRH can provide the upload space, I could make them public, free of charge > of course. > I've added generic file sharing space on the sqlite website. http://www.sqlite.org/tsc/contrib Correction: http://www.sqlite.org/contrib The "/tsc" subdirectory has now been omitted. You will need a user-id and password to upload. Contact me by private email to get one. -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
Re: [sqlite] Sqlite explorer
mike cariotoglou wrote: > if DRH can provide the upload space, I could make them public, free of charge > of course. > I've added generic file sharing space on the sqlite website. http://www.sqlite.org/tsc/contrib You will need a user-id and password to upload. Contact me by private email to get one. -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
RE: [sqlite] Sqlite explorer
If Richard is unable to provide the space for you, I should be able to host the files for you (and I would be sure to give you fair warning if it got to the point where I couldn't). Just let me know if I can help. Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com/ -Original Message- From: mike cariotoglou [mailto:[EMAIL PROTECTED] Sent: Thursday, October 07, 2004 8:05 PM To: [EMAIL PROTECTED] Subject: [sqlite] Sqlite explorer I have a new version of sqliteExplorer, which handles v3 databases, and has some other enhancements as well, for some time now. The problem is, I dont have a web server to put it on. DRH, is there some place on the site where I can upload it ? question to all: how many people use sqlite with Delphi ? I have a couple of delphi sqlite components, which are quite sophisticated, and make use of the engine very easy. I have not bothered to upload them anywhere, since I assumed that most people use sqlite with C anyway. if there is an interest, however, and if DRH can provide the upload space, I could make them public, free of charge of course. - Original Message - From: "Steve Frierdich" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 07, 2004 11:21 PM Subject: [sqlite] Does the Sqlite explorer program not view version 3 sqlite databases? > > > Does the sqlite explorer program not view version 3 sqlite databases? I > tried to open a sqlite version 3 database with the sqlite explorer > program and the program said that the database is malformed. Is there a > new sqlite explorer program to download to view sqlite version 3 databases? > > Thanks for all your help > > Steve Frierdich > > > >
[sqlite] Sqlite explorer
I have a new version of sqliteExplorer, which handles v3 databases, and has some other enhancements as well, for some time now. The problem is, I dont have a web server to put it on. DRH, is there some place on the site where I can upload it ? question to all: how many people use sqlite with Delphi ? I have a couple of delphi sqlite components, which are quite sophisticated, and make use of the engine very easy. I have not bothered to upload them anywhere, since I assumed that most people use sqlite with C anyway. if there is an interest, however, and if DRH can provide the upload space, I could make them public, free of charge of course. - Original Message - From: "Steve Frierdich" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 07, 2004 11:21 PM Subject: [sqlite] Does the Sqlite explorer program not view version 3 sqlite databases? > > > Does the sqlite explorer program not view version 3 sqlite databases? I > tried to open a sqlite version 3 database with the sqlite explorer > program and the program said that the database is malformed. Is there a > new sqlite explorer program to download to view sqlite version 3 databases? > > Thanks for all your help > > Steve Frierdich > > > >