I don't think so. I think your current method of either storing it in the query or with a boolean field is your best bet. What I've seen done in the past is that records get marked with a user level and there is either one or a group of users who are allowed to delete or modify those otherwise permanent records.
Wes On Fri, 03 Sep 2004 11:38:35 +0100, zzapper <[EMAIL PROTECTED]> wrote: > Hi Y'All > > Is it possible to have undeletable/unmodifiable records in a table of otherwise > modifiable & > deleteable & createable records? > > At present I do it at the Update/Delete level where I have clauses which prevent > certain records > being changed. I suppose I could also have an extra boolean field "Record Read > only", but is there > anyway to specify at the data level? > > zzapper (vim, cygwin, wiki & zsh) > -- > > vim -c ":%s%s*%CyrnfrTfcbafbeROenzSZbbyranne%|:%s)[R-T]) )Ig|:norm G1VGg?" > > http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]