Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: Jack Ryan
  Where is Jack Ryan?
 Auckland
 New Zealand
 Jack Ryan
 To: Brad Schulz
  Where is Brad Schulz?
 San Carlos
 California - United States
 Brad Schulz
 Tags
Subject: RE: Clashing tmp filenames with 12 instances
Thread ID: 210781 Message ID: 210797 # Views: 29 # Ratings: 0
Version: Visual FoxPro 9 Category: Web Applications
Date: Wednesday, January 07, 2009 11:01:16 PM         
   


Brad,

If you try to change a value in a readonly cursor, don't you get a 111 error rather than a 1718 error?

The erroring line is a SQL Select that runs repeatedly all day. The filename referenced in the error message is VFP's own internal allocated tmp filename for the result cursor. Presumably VFP isn't trying to create 2 cursors with the same tmp filename, which is why we think it must be 2 instances trying to use the same supposedly unique filename.

The SQL Select does not use readwrite but it does use nofilter.

Our understanding is that VFP always allocates a tmp filename for a cursor but doesn't always spool it to disk. Presumably the error only happens if 2 selects are run in the same clock tick and spooled to disk with the same filename. Again, we're hoping that VFP is smart enough not to try to give 2 cursors the same internal filename which points us back to the multiple instances.



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