This compiles fine...
ALTER PROCEDURE SP_GAMEENTER (
GAMEKEY INTEGER,
PLAYERKEY INTEGER)
AS
begin
update PLAYERS set GAMEKEY=:GAMEKEY where PKEY=:PLAYERKEY;
end
In my code I call it like this...
EXECUTE SP_GAMEENTER(22,2)
I get this error...
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 9
SP_GAMEENTER
I don't see the problem. Any ideas would be greatly appreciated :-)

On 7/23/05, Mark Deibert <mark.deibert@...> wrote:
>
> I've been writing SPs for MSSQL T-SQL for many years but I'm new to
> Firebird and SQL99 stuff. Here's a simple (I thought) SP that won't
> compile..
>
> CREATE PROCEDURE SP_PLAYERFIND ( PLAYERNAME VARCHAR(16) )
> RETURNS ( PLAYERKEY NUMERIC(15,0) )
> AS
> BEGIN
> SELECT PKEY FROM PLAYERS WHERE PLAYERNAME=:PLAYERNAME
> INTO :PLAYERKEY;
> SUSPEND;
> END
>
> The error returned by IBEasy SQL tool is "Unexpected end of command".
>
> I've tried many different ways of entering this in various
> upper/lower case, with/without semi-colons, with/without "suspend"
> combinations. I always get an error when I try to compile it.
>
> I'd -greatly- appreciate your expert advice.
>
> :-)
>
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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<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/>.
>
>
> ------------------------------
>



--

L8R,

Mark:-Deibert
> SELECT * FROM Users WHERE Clue> 0
> 0 records returned


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