main logo
Subject: RE: Location of Cursors
Author: Cotton Mr Jerry P
Posted: 2002/12/30 15:00:00
 
View Entire Thread
New Search


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
<-- Prior Message New Search Next Message -->