|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
July 23rd, 2005, 06:55 PM
|
|||
|
|||
Correct syntax to call SP?
I finally got my SP to compile.
How do I call it and pass params from code? I've tried all of these variations... sp_PlayerFind(PlayerName='ProfKill') sp_PlayerFind(@PlayerName='ProfKill') sp_PlayerFind(:PlayerName='ProfKill') Nothing works. I get an error everytime. Error is... Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 1 SP_PLAYERFIND What is the correct syntax for calling a SP? Thanks in advance for your help 
|
|
#2
July 24th, 2005, 02:55 AM
|
||||
|
||||
|
Take some time to read Writing stored procedures and triggers and Emulation of temporary tables in Firebird
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins
|
|
#3
July 24th, 2005, 07:30 AM
|
||||
|
||||
|
Execute Procedure Sp_playerfind(parameter);
__________________
If i've been helpful, please add to my reputation. My unfinished site: http://www.dever.ro
|
|
#4
July 24th, 2005, 07:51 AM
|
|||
|
|||
Thanks!
Thanks for the replies guys. My TSQL to PSQL has been a struggle. Much more so than I would have thought. I did -a lot- of Googling yesterday and never found the articles you posted. I'm reading them now. I got some quick replies from the Firebird mailing list and solved the problem.
I'm headed to Borders this weekend to pick up a book. Thank you again! :-)
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Correct syntax to call SP? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
