June 15, 2010 at 7:33 am
Hi
I am Havin two tables Metric and UpdatedMetric
if any of field from Metric table is updated then a column value must be set in UpdatedMetric Table
I want to use trigger only
plz reply
June 15, 2010 at 8:09 am
will you be providing any details? For any meaningful answer we need the CREATE TABLE definitions of both tables, and which "value" (column) triggers some change to be propigated to the other table
Lowell
June 16, 2010 at 12:09 am
all data is being saved from a grid In My metric table .
I just want to check that if a given row is updated In metric table then a trigger must be fired for the updated row and accordingly in my UpdatedMetric table i have taken a cloumn in that '1' value must be set for that cloumn.for the updated row in metric table.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply