Question on triggers
Posted in 1994
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Triggers, Constraints & Referential Integrity
Two questions regarding triggers: 1) Do I have to special order the book on triggers? I'm quite sure that it didn't come with my engine or tools manuals. 2) Since I currently have no book, can someone tell me if the following idea is applicable to the use of triggers. I want to keep track of the date of the last change to each row in a table. I'd like to avoid programming everything in 4gl just to make sure that the date always gets updated. It seems that triggers might be just the ticket. If I could automatically trigger an update of the date field whenever a row is updated, my life would be much easier. Is this a feasible use for a trigger? If not, any suggestions would be appreciated. Setup: Front-End Back-End SCO-UNIX SCO-UNIX 4.11 Tools 5.01 On-line engine I-Net I-Star -- Dale Van Voorst voorst@dordt.edu Computer Services postmaster@dordt.edu Dordt College Sioux Center, IA 51250 (712) 722-6299