>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 && This will loop through all the records in the table to the Eof()
>    if mytable.field1=this 
>      do some stuff && this will run if the 'IF' condition is true
>    else
>      do nothing && This will run if the 'IF' condition is false
>    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.