That works! Thank you Doug!
So if I have multiple input params in the SP it might look like...
SELECT * FROM SP_PLAYERFIND('ProfKill','Blah',34,0)
Just keep the param values in the same order as they are in the SP?
Here's a question, how would I call a SP from code that does an Update or
an Insert?

You know what, this is all soooooooooo different from TSQL in MSSQL Server.
Mark :-)

On 7/23/05, Doug Chamberlin <dougchamberlin@...> wrote:
>
> At 7/23/2005 08:42 PM (Saturday), Mark Deibert wrote:
>
> >It must have been something wierd with IBEasy. Still didn't find out. I
> >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.
>
> Try SELECT * FROM SP_PLAYERFIND('ProfKill')
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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]