Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View locked indefinitely
Message
From
05/02/2002 06:50:06
 
 
To
04/02/2002 13:45:07
Sonny Chouinard
CHCA Computer Systems Inc.
Lachenaie, Quebec, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00614943
Message ID:
00615326
Views:
18
Hi, guys!

It happens in a single-user application? Probably, because different data sessions. In fact "AGAIN" option for "USE" command works only inside of the same data session. When you try to open the view in another data session, it just re-open it completely with running query to get data from table. As a result, when something is locked in data table, you will get such error. For example, in one data session you have view opened and modified + udated in transaction. This will lock the source table. When you then try to open exactly the same view in another data session (even with AGAIN option), query for view runs again and cannot get data because table is locked.

HTH.

>I have a problem with some clients that's driving me crazy for some time.
>
>I know, I know, I shouldn't use DBC with remote views but my application is built with it. We open all references tables in the default data environment. Then when a form is opened, we use the command VIEW... AGAIN. This is working great with much of our clients.
>But sometimes, with no particular reason, there is a view that cannot be opened. I got an "Error loading file when trying to open the view." The lock on the view is removed only when we quit the entire application. I am aware of the lock on the dbc when a form is opened and did the corrections for that. But even with a single user, the problem occurs...
>
>We are planning to switch to PASSTHROUGH but we have to live with remote views for the next few months... Does this happened to others???
>
>Thanks!
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.com
ICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs

It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform