Subject | isc_error 569 and Sql_error -804 |
---|---|
Author | Carlos Arguilar |
Post date | 2005-09-28T12:44:08Z |
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/
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/