Good, Svein!
it was this, really! The problem had been in an insert clause. I forgot to
include a field (a new field inserted on the table). Ops!
Thanks for your tip!
Regards,
Carlos Arguilar
-----Mensagem original-----
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]Em nome de Svein Erling Tysvær
Enviada em: quarta-feira, 28 de setembro de 2005 11:15
Para: firebird-support@yahoogroups.com
Assunto: [firebird-support] Re: isc_error 569 and Sql_error -804


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




++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++




----------------------------------------------------------------------------
--
YAHOO! GROUPS LINKS

a.. Visit your group "firebird-support" on the web.

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.


----------------------------------------------------------------------------
--



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