OK. Embarassing as it is, I'm going to have to 'fess up here.
When I attempted to implement a stopwatch which wasn't available, I
discovered that the app was targetting .Net 2. When I rebuilt it targetting
3.5 it worked.
Unfortunately the stopwatch tells me that it takes longer than I would like
Duncan Hall wrote:
>
> I'm not using the Spatialite extension for the query, only the indexes
> created by it on the desktop which I think is a pretty standard SQLite
> RTree. At least it works that way on the desktop.
>
So, on the target device, only the System.Data.SQLite binaries are being
> Thanks. I've run the schema and query here with the desktop version of
> SpatiaLite and it does not crash. I suspect the underlying issue may be
> an alignment fault (or stack overflow) due to bad interaction between the
> ARM processor architecture and the SpatiaLite extension.
I'm not
Duncan Hall wrote:
>
> The db was created by Spatialite and has a fairly lengthy schema. I'm not
> sure if I should leave anything out so I'll attach a text file.
>
Thanks. I've run the schema and query here with the desktop version of
SpatiaLite and it does not crash. I suspect the
Joe Mistachkin-3 wrote
> Are you able to share the schema for your database? It may be helpful.
The db was created by Spatialite and has a fairly lengthy schema. I'm not
sure if I should leave anything out so I'll attach a text file.
schema.txt
Duncan Hall wrote:
>
> 'cmd.CommandText = "SELECT name FROM sqlite_master WHERE type='table'"
> cmd.CommandText = "SELECT * FROM idx_Locale_Geometry "
>
Are you able to share the schema for your database? It may be helpful.
--
Joe Mistachkin
___
Thanks for the response
I'm developing for a Mobile 5 or 6 device in Visual Studio 2008.
I'm porting a project that works fine on the desktop in VS 2012.
I have tried the most recent release 1.094 and also 1.095 pre release. I
also tried with an old version 1.082 which is working in another app,
Green Fields wrote:
>
> I realise that Windows Mobile 6 is not well supported any more, but can
> anyone help with some insight of what may be causing this to occur on the
> Mobile and not the desktop?
>
It is supported. However, I've been unable to reproduce the issue that you
describe here
Hi
I have investigated this problem further and it appears that RTree is
definitely enabled, most queries work fine, but a query to the index fails.
I have tried a straight query to the index
SELECT * FROM idxNetwork WHERE ROWID = 1, which fails crashing the app at
command.ExecuteReader()
Hi
I hope this message doesn't double up but the last one did not appear to
make it.
I'm new to the list and newish to SQLite and would appreciate some tips.
I'm attempting to create an application that requires a spatial rtree query,
and this works extremely well using the x86 version of
Hi
I'm new to the list and newish to SQLite and would appreciate some tips.
I'm attempting to create an application that requires a spatial rtree query,
and this works extremely well using the x86 version of the
System.Data.SQLite library
11 matches
Mail list logo