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:
00363711
Views:
16
>>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 :-)
>
>You do not need the first TableUpdate(), and there is no reason you can not wrap this in a transaction.

Yes, I tried and I need the first TABLEUPDATE, sure, if not, the record only gets deleted but without changing the lastUpdate field.
Pablo Roca
Clavo Congelados, S.A. (La Coruna - Spain)
Sysop of PortalFox

Join MasFoxPro campaign
http://www.masfoxpro.com
Previous
Reply
Map
View

Click here to load this message in the networking platform