main logo
Subject: Location of Cursors
Author: "Compsys"
Posted: 2002/12/30 15:36:00
 
View Entire Thread
New Search


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.=20
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.=20

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.=20
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
---



 
©2002 Compsys
<-- Prior Message New Search Next Message -->