So, is this better than SET SCRATCH TMP? Marc
Example 02: -- AppStartupFile.DAT DISCONNECT 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 ERASE C:\TEMP\*.$$$ SET ERROR MESSAGE 2926 ON SET ERROR MESSAGE 2262 ON CONNECT dbname IDENTIFIED BY userid password QUIT TO YourAppMainMenu.RMD RETURN This technique allows you to define your own R:BASE SCRATCH directory as well as the freedom of reading, writing and deleting scratch files on the local workstation without being concerned about the user rights and allocated space on the network or mapped drive, when working in a multi-user environment. Using this technique, you are also aware of the exact location of R:BASE Scratch files for manually cleaning the TEMP directory on local hard drive. Very Best R:egards,Razzak.
