General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Michelle,
... provided you are on the source table to search...
lfound=INDEXSEEK(whatIwant, .T.)
IF lfound
.... get the file stuff you want... the record pointer has moved there...
ENDIF
See HELP for INDEXSEEK()
HTH
Ric
>I have a cursor that contains every directory on my hard drive. Given a path, I need to find the record. Even taking a chance by limiting the field to 240 characters so I can SEEK instead of LOCATE, it's still unacceptably slow.
>
>I'm wondering if it's possible to make it faster. I thought about making a smaller key field that takes the full path and condenses it into something smaller. There are a couple problems with that, though. First, I don't have any idea how to change the path into something smaller that will still be unique. Second, whatever function does the conversion, plus the SEEK after needs to be faster than just SEEKing on the path.
>
>Anyone have any suggestions?
>
>Thanks,
>
>Michelle
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only