Home » Developer & Programmer » Forms » MANY BLOCKS IN ONE FORM
icon5.gif  MANY BLOCKS IN ONE FORM [message #223039] Wed, 07 March 2007 05:36 Go to next message
im99_chs
Messages: 14
Registered: November 2006
Junior Member
Good afternoon

I need your help. I have 7 tables in oracle. I have one form and 7 blocks for each table. Every block has text items and lists. I want to insert values to these elements and update their tables.
first of all when i press next record button it does not disappear all blocks values but one by one if i point to evry block.
Secondly when i am trying to exit my application it says that:
"FRM - 40508:ORACLE ERROR: UNABLE TO INSERT RECORD".

What i am doing wrong?
Please help me

Regards im99_chs

PS: I am trying to see the values of the tables in oracle sql* plus and nothing
Re: MANY BLOCKS IN ONE FORM [message #223172 is a reply to message #223039] Wed, 07 March 2007 20:32 Go to previous messageGo to next message
Smith_X
Messages: 56
Registered: January 2007
Member
You may click the menu when you run from to show your error

Normally, if you start everything from scratch. I think you should have problem with

1. Primary Key
2. Database Item that reference to no column

If you do not know how to create Primary Key, please use search first.

Next, if you have another items which those have no business with the data in table. You need to change those item to Database Item = 'no'

Hope this help
Re: MANY BLOCKS IN ONE FORM [message #225416 is a reply to message #223039] Mon, 19 March 2007 22:25 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Previous Topic: Form Problem
Next Topic: how save master and detail form same time
Goto Forum:
  


Current Time: Sun Dec 08 19:46:56 CST 2024