Graham
Take a look at TMPFILES in the Help File. By using the CONFIG.FPW file you can control where your temporary files are located.
Jerry Cotton, MCP <mailto:cottonjp .at. 2mawcp .D.O.T usmc.mil> (252)466-4854 fax (252)466-4806 DSN-582
> -----Original Message----- > From: Compsys [mailto:gbrown@compsys.co.uk] > Sent: Monday, December 30, 2002 3:10 PM > To: profox .at. leafe .D.O.T com > Subject: Location of Cursors > > > Hi all > > Sorry it is an evening for daft questions!! > > Does sys(2023) determine where a cursor is going to be > physically located (if it cannot be held in memory)? > What I currently do is generate a temporary filename and > Select xyz from table1 into table &lcTempFileName. > Means I have loads of temporary dbf files to housekeep. The > answer appears to be cursors however I want to ensure that > they are being created on the local c: drive and not in the > application folder. > > Also I was always under the impression that cursors only > persist til the end of the procedure that created them, hence > the reason I have never used them. As I have just created a > form that generates a cursor on one button and reports from > it on another this blows my theory out the window. > What is the visibility of a cursor and do I have expressly > have to destroy it with "Use in &lcTempFileName"? > > Regards > > Graham > > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server]
©2002 Cotton Mr Jerry P |