Variables as parameters in SQL procedure call

[lgazire]

I want to execute the following case?

Code: Select all

   %s = @str(!productId)
   pageload(page={%produto}, type=odbc)  "Description=DEsc;DRIVER=ODBC Driver 13 for SQL Server;SERVER=localhost;Trusted_Connection=Yes;APP=EViews;DATABASE=Db;" "{call USP_SEL_GetMovingAveragePriceQuote ("+%s+"))}"


But i got the error:

Code: Select all

 ODBC Error 42000: Syntax error, permission violation, or
 other nonspecific error in "PAGELOAD(PAGE=RICE,
 TYPE=ODBC)  "DESCRIPTION=DESC;DRIVER=ODBC
 DRIVER 13 FOR SQL SERVER;SERVER=LOCALHOST;TRUSTED
_CONNECTION=YES;APP=EVIEWS;DATABASE=DB;" "{CALL USP_SEL_GETMOVINGAVERAGEPRICEQUOTE ("+"1"+"))}"".



If i pass directly it doesn´t show any errors, what am i doing wrong?

[EViews Gareth]

Looks like you have two close parens at the end, but only one open paren.

Also, it might be safer to build up that second string as a variable and use that:

Code: Select all

%s = "{call USP_SEL_GetMovingAveragePriceQuote ("+@str(!productID)+")}"
pageload(page={%produto}, type=odbc)  "Description=DEsc;DRIVER=ODBC Driver 13 for SQL Server;SERVER=localhost;Trusted_Connection=Yes;APP=EViews;DATABASE=Db;" %s


[EViews Gareth]

viewtopic.php?t=12944