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
 Tags
Subject: Optimistic row buffering with a updatable View
Thread ID: 78646 Message ID: 78646 # Views: 3 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Thursday, October 06, 2005 1:54:37 PM         
   


I recently started using table buffering in Visual foxpro for my multiuser apps. This enabled me to use the features of the dataenvironment however i came across this problem last night:

i have a parent table enabled for pessimistic row buffering and a view that loads the child records for the parent record. the view is enabled for optimistic row buffering because this is one of three options allowed for a view cursor. i can add new records to the view and they tunnel though to the table but when i delete directly in the view it doesn't follow to the table. I am lost kindly shed some light.


by the way the child view is in a grid.....

if messagebox("Are you sure you want to delete this record",36+256,"Confirm Deletion")==6
	sele vwStudentsinGroup
	delete
	thisform.refresh()
endif


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

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