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?