|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-13 : 20:01:02
|
Dilip writes "
/****** Object: Stored Procedure dbo.proc_JobsInsert Script Date: 12/18/2000 10:45:14 PM ******/
CREATE PROCEDURE [proc_JobsInsert]
(
-- Validate Parameters
@JobStatusID [int],
@JobLengthTypeID [int],
@CompanyID [int],
@Qualifications [text],
@Title [varchar](75),
@Location [varchar](75),
@StartDate [datetime],
@EndDate [datetime],
@Description [text],
@ExperienceID [int],
@EducationTypeID [int],
@TravelID [int],
@PayID [int],
@RelocationCovered [bit]
)
AS
SET NOCOUNT ON
INSERT INTO [Jobs_JO]
(
[JobStatusID],
[JobLengthTypeID],
[CompanyID],
[Qualifications],
[Title],
[Location],
[StartDate],
[EndDate],
[Description],
[ExperienceID],
[EducationTypeID],
[TravelID],
[PayID],
[RelocationCovered])
VALUES
(
@JobStatusID,
@JobLengthTypeID,
@CompanyID,
@Qualifications,
@Title,
@Location,
@StartDate,
@EndDate,
@Description,
@ExperienceID,
@EducationTypeID,
@TravelID,
@PayID,
@RelocationCovered
)
Set noCount off
Select @@identity
Hi,
The above stored procedure does not return any value/Record set when called from VB or ASP. Can u tell me what is the problem.
The vb code is
rs.open(ssql, connection)
the recordset always comes back closed with no data
Thanxs
Dilip" |
|
Returning Identity