Subject | RE: [firebird-support] unknown cursor error |
---|---|
Author | Alan McDonald |
Post date | 2005-12-04T20:53:07Z |
> Hi,without seeing how you've declared your cursor how would anyone know?
>
> In the followng SP, the SQL statement on line 38
>
> UPDATE account_heads SET ageing_id = :iAgID, ageing_balance = :dBaln
> WHERE CURRENT OF cT1;
>
> gives an 'unknown cursor error'
>
> So I had to change it to
>
> UPDATE account_heads SET ageing_id = :iAgID, ageing_balance = :dBaln
> WHERE company_id = :dCID AND account_id = iAcCd;
>
>
> to avoid the error. Is this a bug ?
>
> Thank you.
>
>
> Sudheer Palaparambil
I'd say it's a bug in your code. Let's see more about cT1.
Alan