Subject | Re: [firebird-support] I can't find the error in this very short SP |
---|---|
Author | Doug Chamberlin |
Post date | 2005-07-24T00:46:01Z |
At 7/23/2005 08:42 PM (Saturday), Mark Deibert wrote:
>It must have been something wierd with IBEasy. Still didn't find out. ITry SELECT * FROM SP_PLAYERFIND('ProfKill')
>actually downloaded another FB dbadmin tool "IBExpert". For some reason the
>SP compiled with that tool. I wish I knew what the difference was. But now I
>have a follow up question. How do I call the SP from code? I've tried all of
>these...
> SP_PLAYERFIND(PLAYERNAME='ProfKill')
>SP_PLAYERFIND(@PLAYERNAME='ProfKill')
>SP_PLAYERFIND(PLAYERNAME,'ProfKill')
> Everything I try I get...
> Dynamic SQL Error.
>SQL error code = -104.
>Token unknown - line 1, char 9.
>SP_PLAYERFIND.