--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:

> 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.

I've tried it in a seperate transaction or in the same. I've also
tried TIB_Cursor and TIB_Query and both have the same result.

> H.