Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP/ADO/SQL stored procedure syntax
Message
From
06/10/2005 19:23:46
 
 
To
06/10/2005 19:10:25
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01056781
Message ID:
01057011
Views:
52
This procedure is just for illustration purposes.
CREATE PROCEDURE usp_test 
	@Number	INT
AS
RETURN @Number + 3
GO
I call it this way
LOCAL x AS Integer, y AS Integer
x = 5
?oData.oConn.Execute("{y = call usp_test(x)}")
and I get SQL error "Syntax error or access ciolation."
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform