At 02:31 PM 7/22/2008, Lawrence Lustig wrote:
I notice in your example that you SET SCRATCH when disconnect from the database. I do the same thing (scratch is set before connecting) but if, for some reason, scratch is set with the database already connected does that cause a problem?
Technically, it should not cause a problem. However, changing the SCRATCH setting in the middle of your routine or after CONNecting the database, the same R:BASE session may not find those .$$$ files that were created before changing to new SCRATCH folder. That was the exact reason of my suggested example. Very Best R:egards, Razzak.

