Results 1 to 7 of 7

Thread: Retrieve Unique ID for a new Record

Threaded View

  1. #1

    Thread Starter
    Frenzied Member FishGuy's Avatar
    Join Date
    Mar 2005
    Location
    Bradford UK
    Posts
    1,708

    Resolved Retrieve Unique ID for a new Record

    I cannot figure out what is going wrong here.
    I get the error.
    PK_RequestID is not a parameter for procedure sp_InsertRequestID.
    Here is my SP

    Code:
    ALTER PROCEDURE sp_InsertRequestID
    
    	(	
    	@User varchar(50),
    	 @Request varchar(50),
    	@PK_RequestID int OUTPUT
    	)
    
    AS
    	Insert INTO TBL_Requests 
    	(LoginID, Request) 
    	Values 
    	(@User, @Request)
    	Select @PK_RequestID=@@Identity
    Return
    Here is my Code to call it
    Code:
    Dim intReturnID
            Me.SqlConnection1.Open()
            Me.SqlCommand1.Parameters.Item("@Request").Value = Me.TextBox1.Text
            Me.SqlCommand1.Parameters.Item("@User").Value = Session("MyID")
            Me.SqlCommand1.ExecuteNonQuery()
            intReturnID = SqlCommand1.Parameters("@PK_RequestID").Value
            Me.SqlConnection1.Close()
    And here is my declarations
    Code:
    Me.SqlCommand1.CommandText = "[sp_InsertRequestID]"
            Me.SqlCommand1.CommandType = System.Data.CommandType.StoredProcedure
            Me.SqlCommand1.Connection = Me.SqlConnection1
            Me.SqlCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("PK_RequestID", SqlDbType.Int, ParameterDirection.Output))
            Me.SqlCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Request", System.Data.SqlDbType.Text, 16, "LoginID"))
            Me.SqlCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@User", System.Data.SqlDbType.VarChar, 50, "UserName"))
    Last edited by FishGuy; May 5th, 2005 at 08:49 AM. Reason: Resolved

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width