CREATE PROCEDURE SP_WEB_UPDATEACCOUNT (
AID INTEGER,
FNAME VARCHAR (30) CHARACTER SET WIN1251,
LNAME VARCHAR (30) CHARACTER SET WIN1251,
ADDR1 VARCHAR (100) CHARACTER SET WIN1251,
ADDR2 VARCHAR (100) CHARACTER SET WIN1251,
CITY VARCHAR (30) CHARACTER SET WIN1251,
STATE VARCHAR (2) CHARACTER SET WIN1251,
ZIP VARCHAR (10) CHARACTER SET WIN1251)
AS
declare variable PrimaryID integer;

This error is generated when doing an execute statement from ASP.
However I do not believe it is an ASP error. Below is the statement
that I execute that works in EMS but not in ASP.

EXECUTE Procedure SP_WEB_UPDATEACCOUNT
(1,'Smith','John','Blah','Rear','Blah','US','99999')

--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> At 06:11 AM 30/06/2005 +0000, you wrote:
> >When I execute a stored procedure from outside of EMS I get the
> >error "COUNT field incorrect" however if I execute the SQL inside

of

> >EMS It returns fine. Any ideas as to why?
>
> You need to provide more information about your procedure, what you

are

> doing and what tool is giving you this error. "COUNT field

incorrect" is

> not a Firebird error message.
>
> Show the header of the SP (with the input and output arguments) and

the

> statement you are using to invoke the procedure.
>
> ./hb