Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 India
 tushar Kanvinde
 To: jAy_Em Sancho
  Where is jAy_Em Sancho?
 quezon
 Philippines
 jAy_Em Sancho
 Tags
Subject: RE: Multi-User System
Thread ID: 188837 Message ID: 189044 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: General VFP Topics
Date: Wednesday, August 13, 2008 5:13:11 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/END TRANSACTION should be used for the minimum time possible. It has to be used only when the data is being saved. Also do not have a user input between the BEGIN and END.

Regards
Tushar

ENTIRE THREAD

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