OraFAQ Forum: Forms » form trigger regarding mouse click.

Home » Developer & Programmer » Forms » form trigger regarding mouse click.

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

form trigger regarding mouse click. [message #598730]

Thu, 17 October 2013 03:08

nkumar0130
Messages: 55
Registered: August 2013
Location: Bangalore

Member

Hi,

Is there anyway in form that, if i click my mouse in any column of a rows then it will open another window which contain detail information about that column of a row.

For example:-
i am having two window emp and emp details.
In emp there is empno,name,position.
so when i click on empno or name or postion it will open emp detail window which contain the detail information about that employee.

Thanks

Report message to a moderator

Re: form trigger regarding mouse click. [message #598735 is a reply to message #598730]

Thu, 17 October 2013 05:04

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

Dear simple you have to pass parameter one form to other form by using global variable
and call your desire form but remember when you shall call form you must have to hide MDI Window ok if you are still confuse tell me. I will design & develop sample .FMB file according to your requirement.

Regard
Mughal

Report message to a moderator

Re: form trigger regarding mouse click. [message #598736 is a reply to message #598735]

Thu, 17 October 2013 05:12

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

and don't forget to fire TRIGGER WHEN_MOUSE-CLICK in these three fields

empno,name,position.

Report message to a moderator

Re: form trigger regarding mouse click. [message #598737 is a reply to message #598735]

Thu, 17 October 2013 05:13

nkumar0130
Messages: 55
Registered: August 2013
Location: Bangalore

Member

I am not calling any form i am just creating two window in one window it will give employee information and by clicking mouse on any of the empno number it will just open another window which is having employee details.
I hope you understand my requirement..
It will be great help to me if you have any fmb regarding above requirement..

Report message to a moderator

Re: form trigger regarding mouse click. [message #598743 is a reply to message #598737]

Thu, 17 October 2013 06:08

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

ok frnd take example .fmb

show_view('canvas');----stack canvas in same window
hide_view('canvas');

show_window('window');
hide_window('window');

just download FMB file and run

Regard
mughal

Attachment: SHOW_HIDE.fmb
(Size: 56.00KB, Downloaded 1146 times)

[Updated on: Thu, 17 October 2013 06:11]

Report message to a moderator

Re: form trigger regarding mouse click. [message #598746 is a reply to message #598743]

Thu, 17 October 2013 06:37

nkumar0130
Messages: 55
Registered: August 2013
Location: Bangalore

Member

Thanks Mughal for the example fmb.
But in my requirement there is no button.
In my requirement there is only mouse click,as i had said earlier when mouse click it will open second window with detail information and the previous window will not get closed it will remain there but in back of the second window. so when we close the second window then user can able to see the first window.

Thanks for your quick reply. Smile

Smile

Smile

Report message to a moderator

Re: form trigger regarding mouse click. [message #598762 is a reply to message #598746]

Thu, 17 October 2013 09:08

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

Dear example FMB doing same thing instead of button you just fired TRIGGER WHEN-MOUSE-CLICK
just right click on empno->Smart Trigger->other-select when-mouse-click

ok tell me one thing why you wanna open 2nd windows wanted to enter data or just wanna see details have you created relation between two tables or you don not need any relation between table. ok wait sometime i am sending you fmb just check is this your requirement.

before run this FMB create tables and insert data.

create table emp(empno varchar2(8) primary key,name varchar2(35),position varchar2(15));

create table emp_detail(empno varchar2(8),address varchar2(200),salary number(10,2),constraint emp_fk foreign key
(empno) references emp(empno));


insert into emp values('1001','Nitish','Manager');

insert into emp_detail values('1001','India',10000);

Regard
Mughal

[Updated on: Thu, 17 October 2013 09:46]

Report message to a moderator

Re: form trigger regarding mouse click. [message #598763 is a reply to message #598762]

Thu, 17 October 2013 09:14

nkumar0130
Messages: 55
Registered: August 2013
Location: Bangalore

Member

Its a requirement from the user.
suppose first window contain the employe few details like empno,empname and the emp address. so when user click on empno or empname or the emp address then it will open second window which contain detail information about the employee such as emp post, emp salary, emp personal details.
so that the user can able to edit those details.
That's y i want to open the 2nd window.

Report message to a moderator

Re: form trigger regarding mouse click. [message #598767 is a reply to message #598762]

Thu, 17 October 2013 09:48

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

rsorry i did not upload FMB just create tables and run this fmb

and feel free for any further queries

sorry i uploaded and did not changed the trigger and now download and run i have changed the trigger

Regard
Mughal

Attachment: SHOW_HIDE_EXAMPLE.fmb
(Size: 104.00KB, Downloaded 1154 times)

[Updated on: Thu, 17 October 2013 09:51]

Report message to a moderator

Re: form trigger regarding mouse click. [message #598768 is a reply to message #598767]

Thu, 17 October 2013 09:54

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

if you downloaded the fmb removed that now download because i changed the trigger when-mouse-click
mouse click any of these three field window will appear with details

Report message to a moderator

Re: form trigger regarding mouse click. [message #598770 is a reply to message #598768]

Thu, 17 October 2013 10:03

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

after insertion the data must type commit i forgot to type. Cool

Cool

commit;

Report message to a moderator

Re: form trigger regarding mouse click. [message #598849 is a reply to message #598770]

Fri, 18 October 2013 06:13

nkumar0130
Messages: 55
Registered: August 2013
Location: Bangalore

Member

Hi Mughal,

Thank you so much for the concept.
I tried the concept what you have provided me in .fmb file, one small issue is coming.after mouse click in window 1, window 2 is coming but it is coming behind the window 1. so is there any property i have to set so that after mouse click window 2 will come in front of window 1.

Report message to a moderator

Re: form trigger regarding mouse click. [message #598865 is a reply to message #598849]

Fri, 18 October 2013 09:07

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

Frnd its working fine here with me the 2nd window is appearing front of the first anyway do like this.


HIDE_WINDOW('WINDOW1');
SET_WINDOW_PROPERTY('WINDOW1', visible, property_false);

SHOW_WINDOW('WINDOW2');
go_block('emp_detail');
go_item('item_name');

or upload your fmb i shall check.

Hope this will help you

Regard
Mansoor

[Updated on: Fri, 18 October 2013 09:17]

Report message to a moderator

Re: form trigger regarding mouse click. [message #599295 is a reply to message #598865]

Wed, 23 October 2013 08:51

nkumar0130
Messages: 55
Registered: August 2013
Location: Bangalore

Member

Hi Mansoor,

The above solution helped me a lot.
I got one issue in the same form.
My form is in a table form, it contain 10 column. among 10 column 9 column is from one table and the remaining one column is form another table.
So to populate data into that one column i am using post-query trigger and inside that trigger i am creating a cursor and then populating the value in that column.

Can you please suggest whether my approach is correct or wrong.
please suggest me a solution for the above requirement.

Thanks

Report message to a moderator

Re: form trigger regarding mouse click. [message #599315 is a reply to message #599295]

Wed, 23 October 2013 10:52

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

Senior Member
Account Moderator

For querying purposes, yes - POST-QUERY is OK. However, you do not need a cursor (loop? Even worse!), simple SELECT statement would do.

Do you also insert data into another table through that column?

Report message to a moderator

Re: form trigger regarding mouse click. [message #599321 is a reply to message #599315]

Wed, 23 October 2013 11:43

nkumar0130
Messages: 55
Registered: August 2013
Location: Bangalore

Member

yes we have to insert and update data too through that column, I hope ON-INSERT and ON-UPDATE trigger will help me out for this.
If I am wrong then please let me know the appropriate solution.

Thanks

Report message to a moderator

Re: form trigger regarding mouse click. [message #599323 is a reply to message #599321]

Wed, 23 October 2013 11:48

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

Senior Member
Account Moderator

You could create a view (as a join of these two tables), create a form based on that view, and then populate tables using INSTEAD OF database trigger.

Report message to a moderator

Previous Topic:	validation
Next Topic:	Webutil_Host.Host Issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 22:44:40 CDT 2024