Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anders Altberg
  Where is Anders Altberg?
 Anders Altberg
 To: jAy_Em Sancho
  Where is jAy_Em Sancho?
 jAy_Em Sancho
Subject: RE: Multi-User System
Thread ID: 188837 Message ID: 188874 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: General VFP Topics
Date: Tuesday, August 12, 2008 11:37:21 AM         

> Fellow Foxperts,
> Hello.. just wondering.. i want my system to be access by multi-users, and in my forms i declare a BEGIN TRANSACTION ... and END TRANSACTION and my object was linked to its corresponding field names, once i add a record to a certain master file and another user wants to view that master file the status bar says.. "Attempting to Lock..." i know the the reason why that's the error because of that BEGIN and END TRANSACTION command my question is.. aside from creating a dummy file for them to transfer all the entered data to the actual table, is there any other alternative to be access it in multi users? i didnt try yet the SQL insert into.., what if i used this should i encounter the same problem? is that necessary to declare BEGIN AND END transaction command? just hit me a tip for creating a system in multi users.. Thanks and More Power to us!!!

BEGIN TRANSACTION is only necessary when two tables have to be successfully updated for any of the updates to be comitted with END TRANSACTION.
The typical case is moving some money from one account to another. If the first attempt to update account 1 succeeds but the UPDATE of Account 2 fails, then the first one has to be rolled back. BEGIN TRANSACTION - END TRANS/ROLLBACK is only supposed to last for a split second, around two UPDATE or TABLEUPDATE() calls.
It sounds like you apply BEGIN TRANS at the start of your app.
That locks every one else out and you don't have a multiuser setup at all.



Multi-User System Posted by JAYEM SANCHO @ 8/12/2008 9:39:49 AM
RE: Multi-User System Posted by surinder singh @ 8/12/2008 10:07:20 AM
RE: Multi-User System Posted by Anders Altberg @ 8/12/2008 11:37:21 AM
RE: Multi-User System Posted by tushar @ 8/13/2008 5:13:11 AM