connection.execute "EXECUTE Procedure SP_WEB_UPDATEACCOUNT(" & session
("AID") & ",'" & FName & _
"','" & LName & "','" & Addr1 & "','" & addr2 & "','" & City & "','"
& State & _
"','" & Zip & "');"

--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> > 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')
> >
>
> so no return values?
> please show us the snippet of asp code
> Alan