Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Date of Last Update Field...
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00362891
Message ID:
00363708
Vues:
18
>Usually, DBs [e.g., Oracle] do not maintain deleted records so updating any field is needless. However, you can do it manually [with code].
>
>replace next 1 LastUpdate with date()
>delete next 1

Yes, manually I done like:

REPLACE lastUpdate WITH DATETIME()
=TABLEUPDATE(...)
DELETE
=TABLEUPDATE(..)

But it's not the way I like this, cause I wanted in a transaction, and automatic. I need to track when the users deleted some records (don't wanna also FoxAudit :-)
Pablo Roca
Clavo Congelados, S.A. (La Coruna - Spain)
Sysop of PortalFox

Join MasFoxPro campaign
http://www.masfoxpro.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform