Click here to Skip to main content
11,414,234 members (72,719 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# ASP.NET
i have used triger on table.This triger is fire when i insert data in LeaveFrom Table.In My Stored procedure if condition i have put.when i put if condition code in if condition is not working.If i remove if codition then insert work successfully.My I have try this code in Query builder.data is comming when if is fire.but what is problem in storeprocedure code,that i dont know.

My Triger is:
ALTER TRIGGER Trigger2
ON dbo.LeaveForm
 
AFTER INSERT
 
AS
Begin
EXEC Biometrics_InsertFrom_LeaveForm
End
 

My Storeprocedure is..
 
ALTER PROCEDURE dbo.Biometrics_InsertFrom_LeaveForm
	
 
AS
 

Declare @Count int
Declare @LeaveFrom datetime
Declare @LeaveTo datetime
Declare @Approve bit
set @Approve='True'
		select @Count=count(*) from LeaveForm where Approve=@Approve and (convert(varchar,@LeaveFrom,101)=convert(varchar,getdate(),101) or convert(varchar,@LeaveTo,101)=convert(varchar,getdate(),101))
	
		if(@Count > 0)
			   begin
			INSERT INTO Biometrics (PCL,PLE)
			VALUES        (getdate(),getdate())
 
end
	RETURN
Posted 4-Feb-13 21:59pm
Edited 4-Feb-13 22:00pm
v2
Comments
__TR__ at 5-Feb-13 3:06am
   
Looks like @Count is not greater than 0, hence the insert statement is not getting executed. Also you are not passing any dates to @LeaveFrom and @LeaveTo. If you use them in your query without passing any value it will be null and your query may not return any rows.
Use
Print @Count to check the value of @Count.

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

It works for me, so my assumption is that your WHERE condition is returning no records.
I'm not quite sure what you are trying to do, but the condition does look a bit rubbish. If you are trying to see in the current date is between two leave dates, then why not just use BETWEEN? Never convert dates to a string to compare them!
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 9,130
1 OriginalGriff 7,477
2 Maciej Los 3,710
3 Abhinav S 3,298
4 Peter Leow 3,084


Advertise | Privacy | Mobile
Web04 | 2.8.150427.2 | Last Updated 5 Feb 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100