| How to pass parameter in query ( for in clause)? [message #386357] |
Fri, 13 February 2009 22:48  |
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
|
Senior Member |
|
|
Hi,
I write a cursor in when_button_pressed, query in cursor is
cursor empgrs is (Select a.emplcode,amount
from payfile a,emplmast b
where a.unitid = 1
and monthno = 4
and yearno = :Fyear - 1
and paycode = 'E97'
and a.emplcode = b.emplcode
and substr(b.catgcode,1,1) in (:Catg))
And Catg is prepared and passed via a screen and the code is
If Checkbox_Checked('ChkWorkmen') Then
:Catg := '''W''';
End If;
If Checkbox_Checked('Chkstaff') Then
If :Catg is not null Then
:Catg := :Catg||',''S'',''O''';
Else
:Catg := '''S'',''O''';
End If;
End If;
If Checkbox_Checked('ChkExec') Then
If :Catg is not null Then
:Catg := :catg||',''E''';
Else
:Catg := '''E''';
End if;
End if;
Catg is prepared based on checked checkbox( it have three check boxes worker,staff,executive)
final catg value may have passed like ({'W'},{'S','O'},{'E'}, {'W','S','O'} ect., )
even i passing such way im not getting any output on screen(even i am not having any compliation error also)
I have problem in passing catg
please help me to solve this issue.
kanish
|
|
|
|
|
|
| Re: How to pass parameter in query ( for in clause)? [message #386529 is a reply to message #386357] |
Mon, 16 February 2009 00:16  |
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
|
Senior Member |
|
|
Hi martin,
My screen is not datablock, so i fell, i cant use default_where, i write "message" to get the value of :catg that is working as per my requirement.
which i passed manualy in query which working perfectly
Select a.emplcode,amount
from payfile a,emplmast b
where a.unitid = 1
and monthno = 4
and yearno = :Fyear - 1
and paycode = 'E97'
and a.emplcode = b.emplcode
and substr(b.catgcode,1,1) in ('W','S','0)
but it is not working when i pass as parameter to where clause.
and substr(b.catgcode,1,1) in (:Catg)
kanish
|
|
|
|
|
|
|
|
|
|
| Re: How to pass parameter in query ( for in clause)? [message #386618 is a reply to message #386357] |
Mon, 16 February 2009 04:36 |
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
|
Senior Member |
|
|
HI
and ((:ChkWorkmen_checked = 'Y' and substr(b.catgcode,1,1) = 'Y')
or (:Chkstaff_checked = 'Y' and (substr(b.catgcode,1,1) in ('S','O'))
suppose both chkworkmen,chkstaff checked, i need like 'Y','S','O'
Are you instruct me to do combinations, like above.
It may clumsy,in case of more checkboxes.
and
Is this only the solution for me?
kanish
[Updated on: Mon, 16 February 2009 04:37] Report message to a moderator |
|
|
|
| Re: How to pass parameter in query ( for in clause)? [message #386635 is a reply to message #386357] |
Mon, 16 February 2009 05:41 |
cookiemonster
Messages: 13972
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
| Quote: | Are you instruct me to do combinations, like above
|
That was the idea.
| Quote: | It may clumsy,in case of more checkboxes.
|
the suggestion was based on the assumption that the code will stay as simple as your example.
| Quote: | Is this only the solution for me?
|
No - read the link
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
