Re: Question about opening and closing files

Your trigger program is called when a row is added or updated to that
table, right? Hopefully you aren't planning on chaining to the same file
you built the trigger on because if you are, you really need to study what
a trigger program is. However, let's say you aren't. Let's also say that
USROPN is probably a good idea. Because, in general, on a trigger
program, it is a good idea. The reason being is this: Your trigger may
be fired off by any application that updates the file. For example, we
have a trigger on a file that Notes/Domino updates. The point being: Do
NOT assume that your library list will be correct. Because in our case,
it wasn't. Sure the trigger tested fine when used within a "traditional"
application using upddta. But failed miserably from the Domino update. We
had to USROPN. Now, if your files are always in the same library then you
could take the library parameter on the trigger program and use that in
your f spec keyword on the USROPN file to open the right file. In our
case we wanted to call other programs and had to update the whole library
list.

I take it you weren't planning on turning on LR in your trigger.



Rob Berendt