Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How To: Set the updated records...
Message
 
To
11/10/2004 13:05:06
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00950441
Message ID:
00950481
Views:
15
Thank you...

Actually, I'm doing it using the VALID of each record... but your idea about a log table sounds perfect!

Thank you again!

[]s!


>>Hello... I'm here again! ;-)
>>
>>So... At the end of each day, I have to create a list of records that has been inserted, updated or deleted... My problem isn't create this list, but know which records...
>>
>>My idea was create a field LastUpdate DateTime and use the triggers to keep this information up to date!
>>
>>But, when one trigger is fired, and I try to replace some field, I got an error: Cannot update the cursor.
>>
>
>Triggers can't change data in the same table. You might try creating a log table that's updated by triggers. That is the create and update triggers for all the tables you need to track would insert a record into the log.
>
>Your other option is to use a record-level rule. Record rules are called each time you save the record, so you can update the field there.
>
>Tamar
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Rodolfo Duarte
Previous
Reply
Map
View

Click here to load this message in the networking platform