I think the only way for doing this is via triggers.
You have to implement a BEFORE UPDATE and a BEFORE DELETE trigger on that table.
Georg
Nick Chan wrote:
hi
is there a way to make data in a field read-only after first time being added/set ?
thanks
-- Georg Thom� IEE Luxembourg S.A. IT dept. / software development / DB-administation tel. 00352/7289896810 fax 00352/7289896109 www.iee.lu / [EMAIL PROTECTED]
This e-mail may contain trade secrets or privileged, undisclosed or otherwise confidential information. If you are not the intended recipient and have received this e-mail in error, you are hereby notified that any review, copying or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal from your system. Thank you for your co-operation.
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
