>I just tried that and it doesn't work, any other suggestions?
>
>>>I have a table.
>>>I have a character field.
>>>I want to SEEK for the first NOT EMPTY record.
>>>Any suggestions?
>>>
>>>Thank you in advance.
>>
>>To use seek you need to index the table on the field in question. Then I believe you can do:
>>
>>seek !empty(myfield)
>>
>>you can also use locate in which case you don't need an index:
>>
>>locate for !empty(myfield)
Apparently the seek !empty(myfield) won't work. Seek is a tricky command because the expression your seeking for needs to match your index expression exactly.
Instead of seek I would use locate.
Locate for !emtpy(myfield)
Rip Ryness
International Falls, MN