Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2003 Server
Hello John.
The machine is actually a shrimp classification machine, each user has to input more
data than I've showed and they recieve a paper with the information on it.
Right now whe have 5 machines and the probability of a mistake has increased a lot.
I was thinking about the lock procedure, but is that possible in MS Sql Server ?
I'm sure I read somewhere something about that, but I can't remember where.
Another alternative is to run a batch process to verify data consistency each day
or twice a day.
c.x.
>Hey Carlos,
>
>Consider changing the machine ID from being a user input to a programmed entry using SYS(0). If you can't do that, surely you can use old-fashioned locking to lock the base table on Save and do a query for entires for that machine for conflicting time period as Alex mentioned?
>
>
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement