>>I have some ideas which I'm going to implement.
>>
>>Do you know if there is a way to determine inside the trigger when it's the last record to replace, if, say, we're using replace next 500 command?
>>
>
>No, I do not.
>
>A trigger is fired on a record by record basis, just before the changes are actually committed. So, the trigger only knows about that one record.
>In the example above, the trigger would be fired 500 times (or less)
>
>But I'm puzzled as to why you would need that info inside the trigger
>[snip]
The reason is that I want to open all needed tables once in the beginning and close them at the end. I suspected the answer you and Fabio gave me, so I guess I'm out of luck...
If it's not broken, fix it until it is.
My Blog