>Hi,
> I am having trigger to retrict user from deleting parent records if it's child records exist in table. I found that, VFP will generate run time error if I delete the parent record using DELETE-SQL even I use TABLE BUFFERING -5 for the these tables.
>
>Why?
>
>Thank you

If tables are buffered, triggers shouldn't fire until you issue a tableupdate(). Are you sure of the buffering of these tables? How are you setting the buffering? In the DE or programmatically?

BTW, what's the error? If it's Trigger Failed (Error 1539) that's what's supposed to happen. If its anything else, you have another problem.