Home » Developer & Programmer » Forms » form trigger regarding mouse click.
form trigger regarding mouse click. [message #598730] Thu, 17 October 2013 03:08 Go to next message
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
Re: form trigger regarding mouse click. [message #598735 is a reply to message #598730] Thu, 17 October 2013 05:04 Go to previous messageGo to next message
mughals_king
Messages: 390
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
Re: form trigger regarding mouse click. [message #598736 is a reply to message #598735] Thu, 17 October 2013 05:12 Go to previous messageGo to next message
mughals_king
Messages: 390
Registered: January 2012
Location: pakistan
Senior Member
and don't forget to fire TRIGGER WHEN_MOUSE-CLICK in these three fields

empno,name,position.

Re: form trigger regarding mouse click. [message #598737 is a reply to message #598735] Thu, 17 October 2013 05:13 Go to previous messageGo to next message
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..
Re: form trigger regarding mouse click. [message #598743 is a reply to message #598737] Thu, 17 October 2013 06:08 Go to previous messageGo to next message
mughals_king
Messages: 390
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

[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 Go to previous messageGo to next message
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
Re: form trigger regarding mouse click. [message #598762 is a reply to message #598746] Thu, 17 October 2013 09:08 Go to previous messageGo to next message
mughals_king
Messages: 390
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 Go to previous messageGo to next message
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.
Re: form trigger regarding mouse click. [message #598767 is a reply to message #598762] Thu, 17 October 2013 09:48 Go to previous messageGo to next message
mughals_king
Messages: 390
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

[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 Go to previous messageGo to next message
mughals_king
Messages: 390
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
Re: form trigger regarding mouse click. [message #598770 is a reply to message #598768] Thu, 17 October 2013 10:03 Go to previous messageGo to next message
mughals_king
Messages: 390
Registered: January 2012
Location: pakistan
Senior Member
after insertion the data must type commit i forgot to type. Cool

commit;
Re: form trigger regarding mouse click. [message #598849 is a reply to message #598770] Fri, 18 October 2013 06:13 Go to previous messageGo to next message
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.
Re: form trigger regarding mouse click. [message #598865 is a reply to message #598849] Fri, 18 October 2013 09:07 Go to previous messageGo to next message
mughals_king
Messages: 390
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 Go to previous messageGo to next message
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
Re: form trigger regarding mouse click. [message #599315 is a reply to message #599295] Wed, 23 October 2013 10:52 Go to previous messageGo to next message
Littlefoot
Messages: 19887
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?
Re: form trigger regarding mouse click. [message #599321 is a reply to message #599315] Wed, 23 October 2013 11:43 Go to previous messageGo to next message
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
Re: form trigger regarding mouse click. [message #599323 is a reply to message #599321] Wed, 23 October 2013 11:48 Go to previous message
Littlefoot
Messages: 19887
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.
Previous Topic: validation
Next Topic: Webutil_Host.Host Issue
Goto Forum:
  


Current Time: Fri Dec 19 05:12:21 CST 2014

Total time taken to generate the page: 0.23138 seconds