Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date of Last Update Field...
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00362891
Message ID:
00363708
Views:
19
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform