Home » Developer & Programmer » Forms » how get parameter wise view
how get parameter wise view [message #178272] Tue, 20 June 2006 07:28 Go to next message
mfa786
Messages: 210
Registered: February 2006
Location: karachi
Senior Member
hi mastere
sir i use this stetment for parameter view but it not proive result

create view fahm as select * from emp where deptno=&externalvariable

sir i need &externalvariable value from form

such as
externalvariable=sysdate

and run view then view give me only related date record

please give me idea

thank aamir

Report message to a moderator

Re: how get parameter wise view [message #178278 is a reply to message #178272] Tue, 20 June 2006 07:39 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
You cannot parametrize a view. A view is a stored SQL string. But if it is used in forms, play around with the DEFAULT_WHERE.

MHE

Report message to a moderator

Previous Topic: oracle forms and database triggers problem
Next Topic: go_record; go_item
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 09:41:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.