[sqlite] geopoly data input options

in the documentation. Of course I can do this, but it would seem to me better to pass a blob type object. i hope someone can answer this. regards, Graham Hardman ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi

[sqlite] clarification of the .binary option of the sqlite3 command shell program.

Hi, I am curious about what this option does. It is not discussed in the documentation and my own testing with the shell program has not aided my understanding. A simple example would be nice. regards, Graham ___ sqlite-users mailing list

Re: [sqlite] geopoly data input options

) displayed the first record as the json string and the second record as a blob (ie []). The news about the change in next release is all good. Thanks again. regards, Graham On 20-10-2018 3:14 am, Richard Hipp wrote: On 10/19/18, Graham Hardman wrote: My question now is : must I always format my

Re: [sqlite] clarification of the .binary option of the sqlite3 command shell program.

thanks for that. I had forgotten about taking a look at the source code. All clear now. Graham On 20-10-2018 12:29 am, Jay Kreibich wrote: On Oct 19, 2018, at 3:30 AM, Graham Hardman wrote: Hi, I am curious about what this option does. It is not discussed in the documentation and my own

Re: [sqlite] curious discovery about geopoly module

. cheers, -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Graham Hardman Sent: Tuesday, October 30, 2018 11:49 AM To: SQLite mailing list Subject: [sqlite] curious discovery about geopoly module Hi everybody, regarding

Re: [sqlite] curious discovery about geopoly module

Hi, I have managed to get passed the first hurdle by renaming my custom library and then editing all the statements declaring functions to be imported from my custom library. My code now reports correct version and source_id values, and can create the intended geopoly tables. I am pleased

Re: [sqlite] curious discovery about geopoly module

shell and sqliteexpert. the vba module for 64 bit windows does not need the stdcall library offered on the github site. Thanks, Graham On 31-10-2018 12:13 am, Clemens Ladisch wrote: Graham Hardman wrote: SQLiteForExcel [1] https://github.com/govert/SQLiteForExcel "sqlite3.dll is a

Re: [sqlite] curious discovery about geopoly module

, Graham Hardman wrote: To clarify: I built my own versions of the library and shell using the latest amalgamation (3.25.2) specifically to test the geopoly Are you certain that the third-party tool is picking up your custom DLL? Verify by looking at the results of "SELECT sqlite_sour

[sqlite] curious discovery about geopoly module

forced to abandon testing since geopoly table could not be created- assertion documented Regards, Graham Hardman. Links: -- [1] https://github.com/govert/SQLiteForExcel ___ sqlite-users mailing list sqlite-users@mailinglists.sqlit

Re: [sqlite] curious discovery about geopoly module

Thanks for the very detailed info. I am certainly a lot wiser now! Graham On 01-11-2018 11:40 pm, R Smith wrote: On 2018/11/01 9:51 AM, Graham Hardman wrote: I am pleased about this, although still puzzled by the fact that the windows LoadLibrary call returned a non null pointer and windows

Re: [sqlite] curious discovery about geopoly module

Thanks. In my case there is no installer as such. My vba code runs inside the same process as the host cad system. In this case Bricscad has already loaded their copy of dqlite3.dll and my like-named file could not demand precedence. Graham On 02-11-2018 3:16 am, Simon Slavin wrote: On 1

[sqlite] codeblocks thing happens when using codeblocks to compile sqlite with geopoly

Hi, I have built versions of the commandline shell and the dll so as to get access to the geopoly module. My builds were done firstly using the mingW64 compiler (from the command prompt) on windows10, and then later using codeblocks. For both builds I specified the same set of compile time

Re: [sqlite] geopoly - rules re data entry

: On 11/17/18, Richard Damon wrote: On 11/17/18 8:37 PM, Graham Hardman wrote: My question then is, is it really necessary to ensure a counterclockwise order when a polygon shape is entered for the first time in the table. My guess would be that SOME operations will need the vertices

Re: [sqlite] geopoly_contains_point(P,X,Y) doc is overly modest

oh, I hope you dont do that since the application I am working on hopes to exploit the retval = 4 of geopoly_overlap ! regards, Graham On 02-12-2018 7:52 am, Richard Hipp wrote: On 12/1/18, Larry Brasfield wrote: The documentation at https://www.sqlite.org/geopoly.html , at 3.8. for

[sqlite] function named geopolyCosine is a misnomer

Hi, I was very interested in the numerical approximation used in the function named geopolyCosine and after a bit of on-line research decided to test it's accuracy myself. What I discovered was that the function in fact returns the sin value rather than the cosine value. This is quickly

[sqlite] bug: error in code for geopoly_ccw function

hi, In my posting on 20th November I supplied output from the cli buit from the snapshot that includes the new geopoly function geopoly_ccw. That output showed incorrect results being returned from an attempt to reverse the direction of a polygon in CW mode after a mirror transform of a CCW

[sqlite] geopoly - testing the snapshot code gives error in geopoly_ccw

Hi, thanks for giving access to the snapshot. I paste below output from the CLI. The pragma compile_options now works, but there is an error in the coordinates returned from applying geopoly_ccw those produced by a simple mirror about x axis. SQLite version 3.26.0 2018-11-17 14:26:45 Enter

[sqlite] geopoly - rules re data entry

Hi, The documentation for the geopoly module states that the vertices must be defined in a counter-clockwise order so that the interior of the polygon is on the left of the element as it is drawn. However, I have discovered that a polygon transformed with geopoly_xform can result in a polygon