Jay, >It's important that the journal file be preserved between reboots. >If the power fails you can then recover the database using the journal. >If your code has to go on one of the linuxes(linuxii??) >that follow posix/LSG standards you'll want to know how to make >it work correctly on those machines.
That makes perfect sence. So you'd want sqlite to use /var/tmp. The question still remains why one needs to read the contents of the dir. Why not just try to create (as opposed to open) a file using fopen and then if it fails because the file already exists, just increment the filename until you get a filename that's not in use? Respectfully, Christopher