I suggest an alternate solution for this problem which should be more elegant, and is already used by Apple when copying dual-fork files to a single-fork file system.
What you could do is create a subdirectory within the directory having the SQLite "main" data file that has a constant name (probably determined in os.h) like ".SQLite-journal". The journal file would then go into this subdirectory and have the same name as the main file. So we have: Normal way: 1 - ./mydatafile 2 - ./mydatafile-journal Altered way: 1 - ./mydatafile 2 - ./.SQLite-journal/mydatafile This solution would also work on file systems that are limited to 255 character names, or 8 character names, or whatever. The old Mac OS isn't the only one with a limit. Also, if future versions of SQLite wanted to add more temp files, they could add a new directory for each on less capable systems, as they would add a new suffix on more capable ones. -- Darren Duncan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]