Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DBC UPDATE Trigger to set lastUpdated Column Value
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01687206
Message ID:
01687207
Vues:
66
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform