Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Question Unanswered: Access Not Executing Stored Procedure correctly

    Hi guys I cant seem to get my stored procedure to execute properly through Access Xp. Do you think there is something wrong with my stored procedure??

    Code:
    CREATE PROCEDURE [insert_ConditionalLicense_UpdateFromTerms]
    	(@TM_#	 	[int],
    	 @FirstName 	[nvarchar](50),
    	 @LastName 	[nvarchar](50),
    	 @SS#	 	[nvarchar](50),
    	 @Birthdate 	[nvarchar](50),
    	 @reasonforconditional 	[ntext],
    	 @Notes 	[ntext])
    
    AS INSERT INTO [GamingCommissiondb].[dbo].[ConditionalLicense_View] 
    	 ( [TM #],
    	 [FirstName],
    	 [LastName],
    	 [SS#],
    	 [reasonforconditional],
    	 [ConditionalStart Date]) 
    	 
     
    SELECT	 
    	 [TM#],
    	 [LASTNAME],
    	 [FIRSTNAME],
    	 [SSN#],
    	 [NOTES],
    	 [DATEOFCONDITIONAL]
    
    FROM EmployeeGamingLicense 
    WHERE STATUS = 'TERMINATION-COND'
    IF @@Error <> '0'
    RETURN
    when I execute it through a command button this is the message I get "paramater" not quite sure why I am getting this message
    Last edited by desireemm; 04-15-09 at 17:23.

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    You have to provide the parameters on the call you are making with the "on click" action. Otherwise, it will prompt you for them.

    ???
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  3. #3
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Hmmm

    Well I have the same kind of stored procedure on another form and it doesnt do that. I have a stored procedure on the Termination form that executes once the users press the command button. Hmm??

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    No. There has to be some difference between the two. Look at them closely to find it.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    oK

    Ok I will take a closer look at my stored procedure. I'll try again thanks guys

  6. #6
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    oK

    Ok I will take a closer look at my stored procedure. I'll try again thanks guys

Posting Permissions

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