Remember that vfp is not client server, you will timestamp from each machine
if writing to .shared table. If you need time (for tracking...) independant
from machine having the table open, call activeX on server.
I bundle such stuff inside Cursoradapter, as this eliminates one roundtrip,
which might be across WAN. My "timestamps" for Record modification are
simple Ints, which get incremented via Cursoradapter automatics in 1 call.
my 0.22€
thomas
>>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!
>
>Hello Martina -
>
>Thanks so much. I appreciate the help!
>
>Interestingly the Record Validation rule will not fire when a record is simply marked for deletion. Worse case I could set a DELETE TRIGGER and log such deletions. Using both the "last updated" column and the log would allow for reporting of all changes and deletions (adds will be handled via a column default value) after a given datetime value. I think that will work.
>
>Thanks again.
>________________
>_____/ Regards,
>____/ al