Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Creating a last modified field.
I am using VFP5 and would like to create a last modiied field in my tables. All of the tables
reside in a Database.
I created a field called "lastmod" and call an update trigger from the tables properties to up
the "lastmod" field in this table. However when I try to call this code I get a
"Cannot Update Cursor" error message. Here is what I try to do;
SELECT thistable
REPLACE thistable.lastmod WITH DATETIME()
Can a table update one of it's fields from it's update trigger?
I can update a different table from a DBC's stored procedure but not the calling table's fields
Is this what I'll have to do?
Thanks,
Jerry Tovar
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement