072908 Thank You MikeB! Found it. I believe I can make a great attempt at the MS Jet Driver. ;) at least 20 times.
Sincerely, Paul Dewey -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MikeB Sent: Monday, September 21, 2009 3:30 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Temp Table and RFF or use a text file if the dataset isn't too large and use the Microsoft Jet driver to connect to it. I put something up here last year for Claudine about it, but probably the dbase file is the least trouble to do. ----- Original Message ----- From: "Paul InterlockInfo" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Monday, September 21, 2009 2:54 PM 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 > > > > > > > > > > > > > >
