Home » Developer & Programmer » Forms » LOV Item (Windows XP Oracle 9i Dev 6i)
LOV Item [message #339302] Thu, 07 August 2008 04:39 Go to next message
*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 Go to previous messageGo to next message
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 Go to previous message
*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
Previous Topic: Query Problem
Next Topic: To attach a library in a Form
Goto Forum:
  


Current Time: Fri Dec 09 05:57:50 CST 2016

Total time taken to generate the page: 0.09620 seconds