OraFAQ Forum: Forms » Access to other form's items

Home » Developer & Programmer » Forms » Access to other form's items

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

Access to other form's items [message #195943]

Tue, 03 October 2006 04:36

Law78
Messages: 2
Registered: September 2006

Junior Member

Hi,

I would like to know if it's possible to look into a form X (that's doesn't running!) from a form Y (that's is running). I need to know the item inside the form X from a form Y.

I think it's impossible, I need to call it ? Anyone can attach an example to search for an item in a form X from a form Y ?

Thank you!

Report message to a moderator

Re: Access to other form's items [message #195968 is a reply to message #195943]

Tue, 03 October 2006 06:36

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If you need that value, why don't you select it?

SELECT column_value
INTO variable -> global one, perhaps? Parameter?
FROM ...

and use it wherever needed.

Report message to a moderator

Re: Access to other form's items [message #196357 is a reply to message #195968]

Thu, 05 October 2006 02:12

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

If the form is not running, then the form's item does not exist in the 'space' of your session. If this was a question asked of you then I think someone was pulling your leg.

David

Report message to a moderator

Re: Access to other form's items [message #196393 is a reply to message #195943]

Thu, 05 October 2006 03:44

shahidmughal
Messages: 91
Registered: January 2006
Location: Faisalabad Pakistan

Member

hi
this is only possible
when you are using
global variables

you should use global variable which will take the value from one form to the other.

i hope this will work.

regards

Muhammad Shahid Mughal

Report message to a moderator

Re: Access to other form's items [message #197063 is a reply to message #196393]

Mon, 09 October 2006 19:08

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

This assumes that you have opened the form and then closed it, and not terminated your overall session. If it has never been opened then it doesn't exist. Alternatively, store the data in a table and access it as you need.

David

Report message to a moderator

Re: Access to other form's items [message #197100 is a reply to message #197063]

Tue, 10 October 2006 01:22

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

That's what I've said in post #195968: select data directly from the table.

Report message to a moderator

Re: Access to other form's items [message #197113 is a reply to message #197100]

Tue, 10 October 2006 02:01

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

True, but my meaning was write the transitory data from form1 and read it from form2. I interpreted your thread to mean that the data exists always in database.

David

Report message to a moderator

Previous Topic:	Using DBMS_LDAP in ON-LOGON Trigger
Next Topic:	BEANS in forms 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:28:38 CDT 2024