Could there be a similar error in your code somewhere else? I.e. that
the number of columns you select doesn't equal the number of variables
you put them into? It doesn't have to be a COUNT statement, the error
message is simply telling that something doesn't match up.

Set

--- In firebird-support@yahoogroups.com, "Carlos Arguilar" wrote:
> Sorry Nick and all!
> In the sample below is missing the INTO, however, in the real code
> it isn't. It is like this:
> SELECT COUNT(PRES) FROM LONE WHERE PRES = :CLI_ INTO QTY_;
> Anyone help?!
> Thanks in advance.
> Carlos Arguilar
>
> -----Mensagem original-----
> De: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]Em nome de Carlos Arguilar
> Enviada em: quarta-feira, 28 de setembro de 2005 09:44
> Para: firebird-support@yahoogroups.com
> Assunto: [firebird-support] isc_error 569 and Sql_error -804
>
> Hi Fellows!
>
> Inside a Stored Procedure I have two statements utilizing COUNT,
> like this sample:
> SELECT COUNT(PRES) FROM LONE WHERE PRES = :CLI INTO :QTY;
> .
> .
> .
> FOR SELECT L1_CLI FROM LONE WHERE PRES = :PRES_ INTO :CLI_ DO
> BEGIN
> SELECT COUNT(PRES) FROM LONE WHERE PRES = :CLI_;
> .
> .
> .
> END
> .
> .
> .
> When I try to create this procedure FB retrieve me the error
> following:
> isc_error: 569 and SQL_error -804 plus the message: 'Count of
> read-write columns does not equal count of value'.
>
> What's happening? I am using FB 1.52.
>
> Thanks for tips.
>
> Carlos Arguilar