Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Multiuser file access
Message
De
06/12/2013 11:09:46
 
 
À
06/12/2013 10:11:54
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Web
Divers
Thread ID:
01589362
Message ID:
01589459
Vues:
49
Craig, thanks. I just need a resource that you can point me to that has the information such as 'FLOCK() is bad in multiuser scenarios', so that I don't have to keep on bothering gurus like you.

As far as the primary key, in this particular case I didn't need see a need for one - it's just a log that can be filtered by date/time. Is there something wrong with this?

>FLOCK() is bad in multiuser scenarios. There's no reason to lock a file to do an INSERT INTO. You comment raises the question of how your code generates the primary key.
>
>>Are you saying that with INSERT INTO, I don't need flock()?
>>I guess that 'Log file' is inaccurate. It's a list of emails that have a lSent field. If the previous attempt was unsuccessful and it is successful now, I want to update the lSent to .t.
>>
>>
>>PROCEDURE UpdateEmailLog(tcText, tcCustno, tcDisposition)
>>
>>LOCAL lnSelect, llUpdated
>>
>>lnSelect = SELECT()
>>
>>SELECT emails
>>
>>llUpdated = .F.
>>
>>DO WHILE !llUpdated
>>
>>	IF FLOCK()
>>		APPEND BLANK
>>		REPLACE em_body WITH tcText, ;
>>			em_datetim WITH DATETIME(), ;
>>			em_custno WITH tcCustno, ;
>>			em_disptn WITH tcDisposition
>>
>>		UNLOCK
>>		llUpdated = .t.
>>	ENDIF
>>
>>ENDDO
>>
>>
>>SELECT (lnSelect)
>>
>>RETURN
>>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform