>I Have A Stock Master File. When I Run A Form For Sale For A Particular Stock I Don't Want To Allow The User To Append A record in that Sale Transaction Table. I Have Used The Insert Trigger On Sales Table Which Checks Whether There Are Records Existing in the Stock Master. If There Are No records It Does Not Allow To Append The Record Through A Statement called "Return .F." In The Trigger.This Command Displays A VFP Message "Trigger Failed". How Do I Avoid This Message.Can I Use TableUpdate Or Tablerevert Or Rollback Commands And If Yes How?? My Tables Have Buffer Mode Override Property Set To 5.
>
>can AnyBody Help Me??
Triggers will not be avoided firing once the actual event is being done i.e. INSERT, UPDATE, DELETE. DELETE the trigger if you want to avoid it firing.
Better handle the checking of existing of records in a separate procedure or custom method property if you are not yet accustomed with TRIGGERS.
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."