My guess is that very few people care about this problem, but on the "Classic" versions of Mac OS (basically 8 and 9), you can't have file names longer than 31 characters. This becomes a problem when you have a database file name that is very long, but not longer than 31 characters. When you try to update such a database file, SQLite needs to create a journal file and it does that by creating a new file with the name of the database file plus "-journal", which can end up exceeding the 31 character limit. In that case, the journal file fails to be created and the entire update procedure fails as well. I don't know what the solution to this is. One idea I had was to conditionally shorten the journal file's suffix to simply "-j".
I ran into that problem too, and changed "journal" to "jrnl". Haven't had any problem with it.
Note that in certain cases, SQLite also adds 20 random characters to the file name. I changed it to use 10.
By the way, it is possible that you can have this problem on Mac OS X, if someone has a hard drive formatted with the old "Mac OS Standard" file system.
--
James W. Walker, ScriptPerfection Enterprises, Inc.
<http://www.write-brain.com/>
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
