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() with no exception thrown As does SELECT * FROM idxNetwork A query to sqlite_master confirms that the index tables exist. 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? Thanks Duncan From: Green Fields [mailto:defn...@gmail.com] Sent: Sunday, 18 January 2015 3:46 PM To: 'sqlite-users@sqlite.org' Subject: System.Data.SQLite for Pocket PC & RTREE 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 the System.Data.SQLite library (sqlite-netFx40-static-binary-bundle-Win32-2010-1.0.94.0.zip). However, when I attempt to run the same query using (sqlite-netFx35-binary-PocketPC-ARM-2008-1.0.94.0.zip) in a pocketPC port, the app crashes, and I have been unable to get any feedback from the debug because the connection to the device is broken. Standard SQL queries and sqlite_version() work fine. I'm pretty sure rtree would be enabled in the cf binary looking at the source config, but I don't know of a way to check for this in the compiled binary short of running an rtree query. I am new to debugging on mobile devices so there may be a way to log the error that I'm not aware of, but so far all attempts to trap the error have failed. Does anyone have any suggestions where the problem might lie? Thanks for any help Duncan _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users