Paul, Can you use a different database to hold your temp data?
Maybe even create a new database each time; you can still use temp tables then delete the db if you want. If you need data from the temp db/table you can unload it then load into you "real" db. I'm not quite sure what you're after so ignore the above if it's way off course. Regards, Alastair. ----- Original Message ----- From: [email protected] To: RBASE-L Mailing List Sent: Monday, September 21, 2009 11:05 PM Subject: [RBASE-L] - Re: Temp Table and RFF Paul: Sounds like you just have to figure out what's more important to you. Yes, deleting and adding rows to a permanent table will make the .rb2 file grow bigger. How often does the database get reloaded? Temp tables are the perfect solution but you do have to connect the database. I can't remember your original post anymore -- did you say that you're just checking if a file exists? Can't you check for the file existence without having a database connected? Karen I was always under the impression that adding/deleting or dropping rows will over time will make the .R#1-4 grow. And I am looking at files verses rows. I may have deleted this email prior to sending (?), but awhile back I told somebody I use older laptops. They have really small drives. Not only Am I careful about db errors but I need to keep a low disk space. I will not even tell about the amount of FTP that goes on to make sure if these systems die I have the data prior to self destruction. Sincerely, Paul Dewey ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.409 / Virus Database: 270.13.111/2386 - Release Date: 09/21/09 05:51:00
