Re: [SQL] Auto-update a field when record is changed

2003-08-24 Thread Jamie Lawrence
> On Fri, 22 Aug 2003, Stuart wrote: > > > Folks, > > > > I was wandering if there was a feasible way to automatically update a field > > in a table, say 'revision_date' in a record whenever any other field in the > > record is changed. My attempts to use a trigger caused repeating loops and

Re: [SQL] Auto-update a field when record is changed

2003-08-22 Thread Stephan Szabo
On Fri, 22 Aug 2003, Stuart wrote: > Folks, > > I was wandering if there was a feasible way to automatically update a field > in a table, say 'revision_date' in a record whenever any other field in the > record is changed. My attempts to use a trigger caused repeating loops and > bombed wit

[SQL] Auto-update a field when record is changed

2003-08-22 Thread Stuart
Folks, I was wandering if there was a feasible way to automatically update a field in a table, say 'revision_date' in a record whenever any other field in the record is changed. My attempts to use a trigger caused repeating loops and bombed with error. I would like to be able to updat