cursor indexes 3

[redzombi19]

ok this my be a bit of an ignorant question but how do you create an index with the cursor?
thanks!

 

[Mike Gagnon]

select * from myTable into cursor myCursor
INDEX on custnum tag custnum

Note cursor can only have one index.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[jimoo]

It's not a stupid question.

INDEX on myField TO myIndex

Should create an independent idx file named myIndex.idx

Since the cursor is a VFP temp file and the idx is not, you must delete the idx file when you are done:

DELETE FILE myIndex.idx

Jim Osieczonek
Delta Business Group, LLC

http://www.deltabg.com

 

[jimoo]

Mike, you must have submitted just before I did.

One note on your post though - the cursor can only have one index per idx file, but you can open the table with several indexes. Kind of like the way we had to do it in Dbase III+

Jim Osieczonek
Delta Business Group, LLC

http://www.deltabg.com

 

[redzombi19]

thanks, Mike & Jim

that did just what i needed (i knew it would be something simple like that!)
but now i cant find whare the index file is to delete it, is it in the default directory, or what?

thanks again!

 

[craigsboyd]

redzombi19,

There is no need to delete the IDX file, since you created it on a temporary cursor VFP handles the deleting of the IDX for you. You are correct however, the idx file is created in the default directory unless you specify otherwise.

Slighthaze = NULL
[sub]craig1442@mchsi.com[/sub][sup]

"Whom computers would destroy, they must first drive mad." - Anon​

[/sup]

 

[redzombi19]

Cool thanks slighthaze