Home » Developer & Programmer » Forms » problem in inserting  () 1 Vote
problem in inserting [message #197445] Wed, 11 October 2006 05:03 Go to next message
lalylatheef
Messages: 8
Registered: October 2006
Junior Member
i have two tabs employee wise and course wise. In the emplyee wise tab, the insert is working. but not in the course wise. the purpose of these tabs are for the convenience of the employees. ie. once course can be taken by the employees at one time. or one employee can take different courses at different times. here is the table and i have attached the form also. plz help


CREATE TABLE HR_TRAINING
(
EMP_ID VARCHAR2(10) NOT NULL,
COU_ID NUMBER(4) NOT NULL,
START_DATE DATE,
END_DATE DATE,
RESULT VARCHAR2(20),
REMARKS VARCHAR2(100),
MODI_USER VARCHAR2(50),
MODI_DATE DATE,
approved varchar2(3),
approved_by varchar2(15),
paid varchar2(3),
REF_NO VARCHAR2(3),
AMOUNT NUMBER(10,2))

/

[Updated on: Wed, 11 October 2006 06:43]

Report message to a moderator

Re: problem in inserting [message #197619 is a reply to message #197445] Thu, 12 October 2006 01:34 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Assuming that both tabs are based on the same table, are they using the same block? If you have two blocks (for two tabs) are you querying the table when changing tabs?

Wouldn't three tables - one for employee, one for course, and a cross-reference table combining the two IDs be a better way to go?

David
Re: problem in inserting [message #197638 is a reply to message #197619] Thu, 12 October 2006 02:18 Go to previous messageGo to next message
lalylatheef
Messages: 8
Registered: October 2006
Junior Member
i have total four blocks .. 2 in each tab

employee wise

control block: to to select the particular employee
training: to select the list of courses for that employee

course wise

control1: to select the particular course
training1: to select the list of employee for that course

you can check the form that i have attached. can ugive me the solution
Re: problem in inserting [message #197837 is a reply to message #197638] Thu, 12 October 2006 20:02 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I don't like your data structure design. Using your current approach you MUST commit your changes when moving from one tab to the other. Yo also have to requery the block as they are both based on the same table.

David
Previous Topic: checkbox
Next Topic: ORA-00600- INTERNAL CODE ERROR,ARGUMENTS
Goto Forum:
  


Current Time: Sat Dec 03 22:16:01 CST 2016

Total time taken to generate the page: 0.10287 seconds