General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Expressions for a seek or locate and...
Ok, my problem is that I have to move the pointer to a certain a record
in a table depending on the values of three fields (1 numeric, 2
characters). Now, I've only used seek in cases where the expression
is very simple (just one field).
My questions are: can I use seek in this case? what would be the
expressions of the index and the seek command? If this is impossible
with seek, can I use locate instead and use an index to speed the process?
what would be the expressions for this case?
which one is faster locate or seek?
one more question, can I use locate recursively? something like this:
locate for field=var1
do while found()
if field2='ncc'
this.method_Using_LocateDoWhile_with_same_table(var2)
endif
enddo
TIA
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