Yes sys(2023) points to wherever you have your tempfiles setting
When you create a cursor it is read-only and when you close (use)
it, it is automatically deleted for you.
Eugene Vital
-JS IATTTWATL
-----Original Message-----
From: profox-admin .AT. leafe DO.T com [mailto:profox-admin@leafe.com] On Behalf
Of Compsys
Sent: Monday, December 30, 2002 3:10 PM
To: profox .AT. leafe DO.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 t his 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 Eugene Vital |
