Query on View


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Query on View

  1. #1
    Anu Guest

    Query on View


    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

  2. #2
    Rune Bivrin Guest

    Re: Query on View


    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
    >


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center