When a row is created in [person] I want to trigger a stored procedure to take update another table [userlog] with the contents of a note field that is being inserted to person table.
My goal is to update a user log table with username and description of what that user is doing to the data. I figure triggers would be an easy way to do this but there is not much I can find in help files to show me how to do this. I think I can figure out how to Alter the table to create the trigger. but I dont know how to go about writing the syntaxs for the storedProcedure. Is it anything like PL/SQL?
CREATE PROC foo() AS --declare stuff; BEGIN --do stuuf; END;
???
help please!
--- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [EMAIL PROTECTED]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE: Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body, place any text to search for.
================================================
