Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Use Server Date/Time
Message
 
À
14/04/2010 06:50:33
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01460122
Message ID:
01460127
Vues:
70
>Hi,
>
>We have a client who suspects fraud by an employee. The suspicion is that the employee changes the workstation date, then posts an inventory transaction dated well in the past, then pilfers the item. What I need is a way to:
>
>1. Prevent changes to the Workstation date/time OR
>2. Stamp all transactions with the Server Date/Time OR
>3. whatever else can prevent/flag this behavior
>
>Thanks,
>
>Ken.

Because you wrote this in Client/Server Category I assume you use some other DB like SQL Server or ORACLE.

You could add a field in your table with DATETIME type.
Then set default value for this field to be GETDATE() if you use SQL Server, or similar function for ORACLE.

Id you use VFP DataBase then you should use Sergey's suggestion (BTW Sergey's suggestion will work no matter what DB you use :o)))))))
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform