Click here to Skip to main content
15,877,246 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
<pre lang="c#">i am making payroll software but i m facing some problem when i making salary of employee how can i check that attendance table fill or not</pre>
Posted
Comments
AditSheth 17-Sep-11 0:34am    
What is your table structure of salary and attendance.. if both table have common column of employee ID?

1 solution

there are many ways for doing this..

but simple way is that..

before you perform any operation of salary you need first fire a select query based on your where criteria and if that select query returns any thing then its confirm you that some thing in attendance table and do what you want with salary or attendance table.....

or is select query is not returning any thing then do what you want...


this is the simple way..
but there is many way as i said at starting try to make PLSql logic in your store procedure or with functions or trigger
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900