Subject | Re: [IBO] TIB_Cursor not returning correct result |
---|---|
Author | Helen Borrie |
Post date | 2004-08-25T16:08:56Z |
At 04:02 PM 25/08/2004 +0000, you wrote:
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.
>Thanks Helen but that didn't do it. I changed the code toTake out the Open call.
>
>qry.Open;
>qry.First;
>
>and it still returns zero. Do you have any other ideas?
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.