views and rules

Поиск
Список
Период
Сортировка
Искать

views and rules

От:
Nick Haw <nick.haw@operagrp.com>
Дата:
I have created the view below, I want people to only be able to update 2
fields (fldpaid and fldpaiddate) in the view. How do I go about doing this? 

Many thanks

Nick Haw

CREATE VIEW "vw_invoicerestricted" AS SELECT 
tblinvoice.fldinvoicenumber, 
tblinvoice.fldinvoicedate, 
tblinvoice.fldinvoicecompany, 
tblinvoice.fldinvoiceclient, 
tblinvoice.fldsurveynumber, 
tblinvoice.fldtheirref, 
tblinvoice.flddescription, 
tblinvoice.fldchargevat, 
tblinvoice.fldcompany, 
tblinvoice.flddivision, 
tblinvoice.fldpaid, 
tblinvoice.fldpaiddate, 
tblinvoice.fldcreditnote,
tblinvoice.fldinternalinvoice, 
tblinvoice.fldoldinvoicecompany, 
tblinvoice.fldoldinvoiceclient, 
tblinvoice.flddateadded, 
tblinvoice.flduseradded, 
tblinvoice.flddatemodified, 
tblinvoice.fldusermodified 
FROM tblinvoice WHERE (tblinvoice.fldcreditnote = 0)
FAQ