>Thanks, Bob. But I think I'm going abandon this experiment in mid-hatch! I'll have to mull it over a bit more.
>
>...snip
>>How about adding a call to a function from the rule off all the fields.
>...snip
Hi all!
Beware when will trigger fire!
Insert Trigger:
Insert-SQL, Append Blank, Recall RecordUpdate Trigger:
Update Some field, Update all fields after Append BlankDelete Trigger:
Delete RecordIf you use Append blank in your application, handle Update Trigger and check
All the OldVar() to know is it a Fresh Add Record or update old record!
else you need to take care Recall Record or Blank record problem for Insert-SQL!
For your reference, go to file section and download WorkLog V1.10 to see... ^-^;
p.s. Remind you that you need to pay more attention on trigger coding.
if any error occurs, you can't make change on table! (All Reverted!!)
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.