>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.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao