Query on View

[Anu]

Hi all,


Is it possible to have a view,which does some validation say,it checks
for budgetamount>$100000 in BudgetMaster table and doesnot allow the user
to order anything if he exceeds that amount.If Yes,then how to do it?


Regards,
Anu

[Rune Bivrin]

Create the view and add WITH CHECK OPTION. That's supposed to work, though
I've never used it.

--
Rune Bivrin
- OOP since 1989
- SQL Server since 1990
- VB since 1991


"Anu" <anu@email.com> wrote in news:3df1cbeb$1@tnews.web.devx.com:

>
> Hi all,
>
>
> Is it possible to have a view,which does some validation say,it
> checks
> for budgetamount>$100000 in BudgetMaster table and doesnot allow the
> user to order anything if he exceeds that amount.If Yes,then how to do
> it?
>
>
> Regards,
> Anu
>