Paul,
I am not sure I understand what you are saying in ... " ….. I cannot find a way to tell a temp table to stay in a db till the rff disconnects. " Are you stating that your temp table drops unexpectedly? This is of great interest to me as I am coverting to V8 and will be using the new rff forms and I make large use of timers, which have temp tables in the timer eep. I assumed that when a DB is connected by a timer eep and a temp table is created, that the table would last until the DB is disconnected. Is this not so? Can you explain in more detail what you are seeing with temp tables, rff forms and your timer. Thanks, -Bob ----- Original Message ----- From: "Paul InterlockInfo" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Monday, September 21, 2009 1:54:21 PM GMT -06:00 US/Canada Central Subject: [RBASE-L] - RE: Temp Table and RFF R-List- I have an rff form and a timer that runs within that form and runs every 10 minutes and could run days. I have a routine to create a temp table, count files, return the value in a variable and then disconnect. Because this is a rff form and the disconnect is in the form, I reconnect in the timer. I have to connect db, re-create the temp table, and count files etc….. I cannot find a way to tell a temp table to stay in a db till the rff disconnects. My question is db and future size. Do you think it would be best just to create a temp db, load the above and then delete. Or continue using the current db – re-connect, make temp table disconnect (it drops the temp!) ? Any known issues? Sincerely, Paul D
