you can just make a routine in the windows scheduler to run and delete all scratch files in the folder during night we have more than 150 users and all scratch in one location does not make the server any slower
Mohammed Sattar Dhaka, Bangladesh > On 3 Apr, 2019, at 5:59 PM, Jim Belisle <[email protected]> wrote: > > Thanks, Mohammed. At least Rmail is working. I just need to get the scratch > files in the proper location. > I think having the scratch files all together on the server would affect the > speed? > > James Belisle > > Making Information Systems People Friendly Since 1990 > <image001.jpg> > > From: [email protected] <mailto:[email protected]> > [mailto:[email protected] <mailto:[email protected]>] On Behalf > Of MOHAMMED SATTAR > Sent: Wednesday, April 3, 2019 6:57 AM > To: [email protected] <mailto:[email protected]> > Subject: Re: [RBASE-L] - SCRATCH setting using Rmail > > > > we have been using like the below screen shot > > > <image002.jpg> > Mohammed Sattar > Dhaka, Bangladesh > > > > > > > > > On 3 Apr, 2019, at 5:39 PM, Jim Belisle <[email protected] > <mailto:[email protected]>> wrote: > > Mohammed, > > I appreciate you trying to help. > My Windows settings are as follows. ( I am not on site but most likely all > the users are set up this way) > Under user variables > I believe both below should be the same try to > > > TEMP C:\Users\Jim\Appdata\Local\Temp TEMP c:\Temp > TMP C:\Users\Jim\Appdata\Local\Temp > > Under system variables > TEMP C:\Windows\Temp > TMP C:\Windows\TEMP > > But as I said, when I set the SCRATCH settings in the RBASE CFG file on the > server (that is where the DB is stored) to TMP, Rmail will not work. > It will only work when it is set to ON. > > If all the scratch files are on the server, I would think that would affect > the DB speed also? > I am just not having much luck with speed and with Rmail. > > James Belisle > > Making Information Systems People Friendly Since 1990 > <image001.jpg> > > From: [email protected] <mailto:[email protected]> > [mailto:[email protected] <mailto:[email protected]>] On Behalf > Of MOHAMMED SATTAR > Sent: Wednesday, April 3, 2019 2:57 AM > To: [email protected] <mailto:[email protected]> > Subject: Re: [RBASE-L] - SCRATCH setting using Rmail > > what i was trying to say is to check > go to control panel then ‘Advanced system settings” then in Environment > Variables under User variables for ( user name ) > here you can edit and put ‘TEMP' and Value ‘c:\temp” > “TMP’ value c:\Temp > and under System variables also do the same think put TEMP as c:\windows\TEMP > and again TMP as c:\windows\TMP so this way all scratch will go tom the temp > folder > > > Mohammed Sattar > Dhaka, Bangladesh > > > > > > > > > > On 2 Apr, 2019, at 7:22 PM, 'Karen Tellef' via RBASE-L > <[email protected] <mailto:[email protected]>> wrote: > > That's exactly how I construct my startup program for scratch settings > > Karen > > > > -----Original Message----- > From: Jim Belisle <[email protected] <mailto:[email protected]>> > To: [email protected] <mailto:[email protected]> > <[email protected] <mailto:[email protected]>> > Sent: Tue, Apr 2, 2019 8:05 am > Subject: RE: [RBASE-L] - SCRATCH setting using Rmail > > Mohammed, > > Are you talking about the CFG file or the DAT file? > > This is in the DAT file. > SET ERROR MESSAGE 2077 OFF > CLEAR VAR vChkFile > SET VAR vChkFile INTEGER = NULL > SET VAR vChkFile = (CHKFILE('C:\TEMP')) > IF vChkFile <> 1 THEN > MD C:\TEMP > ENDIF > SET SCRATCH C:\TEMP > SET ERROR MESSAGE 2262 OFF > SET ERROR MESSAGE 2926 OFF > SET ERROR MESSAGE 2077 OFF > ERASE C:\Temp\*.$$$ > SET ERROR MESSAGE 2926 ON > SET ERROR MESSAGE 2262 ON > SET ERROR MESSAGE 2077 ON > > James Belisle > > Making Information Systems People Friendly Since 1990 > <image001.jpg> > > From: [email protected] <mailto:[email protected]> > [mailto:[email protected] <mailto:[email protected]>] On Behalf > Of MOHAMMED SATTAR > Sent: Tuesday, April 2, 2019 6:17 AM > To: [email protected] <mailto:[email protected]> > Subject: Re: [RBASE-L] - SCRATCH setting using Rmail > > have you set the Environment Variables in the windows s “TEMP = C:\TEMP” AND > “TMP = C:\TEMP" > > Mohammed Sattar > Dhaka, Bangladesh > > > > > > > > On 2 Apr, 2019, at 4:08 PM, Jim Belisle <[email protected] > <mailto:[email protected]>> wrote: > > We are running RBASE XE with Rmail on a compiled application. > All of the proper files needed to run Rmail are located in the DB folder on > the server. > If I use the SCRATCH setting of ON rmail runs properly but all the scratch > files are located in the DB folder on the server. > I do not like that because the scratch files build up during the day and do > not clear as users open and close the application. > > If I change the SCRATCH setting to TMP, rmail will not operate at all. > We use Outlook365 as the SMTP server. > > What am I missing on the proper setup so I can use RMAIL and at the same time > have the SCRATCH files go to the users TEMP folder on their own computers? > > James Belisle > > Making Information Systems People Friendly Since 1990 > <image001.jpg> > > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <http://www.rbase.com/support/usersgroup_guidelines.php> > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. > > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <http://www.rbase.com/support/usersgroup_guidelines.php> > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <http://www.rbase.com/support/usersgroup_guidelines.php> > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. > <image001.jpg> > > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <http://www.rbase.com/support/usersgroup_guidelines.php> > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. > > > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <http://www.rbase.com/support/usersgroup_guidelines.php> > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
