Home » Developer & Programmer » Forms » any suggestion for my forms (windows XP)
any suggestion for my forms [message #352758] Thu, 09 October 2008 06:36 Go to next message
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 #352759 is a reply to message #352758] Thu, 09 October 2008 06:51 Go to previous messageGo to next message
Littlefoot
Messages: 21821
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
the forms does not saved the real data into the database

What does it save, then?
Re: any suggestion for my forms [message #352788 is a reply to message #352759] Thu, 09 October 2008 10:44 Go to previous messageGo to next message
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 #353093 is a reply to message #352788] Sat, 11 October 2008 05:48 Go to previous messageGo to next message
expertsudhir
Messages: 26
Registered: October 2008
Location: Delhi, India
Junior Member

please send all the table structure.
Re: any suggestion for my forms [message #353968 is a reply to message #352788] Wed, 15 October 2008 22:55 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you got this form working or not?

David
Re: any suggestion for my forms [message #353970 is a reply to message #352758] Wed, 15 October 2008 23:15 Go to previous message
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
Previous Topic: Dcoumentation of Forms
Next Topic: how can i generate a calculator in forms6i
Goto Forum:
  


Current Time: Sat Nov 09 16:17:31 CST 2024