Hi All,
i have a table called sales.i dont want any users to modify the data inthat table for an particular period. i have given the period range in another table called saleslockperiod . now i have to create a trigger that should not allow any user to modify or update any details in sales table where billdate of sales tables fall in the saleslockperiod table.
kindly help me in regarding tho this,
thank you,
by ksk
i have a table called sales.i dont want any users to modify the data inthat table for an particular period. i have given the period range in another table called saleslockperiod . now i have to create a trigger that should not allow any user to modify or update any details in sales table where billdate of sales tables fall in the saleslockperiod table.
kindly help me in regarding tho this,
thank you,
by ksk