Muharrem Bilgin wrote:
>
> The following are the log entries, which confirm your suspicion (the log
> entry format : time, error description, error code).
>
Agreed.
>
> As suggested, we are already setting the temp store directory as soon as
a
> database connection is opened (after sqlite3_open16). Now, the question is
> when to use the "PRAGMA temp_store_directory='...';". Do we have to call
it
> as a specific time ? (i.e. every time before executing a SELECT
statement?)
>
Since you are not using the wrapper, you should probably just call the
necessary
SQLite C API directly:
int sqlite3_win32_set_directory(DWORD type, LPCWSTR zValue);
The first argument should be 2 in order to set the temporary directory.
The second argument should be the UTF-16 string containing the fully
qualified path to use.
Ideally, the temporary directory should be set prior to the first database
connection being opened.
--
Joe Mistachkin
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
