sql stored procedure insert data does not show up in database

[Andrew Leneway]

I have the follow SP in my database:

@SerialNum nvarchar(6),

@WorkOrderNo nvarchar(5),

@PartNo nvarchar(25),

@TestRunNo Int,

@FvCycTstNo int,

@TestType nvarchar(15),

@TestDate nvarchar(50),

@ConsoleNo nvarchar(5),

@OvenNo nvarchar(2),

@ChannelNo nvarchar(2),

@TestSteps nvarchar(40),

@TempSteps nvarchar(40),

@TempleteNo nvarchar(25)

AS

insert into SerialNoInfo(SerialNum,WorkOrderNo,PartNo,TestRunNo,fvCycTstNo,TestType,TestDate,ConsoleNo,OvenNo,ChannelNo,TestSteps,TempSteps,TempleteNo) values (@SerialNum,@WorkOrderNo,@PartNo,@TestRunNo,@fvCycTstNo,@TestType,@TestDate,@ConsoleNo,@OvenNo,@ChannelNo,@TestSteps,@TempSteps,@TempleteNo)

When i pass the following statment into the DB tools execute query.vi nothing shows up:

insertSerialNoInfo '248946 ',' 52542 ',' 211-37-790-04 ', 2.000000 , 2.000000 , ' Cal ',' 11/10/2008 ',' Wen5 ',' 3 ',' 3 ',' 1,2,3,4 ',' 75,150,250,350 ',' CS,4T,20,S,R_REVD '

I get no errors.

[seVEMes]

Please refer to the following knowledge base article and let me know if this addresses your ultimate question:

Knowledge Base 3229FMV3: How Do I Get Return Values of Stored Procedures in the Database Connectivit...