Subject isc_error 569 and Sql_error -804
Author Carlos Arguilar
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







_______________________________________________________
Novo Yahoo! Messenger com voz: ligações, Yahoo! Avatars, novos emoticons e muito mais. Instale agora!
www.yahoo.com.br/messenger/