>>Is there any reason why, on a specific situation, that a SQL command which returns no record will not be standing on the cursor after the command is being executed?
>>
>>After thousands of runs on that specific line, either with result or no result on the cursor, on the next line, I am standing on that cursor. But, on a specific situation, it was not and on that one, the result of the cursor was empty. Anyone faced that before?
>
>Is this reproducible or have you only ever seen it once?
That's the first time I had it.
>Were you working across a network or just on the local machine?
That's a server.
>Maybe your cursor ALIAS() was already in use? Or, there was an old temp file in your tempfiles folder with the same name as what SELECT wanted to use for the cursor. Or, two instances on the same machine tried to write their output cursors at the exact same time.
Well, each instance has its own private environment. So, that wouldn't be the case.