When issuing PRAGMAS, do they have to be issued from sqlite executable
or can they also be issued via the Tcl API?
Pragmas can be executed via the Tcl API, because they are a part of
SQLite's SQL dialect. Unlike the 'dot-commands' that are only available
in the shell tool.
Dan.
Thanks Dan, I'll give it try
-Original Message-
From: Dan [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 06, 2007 5:06 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] unable to open a temporary database file for
storing temporary tables
When issuing PRAGMAS, do they have to
This is my first post. I thought I had osted yesterday but do not see
it so forgive me if this is a duplicate.
I have seen the error malformed database schema - unable to open a
temporary database file for storing temporary tables discussed in
another thread relative to PHP and BSD Unix.
Regarding the DOS-like name, it may be the canonical name on Windows
for FAT/VFAT file systems. Is that what you're using?
I wonder if there's a hash collision in trying to get the file name
down to DOS 8.3 file name format.
Do you have many sqlite_* files in that directory?
Since the file
Thanks for the response.
I have finally been able to look at the system where this is running.
You are correct. They are on an older system (2.8.17). I'll try to get
them to update.
They are using 3 different databases. When I issue a .databases command
I see that all three are using the same
