OraFAQ Forum: Forms » How to compare two text boxes with IN operator form

Home » Developer & Programmer » Forms » How to compare two text boxes with IN operator form (Oracle Forms6i,Oracle 11g,Windows Server 2008)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to compare two text boxes with IN operator form [message #557355]

Tue, 12 June 2012 02:17

jolly_makkar
Messages: 63
Registered: March 2008

Member

Dear all

How we can compare IN operator between two text boxes in form

I have two text boxes on form
control.txt1 - 003

control.txt2 - 001,002,003

On button pressed

if :control.txt1 in (:CONTROL.TXT2) THEN
	MESSAGE('1');
	MESSAGE('1');
	
else
	
	MESSAGE('0');
	MESSAGE('0');
END IF;

All the time Message is 0 .Please suggest what mistake i should rectify to get 1.

Report message to a moderator

Re: How to compare two text boxes with IN operator form [message #557381 is a reply to message #557355]

Tue, 12 June 2012 06:25

cookiemonster
Messages: 13925
Registered: September 2008
Location: Rainy Manchester

Senior Member

Use instr

Report message to a moderator

Re: How to compare two text boxes with IN operator form [message #557400 is a reply to message #557381]

Tue, 12 June 2012 08:12

sandeepgujje
Messages: 28
Registered: January 2012
Location: India

Junior Member

Yes, As suggested by cookiemonster, INSTR will work fine

use the below code,

DECLARE 
  v_val NUMBER;
BEGIN
  v_val := INSTR(:control.txt2, :control.txt1);

  IF nvl(v_val, 0) = 0 THEN
    MESSAGE('0'); PAUSE;
  ELSE
    MESSAGE('1'); PAUSE;
  END IF;
END;

Report message to a moderator