Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DBC UPDATE Trigger to set lastUpdated Column Value
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01687206
Message ID:
01687207
Views:
63
This message has been marked as the solution to the initial question of the thread.
Hi,

You can set rule for record validation: LastUpdate_rule()

And add procedure to "Stored procedures":
PROCEDURE LastUpdate_rule()
REPL LastUpdate WITH DATETIME()
RETURN .T.
MartinaJ

>Hi all -
>
>Unfortunately my memory is failing me, as I am not remembering much of what I used to know about DBC triggers in Visual FoxPro. Can a DBC trigger update the same table that fired the trigger? I'm wanting to use a DBC to ensure a table's LastUpdate column is updated every time an update is made to any column or the row is marked for deletion. Is that possible?
>
>And if not, what would a decent work-around be?
>
>Thanks!
"Navision is evil that needs to be erazed... to the ground"

Jabber: gorila@dione.zcu.cz
Jabber? Jabbim
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform