At 09:29 AM 2/26/2015, Dennis McGrath wrote:
I just did this test
CONN LocalDB
SELECT * FROM AnyTable
DISC
CONN LocalDB
SELECT * FROM AnyTable
DISC
CONN LocalDB
SELECT * FROM AnyTable
DISC
CONN LocalDB
SELECT * FROM AnyTable
DISC
CONN LocalDB
SELECT * FROM AnyTable
DISC
5 $$$ files left behind
Nice!
Now put the following code in your application exit procedure and move on.
SET ERROR MESSAGE 2077 OFF
DELETE *.$$$
SET ERROR MESSAGE 2077 ON
Make sure to include the correct DEFAULT/SCRATCH folder for .$$$ files.
That should take care of all your left over .$$$ scratch file(s).
Should you require further assistance, send your request to [email protected]
Very Best R:egards,
Razzak
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of Dennis
> McGrath
> Sent: Thursday, February 26, 2015 8:22 AM
> To: RBASE-L Mailing List
> Subject: [RBASE-L] - Re: Oterro $$$ files
>
> Razzak,
>
> We saw this happen with an sattached database.
> We did a select from the sattached table and the $$$ file showed up as
> expected.
> We then exited rbase, and the $$$ file created by Oterro was left behind.
> We can do this consistently.
> Perhaps R:BASE is not informing Oterro that it is done with the connection.
>
> Dennis McGrath
>
> > -----Original Message-----
> > From: [email protected] [mailto:[email protected]] On Behalf Of A.
> > Razzak Memon
> > Sent: Wednesday, February 25, 2015 5:08 PM
> > To: RBASE-L Mailing List
> > Subject: [RBASE-L] - Re: Oterro $$$ files
> >
> > At 04:54 PM 2/25/2015, Dennis McGrath wrote:
> >
> > >Oterro has a habit of leaving $$$ files after it is done.
> >
> > Not if all sessions are closed and disconnected properly.
> >
> > >Is there any way to tell it to clean up after itself?
> >
> > I suggest to create a maintenance script to run as Task Scheduler to
> > clear all .$$$ accordingly.
> >
> > That's how we maintain & support our corporate and government clients
> > who run very complex and mission critical R:BASE applications involving
> > Oterro 9.5 (64), even in a MS Cloud environment.
> >
> > Very Best R:egards,
> >
> > Razzak.
> >
> > www.rbase.com
> > www.facebook.com/rbase
> > --
> > 32 years of continuous innovation!
> > 17 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
> > --
> >
> > --- RBASE-L
> > ================================================
> > TO POST A MESSAGE TO ALL MEMBERS:
> > Send a plain text email to [email protected]
> >
> > (Don't use any of these words as your Subject:
> > INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
> > REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
> > ================================================
> > TO SEE MESSAGE POSTING GUIDELINES:
> > Send a plain text email to [email protected]
> > In the message SUBJECT, put just one word: INTRO
> > ================================================
> > TO UNSUBSCRIBE:
> > Send a plain text email to [email protected]
> > In the message SUBJECT, put just one word: UNSUBSCRIBE
> > ================================================
> > TO SEARCH ARCHIVES:
> > Send a plain text email to [email protected]
> > In the message SUBJECT, put just one word: SEARCH-n
> > (where n is the number of days). In the message body,
> > place any
> > text to search for.
> > ================================================
> >
>
