Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creating a cursor at run-time
Message
De
12/05/2015 14:55:48
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01619659
Message ID:
01619681
Vues:
64
Some people don't realize that over time orphaned temp files accumulate and need to be periodically deleted. I've seen cases where this hasn't been done for several years, and thousands of temp files have accumulated. In those cases it's rare, but not impossible that VFP might want to create a temp file based on the system time, and end up with a collision with a file that already exists.

The few times I've seen this happen, I ask the client to check their temp files folder, there have always been tons of files there.

>Thank you. Therefore I understand the I don't need to change my code of creating this cursor, in order to make the file name unique.
>
>>VFP may not create a physcal dbf at all but when it does, it's in VFP temporary folder with some temp name which suppose to be unique
>>
>>>
>>>If I am creating a temporary cursor as follows:
>>>
>>>
>>>CREATE CURSOR CUR_TBLNAME (.. list of columns in the cursor )
>>>
>>>
>>>does VFP create this cursor in a TEMP folder as a random name (physical dbf file) or it always going to be the same name?
>>>
>>>The reason I am asking is one customer a few days ago ran into a problem where when creating an index tag for this temp cursor they were getting the message that the .cdx file already existed. Non other customers ever got this problem. I am thinking that it could be because of a glitch with the customer that had a problem. Or maybe I am not creating the cursor with a truly random .dbf file name.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform