If I understand them correctly, the VFP triggers only fire AFTER, and don't have a BEFORE kind of event. In Oracle, MySQL, and SQL Server (although I'm not 100% sure on SQL Server), you've got BEFORE and AFTER even triggers for each (INSERT, UPDATE, DELETE). In my situation, I'm updating a UnitCost field in a table, and I'd like to store the value BEFORE it gets changed in another table for historical purposes. I know Ed has done some creative things with this in the past where (and correct me if I'm wrong, EGL) he stores the UnitCost in a separate table with a datetime stamp and then just grabs the latest dated record for the current price.
Ideas on how to achieve my "historical changes" need (besides Ed's way)? tia, --Michael _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
