James,

Hi check out,

Seek()
Seek for
Locate for

You can use Locate like this

Locate for mytable.field1=this and mytable.field2=that 
    if found()
      nRecordnumber=recno()
      go nrecordnumber
      do some stuff
    else
      do nothing
    endif

Or 

Seek mytable.field1=this && If found the record pointer moves
    if mytable.field2=that
      do some stuff
    else
      do nothing
    endif

Scan for is a loop. Try this

scan
    if mytable.field1=this
      do some stuff
    else
      do nothing
    endif
endscan

Hope this helps.


>hey everyone,
>i am trying to select a dbf alias in some code i am writing. what i want it to do after i have selected it is search for a condition in the table and then point to the row where the condition is met. here is what i have so far.
>
>select alias
>scan for column condition = desired condition
>
>what i do not know how to point to the row after the condition is met. can anyone help me with this dilema? thanks.