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, but it
could not open the database with the existing code.
Querying my database is fine for standard queries, but any query to the
rtree index causes the app to crash. The code used is below (VB I'm afraid),
and when the first CommandText is run a list of tables includes the
idx_Locale_Geometry, but when the second is run (test query, I have tried
others) the app crashes with a message 'The remote connection to the device
has been lost. Please verify the device connection and restart debugging'
Dim dbDataReader As SQLiteDataReader = Nothing
Dim cmd As SQLiteCommand = m_Connection.CreateCommand()
'cmd.CommandText = "SELECT name FROM sqlite_master WHERE
type='table'"
cmd.CommandText = "SELECT * FROM idx_Locale_Geometry "
Try
dbDataReader = cmd.ExecuteReader()
Catch ex as Exception
End Try
If dbDataReader.HasRows() Then
While dbDataReader.Read()
'Get data
End While
Else
Throw New Exception("No data")
End If
The crash is at ExecuteReader() and does not throw an exception and the call
stack clears. A break point at the catch clause is never triggered so I'm
not sure how to find the error. I might have to catch it on the device but
I'm not sure how to do that.
Thanks for your help
Duncan
--
View this message in context:
http://sqlite.1065341.n5.nabble.com/Re-System-Data-SQLite-for-Pocket-PC-RTREE-tp80344p80403.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
