Home » Developer & Programmer » Reports & Discoverer » Exect Fetch
Exect Fetch [message #309954] Sun, 30 March 2008 10:08 Go to next message
*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh
Senior Member
How to fetch the extact query in reports....

----------------------------------------- -------- ------------------
ID_NO NOT NULL VARCHAR2(15)
USERNAME NOT NULL VARCHAR2(30)
MOBILE# NUMBER(15)
TEL# NUMBER(10)
EXT# NUMBER(6)
EMAIL1 VARCHAR2(50)
EMAIL2 VARCHAR2(50)
DEPT VARCHAR2(20)
EMP_PIC LONG RAW
MOBILE#2 NUMBER(15)
HOME_TEL NUMBER(15)
JOB_TITLE VARCHAR2(30)
LOCATION VARCHAR2(20)

i wanna to fetch the record through ID # in report how to fetch i try to user parameter but it shows all items,
i wanna to fetch the exact record by ID no support if user enter the ID no it will fetch the exact record. how to fetch please help

Regards
Re: Exect Fetch [message #309969 is a reply to message #309954] Sun, 30 March 2008 15:51 Go to previous messageGo to next message
Littlefoot
Messages: 21148
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Yes, you should use a parameter.

If you did that but got all records instead of just one, then you did something wrong. Without knowing the exact query you used and possible additional information (parameter datatype, sample data etc.), it is impossible to guess what is the reason of a failure.
Re: Exect Fetch [message #310192 is a reply to message #309954] Mon, 31 March 2008 09:19 Go to previous message
*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh
Senior Member
Thanks little its solved.......
Previous Topic: Reports
Next Topic: Referencing column from lower group
Goto Forum:
  


Current Time: Mon Aug 21 13:01:50 CDT 2017

Total time taken to generate the page: 0.09226 seconds