OraFAQ Forum: Forms » who search by 2 values in forms

Home » Developer & Programmer » Forms » who search by 2 values in forms

Mon, 19 February 2007 05:37

farooq112
Messages: 90
Registered: September 2006
Location: cairo

Member

hi everone

h wont ask who do searh by 2 item

i do before but one item

pls help me

exm

Tue, 20 February 2007 01:11

saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn

Senior Member

hi,
Instead of this code:

begin
set_block_property('employees',onetime_where,'DEPARTMENT_ID ='||:block3.do);
go_block('employees');
execute_query;
end;

Write this:

GO_BLOCK('EMPLOYEES');
SET_BLOCK_PROPERTY('EMPLOYEES', DEFAULT_WHERE, 'DEPARTMENT_ID = '||:BLOCK3.do||' AND SALARY = '||:BLOCK3.sal);
EXECUTE_QUERY;

For your forms question regarding images, download and open the form in forms 10g.

regards,
Saadat Ahmad

Wed, 21 February 2007 09:10

farooq112
Messages: 90
Registered: September 2006
Location: cairo

Member

saadatahmad u r great mam

u r angle

Previous Topic:	SHOWING DISTINCT COLUMN
Next Topic:	To get item name dynamically and set a value to it

Goto Forum:

]

Current Time: Sun Feb 02 09:54:26 CST 2025