Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Call SQL Stored Proc With Output Param
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Call SQL Stored Proc With Output Param
Miscellaneous
Thread ID:
01396149
Message ID:
01396149
Views:
106
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
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Next
Reply
Map
View

Click here to load this message in the networking platform