Subject Re: TIB_Cursor not returning correct result
Author sgharp
--- In, 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.