Ann W. Harrison wrote:

>Mitchell Peek wrote:
>
>
> >>fb 1.5.2 SS
> >>
>
>
>>>The cursor identified in the update or delete statement is not
>>>positioned on a row.
>>>no current record for fetch operation.
>>>attempted update of read-only column.
>>>
>>>
>>>
>>Never mind!!!! Figured it out. Thanks anyway.
>>
>>
>>
>
>For the next person who runs into that error, what was the problem?
>
>Thanks,
>
>
>Ann
>
>
>

Sorry, I suppose I should have said. It was a rather careless error,
actually. It had to do with the new (to me) composite triggers.

example:

create trigger trg_example for ATable before update or delete as
begin
<do some stuff>
new.ModifiedTimeStamp=Current_TimeStamp;
if (deleting) then
<do other stuff>
end

Obviously, if (deleting) then the New.<Anything> doesn't exist. After
figuring it out, the error statement makes perfect sense, but it didn't
before... not to me anyway.

Thanks again,
Mitch


[Non-text portions of this message have been removed]