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


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