| LOV Item [message #339302] |
Thu, 07 August 2008 04:39  |
*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh
|
Senior Member |
|
|
Hi guyz,
im facing some problem hope i will find the solution from oracle gurus,
i have this table
SYSTEM_MASTER;
SYSTEMID NOT NULL VARCHAR2(15)
USERNAME VARCHAR2(50)
ID_NO NUMBER(15)
DEPARTMENT VARCHAR2(30)
JOB_TITLE VARCHAR2(30)
SYSTEM_DOMAIN
SYSTEM_ID VARCHAR2(15)
DOMAIN_USER VARCHAR2(25)
CLIENT_IP VARCHAR2(15)
MAC_ADD VARCHAR2(30)
SHARED_FOLDER VARCHAR2(20)
PERSONAL_FOLDER VARCHAR2(20)
DOMAIN_NAME VARCHAR2(15)
I create one another table IP details and taking IP's from there using department_name is unique.
DEPARTMENT_NAME VARCHAR2(40)
ASSING_IP VARCHAR2(15)
form is working fine i create one LOV on Client_IP when i press the lov button on client_ip it will select the current department from system master and display the department wise ip.
how can i identify the current record which i didnt save what i put in system_master.department_name i cannot commit the record before giving client ip.
how can i resolve this issue?
waiting for good replies.
Regards
|
|
|
|
| Re: LOV Item [message #339363 is a reply to message #339302] |
Thu, 07 August 2008 06:32  |
tarekfathi2003
Messages: 23
Registered: August 2008
Location: kw
|
Junior Member |
|
|
you said:
how can i identify the current record which i didnt save what i put in system_master.department_name i cannot commit the record before giving client ip
sorry,I do not understand well
But i guee you need to save the records on the current session without commiting t on the Database.
If so, all you need is to use the oracle built_in "post" instead of "commit"
|
|
|
|
| Re: LOV Item [message #339871 is a reply to message #339302] |
Sat, 09 August 2008 04:19 |
*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh
|
Senior Member |
|
|
Yes you are rite Tarek i want to save save the current session. anyhow i will check and let u know...thanks for help...
Regards
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
