SELECT COUNT(PRES) FROM LONE WHERE PRES = :CLI_ INTO QTY_;

needs to be

SELECT COUNT(PRES) FROM LONE WHERE PRES = :CLI_ INTO :QTY_;



--
Nick
-----We Solve your Computer Problems---
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Carlos Arguilar
Sent: 28 September 2005 14:31
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] isc_error 569 and Sql_error -804


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







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


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

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]



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

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



* Visit your group "firebird-support
<http://groups.yahoo.com/group/firebird-support> " on the web.


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


_____




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