>>>how to check if record is already exist.in numarci and character
>>
>>Do you have an Index on each field?
>>
>>you may want to do
>>local lcDeleted
>>lcDeleted = set('deleted')
>>set deleted off
>>if seek(MyValue, 'MyTable','MyField')
>> if deleted()
>> =messagebox("Record exists and it was deleted")
>> else
>> =messagebox("Record exists")
>> endif
>>endif
>>set deleted &lcDeleted
>
>Naomi
>
>I use INDEXSEEK(). with lMovePointer = .F. That way you don't need to lerave the record you're on. (or KEYMATCH())
True.
If it's not broken, fix it until it is.
My Blog