>Yes that is what Im doing, but Im also RLOCKing the records before I go into edit and the trigger fires right after the SELECT 0 but before the SELECT-SQL.. if I take out the SELECT 0 then the trigger fires right at the SELECT-SQL.
Don't issue the RLOCK command, it is not needed with optimistic row or table buffering. Then, when you are ready to commit, issue a TABLEUPDATE() command (see VFP Help for function parameters).
Mark McCasland
Midlothian, TX USA