Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 To: Jack Ryan
  Where is Jack Ryan?
 Auckland
 New Zealand
 Jack Ryan
 Tags
Subject: RE: Clashing tmp filenames with 12 instances
Thread ID: 210781 Message ID: 210988 # Views: 20 # Ratings: 0
Version: Visual FoxPro 9 Category: Web Applications
Date: Thursday, January 08, 2009 6:38:21 PM         
   


> All,
>
> One of our customers is running a VFP COM application with 12 instances on a quad-dual-core server.
>
> We're starting to see errors like this:
>
>
LINE:1677 ERROR NO:1718 MESSAGE:File
> c:\docume~1\clinsu~1\locals~1\temp\0000duzd003g.tmp is read-only.

>
> Line 1677 is a SQL Select statement against an existing VFP cursor into another cursor. We're assuming that 0000duz003g.tmp is the tmp filename allocated internally by VFP for the result. Certainly it's not something we're creating ourselves.
>

You could try adding the READWRITE clause to your queries if you want to modify them.
All query cursor are readonly by default.
Some simple query cursors are really just the base table opened again with a filter set. You can prevent that with the NOFILTER clause.
-Anders



COMPLETE THREAD
Clashing tmp filenames with 12 instances Posted by Jack Ryan @ 1/7/2009 7:06:57 PM
RE: Clashing tmp filenames with 12 instances Posted by Brad Schulz @ 1/7/2009 7:14:43 PM
RE: Clashing tmp filenames with 12 instances Posted by Jack Ryan @ 1/7/2009 11:01:16 PM
RE: Clashing tmp filenames with 12 instances Posted by tushar @ 1/7/2009 7:17:45 PM
RE: Clashing tmp filenames with 12 instances Posted by Jack Ryan @ 1/7/2009 11:05:52 PM
RE: Clashing tmp filenames with 12 instances Posted by tushar @ 1/8/2009 8:00:35 AM
RE: Clashing tmp filenames with 12 instances Posted by Jack Ryan @ 1/8/2009 7:12:43 PM
RE: Clashing tmp filenames with 12 instances Posted by Brad Schulz @ 1/8/2009 7:37:13 PM
RE: Clashing tmp filenames with 12 instances Posted by Jack Ryan @ 1/8/2009 9:00:22 PM
RE: Clashing tmp filenames with 12 instances Posted by tushar @ 1/8/2009 8:32:12 PM
RE: Clashing tmp filenames with 12 instances Posted by Anders Altberg @ 1/8/2009 6:38:21 PM
RE: Clashing tmp filenames with 12 instances Posted by Brad Schulz @ 1/8/2009 6:53:57 PM