>Is rv_nextkey a view? why not REQUERY() whether or not it was already open?
I tried your suggestion, unfortunately it's not working either. I think the problem may be in my startup environment. For some reason, the following statement is doing nothing:
USE "eis!rv_NextKey" IN 0
It doesn't open the rv_NextKey table, it doesn't return any values.
So, in effect, the rv_nextKey table/view is never being accessed. What statements are absolutely necessary for the above line to work?
As I said, sometimes my NewID() function works, and sometimes it doesn't. I just haven't figured out what is being changed when it stops working. (Very frustrating!!)