>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')
setdeletedoffifseek(MyValue, 'MyTable','MyField')
ifdeleted()
=messagebox("Record exists and it was deleted")
else
=messagebox("Record exists")
endifendifsetdeleted &lcDeleted