Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
INSERT INTO locking mecanism
Message
De
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:
00048717
Vues:
29
>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())
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform