>>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 must stop writing messages when my mind is elsewhere.
lcText=thisform.txtsno.value
DELETE FROM syllabus WHERE syllabus.sno == lcText
>
>
>>>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>