kamransari
Newbie
Joined: 07 Apr 2005
Posts: 1
|
 Posted: Apr 7th, 2005 12:55 AM Post subject: Sql 2000 Stored Procedure doesnot return value |
 |
|
I have written a stored procedure with the folowing header
CREATE PROCEDURE [AddSurgeonProc]
(@TerritoryManagerID_1 [varchar](100),
@SurgeonTypeID_2 [varchar](100),
@HospitalTypeID_3 [varchar](100),
@LastName_4 [varchar](50),
@FirstName_5 [varchar](50),
@Address1_6 [varchar](100),
@Address2_7 [varchar](100),
@Address3_8 [varchar](100),
@Phone_9 [varchar](25),
@Fax_10 [varchar](25),
@Email_11 [varchar](50),
@AuxPhone_12 [varchar](25),
@Mobile_13 [varchar](25),
@Notes_14 [text],
@Valid_15 [bit],
@EnteredBy_16 [varchar](50),
@SurgeonAddID bigint OUTPUT)
This procedures inserts data into a table. Once its done it takes out the uniqueid from that table and assigns it to SurgeonAddID. How ever when i try to return this value in visual basic 6
Set rtnSurgeonID = .CreateParameter("@SurgeonAddID", adBigInt, adParamOutput)
.Parameters.Append rtnSurgeonID
I always get 0 can anyone help me |
|
