Re: [GRASS-dev] How to calculate log() in v.db.update with SQLite backend?

2014-12-28 Thread Helmut Kudrnovsky
Markus Neteler wrote On Sat, Dec 20, 2014 at 5:49 PM, Helmut Kudrnovsky lt; hellik@ gt; wrote: Markus Neteler wrote Works. Submitted to trunk in r63238. Please test (tomorrow) also on Windows if possible (the name will be something like libsqlitefunctions.dll which you need to provide

Re: [GRASS-dev] How to calculate log() in v.db.update with SQLite backend?

2014-12-28 Thread Helmut Kudrnovsky
should we add a note to the manual where extension-functions.c could be downloaded (https://www.sqlite.org/contrib) and how it is compiled (on windows)? or somewhere in the wiki? wiki entry added: http://grasswiki.osgeo.org/wiki/Build_SQLite_extension_on_windows - best regards Helmut --

Re: [GRASS-dev] How to calculate log() in v.db.update with SQLite backend?

2014-12-27 Thread Markus Neteler
On Sat, Dec 20, 2014 at 5:49 PM, Helmut Kudrnovsky hel...@web.de wrote: Markus Neteler wrote Works. Submitted to trunk in r63238. Please test (tomorrow) also on Windows if possible (the name will be something like libsqlitefunctions.dll which you need to provide to v.db.select). any idea

Re: [GRASS-dev] How to calculate log() in v.db.update with SQLite backend?

2014-12-20 Thread Helmut Kudrnovsky
Markus Neteler wrote Works. Submitted to trunk in r63238. Please test (tomorrow) also on Windows if possible (the name will be something like libsqlitefunctions.dll which you need to provide to v.db.select). any idea where to find/to get libsqlitefunctions.dll for testing? - best

Re: [GRASS-dev] How to calculate log() in v.db.update with SQLite backend?

2014-12-19 Thread Markus Neteler
On Fri, Nov 28, 2014 at 11:18 AM, Markus Neteler nete...@osgeo.org wrote: On Thu, Nov 20, 2014 at 10:53 AM, Markus Neteler nete...@osgeo.org wrote: ... Trying with my locally modified v.db.update GRASS 7.1.svn (nc_spm_08_grass7):~ g.copy vect=precip_30ynormals,myprecip_30ynormals GRASS

Re: [GRASS-dev] How to calculate log() in v.db.update with SQLite backend?

2014-11-28 Thread Markus Neteler
Hi, On Thu, Nov 20, 2014 at 10:53 AM, Markus Neteler nete...@osgeo.org wrote: ... Trying with my locally modified v.db.update GRASS 7.1.svn (nc_spm_08_grass7):~ g.copy vect=precip_30ynormals,myprecip_30ynormals GRASS 7.1.svn (nc_spm_08_grass7):~ v.db.addcolumn myprecip_30ynormals

Re: [GRASS-dev] How to calculate log() in v.db.update with SQLite backend?

2014-11-20 Thread Moritz Lennert
On 20/11/14 08:46, Moritz Lennert wrote: On 19/11/14 19:12, Vaclav Petras wrote: On Wed, Nov 19, 2014 at 12:59 PM, Markus Neteler nete...@osgeo.org mailto:nete...@osgeo.org wrote: DBMI-SQLite driver error: Error in sqlite3_step(): not authorized ERROR: Error while executing:

Re: [GRASS-dev] How to calculate log() in v.db.update with SQLite backend?

2014-11-20 Thread Markus Neteler
Congrats, Moritz. On Thu, Nov 20, 2014 at 9:22 AM, Moritz Lennert mlenn...@club.worldonline.be wrote: Below is a proposal after a very superficial reading of the docs and code, so no guarantees (and I cannot really test here since it seems enabled by default). However, this means that we

Re: [GRASS-dev] How to calculate log() in v.db.update with SQLite backend?

2014-11-19 Thread Moritz Lennert
On 18/11/14 22:34, Markus Neteler wrote: Hi, playing around with the Meuse dataset about soil contamination I attempted to calculate that right away but...: v.db.update meuse_voronoi column=logzinc qcolumn=log(zinc) DBMI-SQLite driver error: Error in sqlite3_prepare(): no such function: log

Re: [GRASS-dev] How to calculate log() in v.db.update with SQLite backend?

2014-11-19 Thread Markus Neteler
On Wed, Nov 19, 2014 at 1:13 PM, Moritz Lennert mlenn...@club.worldonline.be wrote: ... No, since version 3.6 you can compile the extension as a shared library and then activate it: $ gcc -fPIC -lm -shared extension-functions.c -o libsqlitefunctions.so $ sqlite3 test.db SQLite version

Re: [GRASS-dev] How to calculate log() in v.db.update with SQLite backend?

2014-11-19 Thread Moritz Lennert
On 19/11/14 18:59, Markus Neteler wrote: On Wed, Nov 19, 2014 at 1:13 PM, Moritz Lennert mlenn...@club.worldonline.be wrote: ... No, since version 3.6 you can compile the extension as a shared library and then activate it: $ gcc -fPIC -lm -shared extension-functions.c -o libsqlitefunctions.so

Re: [GRASS-dev] How to calculate log() in v.db.update with SQLite backend?

2014-11-19 Thread Moritz Lennert
On 19/11/14 19:12, Vaclav Petras wrote: On Wed, Nov 19, 2014 at 12:59 PM, Markus Neteler nete...@osgeo.org mailto:nete...@osgeo.org wrote: DBMI-SQLite driver error: Error in sqlite3_step(): not authorized ERROR: Error while executing: 'SELECT

Re: [GRASS-dev] How to calculate log() in v.db.update with SQLite backend?

2014-11-19 Thread Markus Metz
Markus Neteler wrote: Hi, playing around with the Meuse dataset about soil contamination I attempted to calculate that right away but...: v.db.update meuse_voronoi column=logzinc qcolumn=log(zinc) DBMI-SQLite driver error: Error in sqlite3_prepare(): no such function: log DBMI-SQLite

[GRASS-dev] How to calculate log() in v.db.update with SQLite backend?

2014-11-18 Thread Markus Neteler
Hi, playing around with the Meuse dataset about soil contamination I attempted to calculate that right away but...: v.db.update meuse_voronoi column=logzinc qcolumn=log(zinc) DBMI-SQLite driver error: Error in sqlite3_prepare(): no such function: log DBMI-SQLite driver error: Error in