>The Hackers Guide has very little (according to the index) and on-line help doesn't give a lot of help on triggers. So either they've been left out on purpose, or their just not very important. Can someone tell me about them? Like, on an update, does the trigger get fired for the current field every field, once or every time? Anything you could tell me would be usefull.

---

Hi all! Try Worklog V1.10 in File section!
It can handle those Update, Insert, Delete Trigger!

General Speak, trigger properties:
- only fired when you Leave the Record Or delete Mark has changed!
- a setting on Table definition

Don't mix with field validation, it will be fired when leave the field!!

On Summary, there is different case on different Trigger occur:

Update Trigger
- First Time Update after Append Blank (All field from blank to value..) I suggest to make a name "Add" for it
- Update Exist Record for some field value, I suggest the Trigger Log only take notes on change value for field

Insert Trigger
- Gain Record by using Insert-SQL
- Recall Record from Unmark deleted record

Delete Trigger
- Mark Record to Delete

To seperate what action does user act, worklog has checked all the cases for you.

You can download it and try the demo, you can take any action on browse window and
how you action make the Trigger fired!

---

Now, I tell you a Serious thing, if there is any error occur on trigger nor field validation,
you can go away or update table!!

Make sure you got 100% error free on Trigger procedure, otherwise don't use the trigger.. ~_~