any suggestion for my forms [message #352758] |
Thu, 09 October 2008 06:36 |
illpraydo
Messages: 7 Registered: October 2008 Location: Australia
|
Junior Member |
|
|
hello everyone ,
i am currently creating an oracle forms 6i to interract with the database oracle 8i
basically the forms has to be able to add/edit/delete,and print report
here is the structure of the database
timesheet_ employee has a primary key employee$
timesheet_project has a primary key project$
timesheet_task_on_project has primari key task_project$ and foreign keyproject$
timesheet_timeslot has a primary key timeslot$ and takes 3 foreign key from the other table
for the first time the forms work well until i added lov on the foreign key
the forms does not saved the real data into the database
i attached my code in this thread as well
I really need help since this is my first forms application,
|
|
|
|
Re: any suggestion for my forms [message #352788 is a reply to message #352759] |
Thu, 09 October 2008 10:44 |
illpraydo
Messages: 7 Registered: October 2008 Location: Australia
|
Junior Member |
|
|
suppose the query for the table
timesheet_task_on_project
consist of
task_project$ it will input sequence.nextval form trigger
task_info it will input user varchar name
active it will input the user value either 'y' , 'n' or 'd'
project$ it will definetely inserting null even though the user selected any value
|
|
|
|
|
Re: any suggestion for my forms [message #353970 is a reply to message #352758] |
Wed, 15 October 2008 23:15 |
illpraydo
Messages: 7 Registered: October 2008 Location: Australia
|
Junior Member |
|
|
My form is working now thank you for asking
I find it hards to go back to this thread again,
Sorry if I ignore you expertsudhir,
I doesn't mean that since I do not knwo that this thread has a new reply, unless there is an email
Regards,
Alfredo
|
|
|