My Two cents - if you use seek - a little more code, granted - you wll not hog resourse or pump the temp files folder.

Your app will behave better - look crisper - and in these lean times - it's all about efficiency.

As often as you can (I know select is convienent), use functions that do not cache data your app has a hard cache point to.

>I am trying to gain a better understanding of what happens with SELECT INTO CURSOR. If I issue a command such as

>select * from somefile into cursor crsTemp
>

>
>It appears that the original file (somefile) is opened by the OS although it is not technically USED. Is this correct? If yes, then what do we have to do to close the file so that it is available to other programs or so that it can be overwritten? I have tried to
>

>use in crsTemp
>copy to somefile
>

>but I still get an error that says the file is open. Can someone shed some light on this?
>
>Thanks