Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ernesto De Peralta
  Where is Ernesto De Peralta?
 Tuguegarao
 Philippines
 Ernesto De Peralta
 Tags
Subject: Indexed record for deletion still showed in a file-client environment
Thread ID: 369 Message ID: 369 # Views: 3 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Friday, May 25, 2001 6:20:24 AM         
   


i have this problem:

my friend and i were network together to perform a quiz and the problem given to us by our professor is to make use of a multi-user environment. All the components for adding a record, moving to the top,bottom,next & previous record were working but our main problem is the deleting of record.

In my program's form, everytime i delete a record that record would not show in my screen but in the other screen (my friend) it still exist.
I have used SET DELETED ON which would index the temporary deleted data so therefore although it would not show in the screen it would still be present in the table, but contrary to the effect it still exist in my friend's screen wherein he networked his computer to mine and is using my program.

the adding of data worked because everytime i entered a new record, my friend would automatically see what i have inputted and vice-versa

this is my code:
set deleted on

if !eof()
if messagebox("Delete this Record? ",292,"deleted")=6
delete
skip
else
go bottom
endif
endif

i have set the following properties:
buffermode for the dataenvironment is set to 5-optimistic table buffer
buffermode for the form is set to 2-optimistic
datasession is set to 2-private session

Thank you very much and hoping for your help






ENTIRE THREAD