OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » Exect Fetch

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

Exect Fetch [message #309954]

Sun, 30 March 2008 10:08

*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

Report message to a moderator

Re: Exect Fetch [message #309969 is a reply to message #309954]

Sun, 30 March 2008 15:51

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Exect Fetch [message #310192 is a reply to message #309954]

Mon, 31 March 2008 09:19

*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh

Senior Member

Thanks little its solved.......

Report message to a moderator

Previous Topic:	Need alternative method to export data from Oracle To Excel
Next Topic:	Master Details Report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 03:36:36 CST 2024