No alarm here please! I disconnect from the db and it is normal for a temp table to drop. That is the beauty of temp tables.
Your 8.0 is fine I have not heard of any temp table drop unexpectedly. Sincerely, Paul Dewey New Horizon Interlock Inc. New Horizon Safety Diagnostics Inc. www.interlockinfo.com Saving Lives - One Breath at A Time ™ IMPORTANT NOTICE: This electronic communication and any attachments may contain confidential information and may be legally privileged. It is intended solely for the addressee(s). Access, disclosure, copying, distribution, or reliance on any of it by anyone else is prohibited and may be a criminal offense. Please delete if obtained or received in error, and email confirmation to the sender. From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Monday, September 21, 2009 4:08 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Temp Table and RFF 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
