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
