At 11:36 AM 5/5/2008 -0400, MB Software Solutions General Account wrote: >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
I believe the "record validation" code fires before the data is stored. The Insert/update/delete triggers fire after. But I'm not 100% sure. There may be some restrictions on the Valid, but I can't recall them off the top of my head. -Charlie _______________________________________________ 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.
