>Remove the apostroph, and use a memvar instead of the property, it's much faster. Also make sure that that the length of the memvar matches the field length.
>

>lcText=thisform.txtsno.value
>DELETE syllabus FROM syllabus WHERE syllabus.sno == lcText

>

I haven't seen this syntax before - and I get an error (Command contains unrecognized phrase/keyword) when I try it. Until I read your reply I thought the problem was the extra keyword, not that it had quotes around it. When would you put something between DELETE and FROM?





>>I am deleting records with these codes
>>I have problem some time, if any best instead of this.thanks
>>
>>xxz = MESSAGEBOX( ;
>> "Are you sure you want to Delete Record?", ;
>> 36)
>>IF xxz = 6
>> DELETE 'syllabus' FROM syllabus ;
>> WHERE syllabus.sno == ;
>> thisform.txtsno.value
>>ENDIF