How i can use "IN CLUASE" with block fields.

[asimtalib]

Hi everyone

I am facing problem when i want to try select the data from table and i am using
IN CLAUSE but with block fields for e.g

SELECT
<COLUMN NAME>
FROM
<TABLE NAME>
WHERE
--sys_sno in (5,6);
and sys_sno in (:sno);

So please tell me how i can IN CLAUSE in select statement but using BLOCK.FIELD.

Remember one thing " sys_sno " is number fields.

[debasisdas]

are you passing comma separated value through the variable ?

[asimtalib]

are you passing comma separated value through the variable ?

Yes actually i want to fetch record through listing searching.

for e.g

sys_sno in (1,2,3,4,5) < This is HARD CODE >

but i want to try this

sys_sno in (:sno) ( during Run Time)

User will input on Run Time.

[amitpatel66]

Yes actually i want to fetch record through listing searching.

for e.g

sys_sno in (1,2,3,4,5) < This is HARD CODE >

but i want to try this

sys_sno in (:sno) ( during Run Time)

User will input on Run Time.

What is the error that it is throwing?

[asimtalib]

What is the error that it is throwing?

No error throw but DATA NOT FOUND


How i can listing searching through block fields.


plz anyone know so help me...


i m waiting for Your's reply.

[amitpatel66]

No error throw but DATA NOT FOUND


How i can listing searching through block fields.


plz anyone know so help me...


i m waiting for Your's reply.

A variable cannot be used in that way for IN clause. Check here