Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Returning values from an SQL stored procedure
Message
 
 
To
03/08/2004 10:09:33
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00930255
Message ID:
00930345
Views:
20
>For the sake of confusion, and my stupidity, could you show both pieces of code in full?
>
Sure,
* VFP 
lcParam1 = 'MyPCName'
lnID = 0
=SQLExec(lnConnection, "execute ApplicationLoginInsert1 ?lcParam1, ?@lnID")
...
-- SQL Server
CREATE Procedure ApplicationLoginInsert1 
  @lcParam1 varchar(128), 
  @ID int OUTPUT
insert into ApplicationLogin (Login_PC) values (@lcParam1)
SET @ID = SCOPE_IDENTITY()
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform