how can I allow user to edit BUT NOT delete the records in a view?

Dear all,

Could anybody tell me that how I can allow user to edit BUT NOT delete the
records in a view?

I know there are only 3 options when opening a view:
Add (the user can add new records but can't view or edit existing records),
Edit (the user can view or edit existing records and add/delete new records),
or Read Only (the user can only view records).

The Edit mode will enable Delete command. The delete command is very
dangerous. The users may accidentally delete all the records without
receiving any warning at all. But if I choose to open the view as Read only,
then they can only read but not edit the records.

Does anybody have any idea about how to allow user to edit BUT NOT delete
the records in a view?

Thanks a lot!

.

Relevant Pages

  • Re: Access user input from command line
    ... I am trying to create a GUI with an edit box for user input ... below) in the command prompt or through other m files (I get ... % hObject handle to figure ...
    (comp.soft-sys.matlab)
  • Re: bug? cannot get value of cell on invisible column
    ... I just didnt want it to be editable when the EDIT button was selected based on previous experience with Borland C++ where editing or renameing a key required it to be propagated to all the tables. ... I mentioned that the same problem show up in postgreseql but I cannot find my comment anywhere and suspect they ignore closed cases. ... Then I made the column visible but the field readonly and that caused the sql "update" command to fail as the update command skipped over that "id" field and put "authString" where id was supposed to go causing an exception on the sqlserver. ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
  • "edit" function in cmd Windows XP SP3
    ... One or more CON code pages invalid for given keyboard code ... The KEYB command examined all prepared code pages, ... When trying to edit text using the "edit" command all text is coming out as ...
    (microsoft.public.windowsxp.general)
  • Re: Launching EQW on a 48
    ... Do you mean to display (and edit) an existing algebraic, ... to add an EDITB command to an old "48" ... "ViewLevel1" is not phased by any object type, ...
    (comp.sys.hp48)
  • Re: [SLE] MySQL Table Locked?
    ... I tried to edit the table again, ... Run this command from the commandline as root: ... I'll describe the basic structure of my database, ... >> Check the headers for your unsubscription address ...
    (SuSE)