Hi Eric,
VFP triggers are simply VFP functions and they are speficied in the 3rd page of the table designer. You will see that the code will be somehting like
__ri_insert_tablename()
You may change this code to
YourFunction() AND __ri_insert_tablename()
which means that if your function returns a False the trigger will never be executed.
>I already checked the speed without triggers and I have a big performance improvement.
>
>What I want to do is temporarily disable the trigger in my code before I do my processing, do my processing and then re-create the triggers.
>
>Thanks
>
>Eric Dumais
>
>>Hi Eric,
>>
>>What are you looking for? Do you want to check the speed without any triggers?
>>
>>>Hi everyone.
>>>
>>>I want to temporarily "deactivate" the triggers on tables for performance reasons.
>>>
>>>I know about the DELETE TRIGGER and CREATE TRIGGER commands. What I cannot seem to find is a function that will return me the current value of the trigger. What I want to do is store the triggers in a temporary table, delete them, do my processing and then re-set the triggers based on what I have in the temporary table.
>>>
>>>Maybe this is not the right way to go, if someone have a suggestion, feel free to give me your input.
>>>
>>>Thanks in advance.
>>>
>>>Eric Dumais.