Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Simon Arnold
  Where is Simon Arnold?
 United Kingdom
 Simon Arnold
 To: Sivaramakrishnan Parameswaran
  Where is Sivaramakrishnan Parameswaran?
 Sivaramakrishnan Parameswaran
Subject: RE: Problem in updating through VC++
Thread ID: 280 Message ID: 283 # Views: 1 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Tuesday, May 22, 2001 1:55:34 AM         

> Hi All,
> Environment : Visiual Studio 6.0 with SP4.
> Windows NT work Station 4.0 with SP4
> Problem : Applicatio has two Modules 1. VC++ ( Accept Complaints) 2. VFP
> VC++ updates the tables using ODBC of VFP. there are multiple threads running in the VC++ for updating the table. All update statement are given in Critical section in VC++ side
> VFP used for reports and Data Maintainence. After Using report in VFP the tables are not available for updates in VC++. All the reports we have used cursor ie( Select xxxx from tbl1 int o cursor C1) and then we use Cursor C1. Also in init event of the form we have given SET EXCL OFF.
> Kindly help to correct the problem
> Siva

Move the SET EXCLUSIVE OFF to the main start program, also make sure that you have SET MULTILOCKS ON, another check is if you are using Reports created in the Report Designer, check that you have not got anything in the DataEnvironment.

Hope this Helps.

Simon Arnold
Westlake Computer Systems Ltd.
Halifax, UK.


Problem in updating through VC++ Posted by Sivaramakrishnan Parameswaran @ 5/22/2001 1:41:07 AM
RE: Problem in updating through VC++ Posted by Simon Arnold @ 5/22/2001 1:55:34 AM