set delete with views


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: set delete with views

  1. #1
    CJ CraigMoore'DSIgroup.com Guest

    set delete with views


    Hi all,

    I have a view that comes from two related table on a database. i want to
    be able to mark one of the base table for deletion and requery the view to
    to remove the marked records, however when ever i try this i still get all
    records in my view(i have got set dele on), i have tried trying this with
    a new view and it does remove the marked records, i have got a filter on
    the view. can anyone tell me why i am still getting the marked records in
    my view, i know thaat any kind of index command ignores dele marks, but is
    there something similar for views.

    many thanks,

    CJ

  2. #2
    Anders Altberg Guest

    Re: set delete with views

    Hi
    You will not see the modifications until after a TableUpdate(1, .T.,
    'viewname') call. If the data is in a grid it's likely even table buffered.
    -Anders

    <CJ CraigMoore'DSIgroup.com> wrote in message news:3b8f9fdf@news.devx.com...
    >
    > Hi all,
    >
    > I have a view that comes from two related table on a database. i want to
    > be able to mark one of the base table for deletion and requery the view to
    > to remove the marked records, however when ever i try this i still get all
    > records in my view(i have got set dele on), i have tried trying this with
    > a new view and it does remove the marked records, i have got a filter on
    > the view. can anyone tell me why i am still getting the marked records in
    > my view, i know thaat any kind of index command ignores dele marks, but is
    > there something similar for views.
    >
    > many thanks,
    >
    > CJ



  3. #3
    CJ Guest

    Re: set delete with views


    Thanks Anders,
    I worked out what was going wrong, i was still getting the marked records
    even once i had issued the tableupdate command. i was setting dele on in
    my main prog, but when stepping throught i noticed that when i launched one
    of my forms the set dele was being set back to off. the form had a private
    data session, sorry for wasting your time. i will try not to be so stupid
    next time.

    many thanks,

    Craig

    "Anders Altberg" <anders.altberg@swipnet.se> wrote:
    >Hi
    >You will not see the modifications until after a TableUpdate(1, .T.,
    >'viewname') call. If the data is in a grid it's likely even table buffered.
    >-Anders
    >
    ><CJ CraigMoore'DSIgroup.com> wrote in message news:3b8f9fdf@news.devx.com...
    >>
    >> Hi all,
    >>
    >> I have a view that comes from two related table on a database. i want

    to
    >> be able to mark one of the base table for deletion and requery the view

    to
    >> to remove the marked records, however when ever i try this i still get

    all
    >> records in my view(i have got set dele on), i have tried trying this with
    >> a new view and it does remove the marked records, i have got a filter

    on
    >> the view. can anyone tell me why i am still getting the marked records

    in
    >> my view, i know thaat any kind of index command ignores dele marks, but

    is
    >> there something similar for views.
    >>
    >> many thanks,
    >>
    >> CJ

    >



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