Home » Developer & Programmer » Forms » who search by 2 values in forms
who search by 2 values in forms [message #220172] Mon, 19 February 2007 05:37 Go to next message
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
  • Attachment: serch.fmb
    (Size: 52.00KB, Downloaded 188 times)
Re: who search by 2 values in forms [message #220284 is a reply to message #220172] Tue, 20 February 2007 01:11 Go to previous messageGo to next message
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
Re: who search by 2 values in forms [message #220661 is a reply to message #220284] Wed, 21 February 2007 09:10 Go to previous message
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 Dec 04 18:34:15 CST 2016

Total time taken to generate the page: 0.07861 seconds