Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
INSERT INTO locking mecanism
Message
 
 
À
05/09/1997 11:21:57
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00048697
Message ID:
00048721
Vues:
23
>>I assume you are inserting into a table from an array of many rows. You may need to try testing FLOCK(). If you can lock the table you can insert with no problem.
>
>I guess this is what I'll have to implement. This happen more and more that 2 users are creating a Universal Thread message at the same time.
>
>First, I'll have to SET REPROCESS TO AUTOMATIC. Then, I'll implement the FLOCK().
>
>Here is an example of my command:
>
>INSERT INTO TableName;
> (IDField,Field1,FieldDate,FieldTime);
> VALUES (lnNewRec,lnField1Value,DATE(),TIME())

This is unusual. You are only inserting 1 record at a time yet still get an occassional collision. I would have thought a reprocess time of 2 seconds would have been more than enough time to insert a record, update a CDX (if any), and unlock the table header. May have something to do with the enormous file size your table must be after a year of UT messages.
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform