Check Re: Can stored procedures return values? Thread #876879 Message #876903

>I can't seem to get this to work. SQL is returning Syntax Error:
>
>

>SELECT Import
>SCAN
>
>	sPartNo = ALLTRIM(Import.PartNo)
>	iPartId = 0
>	
>	sCommand = "exec ap_GetPartIdByPartNo ?@sPartNo, ?@iPartId OUTPUT "
>	iResult = SQLEXEC(iConnHandle , sCommand)
>
>	IF iResult < 0
>		AERROR(ArrayName)
>	ENDIF
>
>ENDSCAN
>