Hi Joe,
Thanks for your reply. After making that change (and also adding the
SQLite3.SetDirectory method definition itself since that too was inside an
#if) the app crashes because WP8 doesn't support the TemporaryFolder
property.
'Windows.Storage.ApplicationData.Current.TemporaryFolder' threw an
exception of type 'System.NotImplementedException'
When I replaced the use of TemporaryFolder with just LocalFolder, the line
again threw an exception, but with one I couldn't figure out how to
workaround:
System.NotSupportedException occurred
_HResult=-2146233067
_message=DllImport cannot be used on user-defined methods.
HResult=-2146233067
Message=DllImport cannot be used on user-defined methods.
Source=Dart.WinPhone8Lib
StackTrace:
at SQLite.SQLite3.SetDirectory(UInt32 directoryType, String
directoryPath)
at SQLite.SQLiteConnection..ctor(String databasePath,
SQLiteOpenFlags openFlags, Boolean storeDateTimeAsTicks)
InnerException:
I tried adding sqlite3_set_directory to the sqliteWP8.cpp file but it got
too intense for my limited C++ knowledge.
--
Andrew Arnott
"I [may] not agree with what you have to say, but I'll defend to the death
your right to say it." - S. G. Tallentyre
On Mon, Mar 10, 2014 at 10:57 PM, Joe Mistachkin <[email protected]>wrote:
>
> Andrew Arnott wrote:
> >
> > The exception raised when I send "VACUUM" as a sql statement is:
> > SQLite.SQLiteException occurred
> > _HResult=-2146233088
> > _message=SQL logic error or missing database
> > HResult=-2146233088
> > Message=SQL logic error or missing database
> > Source=Dart.WinPhone8Lib
> > StackTrace:
> > at SQLite.SQLiteCommand.ExecuteNonQuery()
> > InnerException:
> >
> > Thanks for any help you can offer!
> >
>
> In the "SQLite.cs" file, there is the following:
>
> #if NETFX_CORE
> SQLite3.SetDirectory(/*temp directory type*/2,
> Windows.Storage.ApplicationData.Current.TemporaryFolder.Path);
> #endif
>
> Can you please try removing the surrounding "#if" from this code and try it
> again?
>
> --
> Joe Mistachkin
>
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
