If you use the following in a startup command (eep,dat,rmd, ....)
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
Is it better to use SCRATCH C:\TMP or better SET SCRATCH TMP This is in a
multi user database.
I also assume that this over rides the cfg settings? Let's assume that you
have SET SCRATCH OFF and then execute your eep/dat/rmd .... Then your SET
SCRATCH now becomes your choice from your code?
It, is what I always assumed. Today and yesterday have made me question a
lot. Soooooo I hate the word assume.
(I assumed that when I sold a car to an employee he transferred the title,
when he then sold the car 2 months ago - HE assumed the next person
transferred the title! Today I have a ticket from the car I sold 2 years
ago. Nobody transferred any title - it was still in my name! Want to talk
about assume!)
Paul Dewey -
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Fred C Kopp
Sent: Tuesday, January 29, 2008 1:06 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Disk error
Razzak,
I don't always comprehend what's going on behind the scenes, but ever since
I SET SCRATCH TMP I have not had the error!!! Thank you! It does wonders
for my confidence. Now I can keep having fun!
Fred
----- Original Message -----
From: "A. Razzak Memon" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Monday, January 28, 2008 10:10 PM
Subject: [RBASE-L] - Re: Disk error
> At 09:08 PM 1/28/2008, Fred C Kopp wrote:
>
>>I continue to get
>>ERROR - Disk problems - Please check disk and files (2036)
>>on not one but two computers, particularly when I'm designing
>>forms. My database is clean as a whistle. What could cause this
>>on two separate computers?
>
> Fred,
>
> A question and a few suggestions:
>
> Question:
>
> While in form designer, is this behavior specific to a particular
> form or all forms?
>
> Suggestions:
>
> 01.
>
> Make sure that all global variables are pre-defined with correct
> data types. You may do so by pre-defining all global variables as
> "On Before Design Action".
>
> Form Designer | Main Menu | Layout | On Before Design Action...
>
> 02.
>
> Check the SCRATCH settings on both computers.
>
> SHOW SCRATCH at the R> prompt should reveal the current scratch
> settings for R:BASE session.
>
> FYI, the SCRATCH setting allows the current R:BASE session to
> store all temporary sort files on the drive and directory based
> on the SCRATCH setting.
>
> Syntax: SET SCRATCH <value>
>
> Supported values: ON, OFF, TMP, or <fullpath>
>
> SET SCRATCH ON will store temporary sort files on the database
> drive and directory.
>
> SET SCRATCH OFF will store temporary files on the current drive
> and directory.
>
> SET SCRATCH TMP will store temporary files in Windows' User
> Environment TMP folder.
>
> SET SCRATCH <fullpath> will provide the path to the location
> where temporary files could be stored.
>
> By default, the R:BASE/OTERRO configuration files, such as
> RBEngine.CFG, RBEngine75.CFG, RBEngine76.CFG, RBEngine8.CFG,
> OTERRO.CFG, OTERRO35, OTERRO8.CFG, and RBASE76.CFG) include
> the keyword TMP for the SCRATCH setting. Using the typical
> installation option of R:BASE or OTERRO the appropriate
> configuration file is installed in the "Windows" folder.
>
> The default keyword (TMP) allows R:BASE or Oterro sessions to
> use the Windows' User Environment TMP Variable setting for
> SCRATCH files on startup. This will also eliminate all issues
> related to setting the SCRATCH directory and related files.
> This default setting also enables R:BASE/OTERRO to write scratch
> files without being concerned about read, write, and delete
> permissions on the network/local folders.
>
> To take advantage of this setting, use the option "SCRATCH TMP"
> in the appropriate R:BASE and OTERRO configuration files or use
> the "SET SCRATCH TMP" command in your application startup files.
>
> Did you know that you can use "SET SCRATCH TMP" command at the
> R> prompt or in your application startup file?
>
> Using the latest updates of R:BASE 7.6, C/S:I 7.6 and Turbo V-8
> for Windows, you can. Previously, "TMP" option could only be
> used in the configuration (.CFG) files.
>
> You can also use the enhanced Settings option of the Database
> Explorer to define SCRATCH settings.
>
> Database Explorer|Main Menu|Settings|Configuration Settings...
> Miscellaneous | SCRATCH
>
> Hope that helps!
>
> Very Best R:egards,
>
> Razzak.
>
> P.S.
> Make sure that you are using the latest updates of RBG76/RBG8.
> http://www.rupdates.com
> http://www.rupdates.com/authorizeddevelopers/
>
>
