|
|
|
|
| Re: when mouse Double click [message #380349 is a reply to message #380322] |
Sun, 11 January 2009 03:28   |
shahzaib_4vip@hotmail.com
Messages: 410
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 #380369 is a reply to message #380322] |
Sun, 11 January 2009 07:32 |
shahzaib_4vip@hotmail.com
Messages: 410
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 #380374 is a reply to message #380322] |
Sun, 11 January 2009 08:02 |
shahzaib_4vip@hotmail.com
Messages: 410
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 #380685 is a reply to message #380374] |
Tue, 13 January 2009 00:18 |
|
|
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 1026 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 |
shahzaib_4vip@hotmail.com
Messages: 410
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 1018 times)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
