Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Marlon Levy
  Where is Marlon Levy?
 
 Jamaica
 Marlon Levy
 To: Marcia Akins
  Where is Marcia Akins?
 Akorn
 Ohio - United States
 Marcia Akins
 Tags
Subject: RE: Optimistic row buffering with a updatable View
Thread ID: 78646 Message ID: 78676 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Thursday, October 06, 2005 7:04:13 PM         
   


> if i browse the view the record is marked for deletion but i still see it in the grid even though set deleted is on. but it refuses to update the table for deletions
>
> Make sure that SET( [DELETED] ) = [ON] in your form. if your form is running in a private data session, you need to make sure that DELETED is SET ON in your form becuase this is one of the many settings that is scoped to the curent data session.
>
> Then, after you delete the record in your view, you need to move the record pointer to have the record disappear from your grid.
>
>
> Regards,
> Marcia G. Akins
> Tightline Computers, Inc.


okay but what about the view not updating the table by deleting the records?

Marlon Levy
marlonlevy@gmail.com

ENTIRE THREAD

Optimistic row buffering with a updatable View Posted by Marlon Levy @ 10/6/2005 1:54:37 PM
RE: Optimistic row buffering with a updatable View Posted by Marcia Akins @ 10/6/2005 6:06:41 PM
RE: Optimistic row buffering with a updatable View Posted by Marlon Levy @ 10/6/2005 7:04:13 PM
RE: Optimistic row buffering with a updatable View Posted by Marcia Akins @ 10/6/2005 7:57:22 PM
RE: Optimistic row buffering with a updatable View Posted by Marlon Levy @ 10/6/2005 8:58:35 PM