On Sun, 3 Jul 2005, Lorne wrote: > I did some experimenting. I opened the Temp folder and watched what happens > as one opens and closes tables, executes queries, etc. Temporary work files > are opened that incrementally number upwards. Let's say temp file > ~MAP0123.tmp is the highest number open. Close every table. File > ~MAP0123.tmp and any others disappear. Open a new table and work with it.
What does "work with it" mean? I tried to write a MapBasic (ver 7.8) scrapplication to test this claim and couldn't get a ~map*.tmp file to form. I opened a table, and then in a loop I made a selection into a QueryN table, picked a record, printed its value then closed the file and continued the loop for 10,000 times. No crash, no ~map*.tmp files. I have seen these temporary files appear from time to time, but I don't know what conditions trigger their creation. I can understand why the system would fail when the file names exceed the old (old, old) DOS 8.3 format. This decision made sense in 1985 -- you couldn't create a file name bigger than 8 charcters long, and you could never be sure that one or more earlier temp files weren't still open (and if they were, reusing numbers while skipping these makes the algorithm messy), plus, in those days, no one would ever have the time to open 10,000 temporary files anyway, let alone keeping Windows running that long... If what you say is true, then this error is a classic programming error. That is, the programmer deals with a situation that is possible and not supportable by just making its occurance less probable. - Bill Thoen --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 17019
