At 04:02 PM 25/08/2004 +0000, you wrote:

>Thanks Helen but that didn't do it. I changed the code to
>
>qry.Open;
>qry.First;
>
>and it still returns zero. Do you have any other ideas?

Take out the Open call.

And I guess that you do have the cursor in the same transaction as the SP,
right? If it's in a different transaction, it will only see the state of
the table as it was after the SP's work was committed.

btw, I'm off to bed now.

H.