Home » Developer & Programmer » Forms » when mouse Double click (10g, developer 6I window Xp)
icon1.gif  when mouse Double click [message #380322] Sat, 10 January 2009 12:55 Go to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
Hi Experts,

I create 2 data block both are emp 1st with form style and 2nd with Tablour style now i need when i run form its already execute all record of emp table and when i double click on particular empno or empname or any other field of emp table its show the particular record which i double click in form style emp block. The canvas is same

Hope you understand

The fmb file is attach

Thanks

Shahzaib ismail
  • Attachment: emp.fmb
    (Size: 48.00KB, Downloaded 172 times)
Re: when mouse Double click [message #380341 is a reply to message #380322] Sun, 11 January 2009 01:09 Go to previous messageGo to next message
javed.khan
Messages: 340
Registered: November 2006
Location: Banglore
Senior Member

Please Find Attched Form for Reference.
Thanks & Regards
Javed A. Khan
Almarai
Riyadh KSA
  • Attachment: EMP.fmb
    (Size: 48.00KB, Downloaded 143 times)
Re: when mouse Double click [message #380349 is a reply to message #380322] Sun, 11 January 2009 03:28 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
@ Javaid

Thanks for your help its work and its solve my problem but


i need this stuation for editing my record so i don't want to execute all record in emp table i just want to execute record for a employee which emp no i double click and also want to update this employee record

Any way

Thanks for your Help



Shahzaib ismail
Re: when mouse Double click [message #380355 is a reply to message #380322] Sun, 11 January 2009 05:00 Go to previous messageGo to next message
javed.khan
Messages: 340
Registered: November 2006
Location: Banglore
Senior Member

Ok How about This..Is that Same what u needed?
  • Attachment: EMP.fmb
    (Size: 48.00KB, Downloaded 144 times)
Re: when mouse Double click [message #380369 is a reply to message #380322] Sun, 11 January 2009 07:32 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
Thanks javaid for your help


I need when i double click on particular emp record at tabulor style block

and his record open at form style block where i will update those record and then save form type block


Hope you understand


Shahzaib
Re: when mouse Double click [message #380372 is a reply to message #380322] Sun, 11 January 2009 07:50 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
ok i got your file and its working my mistake i apologies


Thanks you javaid


Shahzaib
Re: when mouse Double click [message #380374 is a reply to message #380322] Sun, 11 January 2009 08:02 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
@ Javaid


your fmb file is working well i have a question if i want to update a record which i double click how can i do? for exmaple

empno 7876 i want to rename of empno 7876 i need when i double click the perticular no its show me his record and then i change his name and save his record i used a button which name is edit and enter the update query which is

update emp
set empno=:emp1.empno;
update emp
set ename=:emp1.ename;
update emp
set job=:emp1.job;
update emp
set mgr=:emp1.mgr;
update emp
set hiredate=:emp1.hiredate;
update emp
set sal=:emp1.sal;
update emp
set comm=:emp1.comm;
update emp
set deptno=:emp1.deptno;
update emp
set unactive=:emp1.unactive;

But its not working

i need
Double click the perticuar empno and
entery_query and change his name then save


Hope you understand


Thanks

Shahzaib
Re: when mouse Double click [message #380434 is a reply to message #380374] Sun, 11 January 2009 23:14 Go to previous messageGo to next message
javed.khan
Messages: 340
Registered: November 2006
Location: Banglore
Senior Member

Please let me know if its working with default Save button on Toolbar?
Re: when mouse Double click [message #380440 is a reply to message #380322] Sun, 11 January 2009 23:28 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
its give me error unable to update and insert reocord




Shahzaib
Re: when mouse Double click [message #380506 is a reply to message #380440] Mon, 12 January 2009 02:19 Go to previous messageGo to next message
javed.khan
Messages: 340
Registered: November 2006
Location: Banglore
Senior Member

Can you post me the copy of your Form?
Re: when mouse Double click [message #380593 is a reply to message #380322] Mon, 12 January 2009 08:08 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
@ JAvaid

Please find the attachment of copy FMB


  • Attachment: EMP.fmb
    (Size: 56.00KB, Downloaded 148 times)
Re: when mouse Double click [message #380685 is a reply to message #380374] Tue, 13 January 2009 00:18 Go to previous messageGo to next message
javed.khan
Messages: 340
Registered: November 2006
Location: Banglore
Senior Member

Shahzaib it will Update all your Records

[b
update emp
set empno=:emp1.empno;
update emp
set ename=:emp1.ename;
update emp
set job=:emp1.job;
update emp
set mgr=:emp1.mgr;
update emp
set hiredate=:emp1.hiredate;
update emp
set sal=:emp1.sal;
update emp
set comm=:emp1.comm;
update emp
set deptno=:emp1.deptno;
update emp
set unactive=:emp1.unactive;
[/b]




Write this in your Update atleast u need a Join
		update emp 
		set empno	=:emp1.empno		,
		ename		=:emp1.ename		,
		mgr		=:emp1.mgr	        ,
		hiredate	=:emp1.hiredate	        ,
		sal		=:emp1.sal		,
		comm		=:emp1.comm		,
		deptno		=:emp1.deptno		,
		unactive	=:emp1.unactive
		where	empno=:emp.empno;
		
COMMIT;	



U Can Take this form for refrence attached here. I have modified with Update Button.

Enjoy
Javed
Riyadh KSA
  • Attachment: EMP.fmb
    (Size: 52.00KB, Downloaded 131 times)

[Updated on: Tue, 13 January 2009 00:23]

Report message to a moderator

Re: when mouse Double click [message #380824 is a reply to message #380322] Tue, 13 January 2009 08:41 Go to previous message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
@ javaid its not work yar

Any way i done it with a little change


I create relation ship with both of emp block with empno and change trigger in save button
Quote:
update emp
set
ename =:emp1.ename ,
mgr =:emp1.mgr ,
hiredate =:emp1.hiredate ,
sal =:emp1.sal ,
comm =:emp1.comm ,
deptno =:emp1.deptno ,
unactive =:emp1.unactive
where empno=:emp.empno and
:emp1.empno=emp.empno;
COMMIT;






and its work

Any way thanks for provide me so much information


Shahzaib
  • Attachment: EMP(2).fmb
    (Size: 112.00KB, Downloaded 149 times)
Previous Topic: Trigger Fired at particular Date ?
Next Topic: Preview pictures with Windows Picture And Fax Viewer in Forms 6i
Goto Forum:
  


Current Time: Sat Dec 03 00:59:53 CST 2016

Total time taken to generate the page: 0.11219 seconds