OraFAQ Forum: Forms » problem with inserting record

Home » Developer & Programmer » Forms » problem with inserting record

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

problem with inserting record [message #133404]

Thu, 18 August 2005 22:56

nselangovan
Messages: 11
Registered: August 2005

Junior Member

i am new user.

My Table description is

SQL> desc tool_imwd
Name Null? Type
------------------------------- -------- ----
TIMW_NUMBER NOT NULL NUMBER(5)
TIMW_SLNO NOT NULL NUMBER(2)
TIMW_DATE NOT NULL DATE
TIMW_WD NOT NULL CHAR(2)
TIMW_DBNO NUMBER(5)
TIMW_TOOL_CODE NOT NULL VARCHAR2(13)
TIMW_ITEM_DESC NOT NULL VARCHAR2(40)
TIMW_SRVNO NUMBER(5)
TIMW_SRVSLNO NUMBER(2)
TIMW_SRVDATE DATE
TIMW_PONO NUMBER(9)
TIMW_PODATE DATE
TIMW_DBQTY NOT NULL NUMBER(4)
TIMW_SUPCD VARCHAR2(3)
TIMW_SUPP_NAME VARCHAR2(40)
TIMW_RECEIPT_IND VARCHAR2(1)
CREATE_DATE NOT NULL DATE

am using forms9i for application development.
i kept some field(coloumn) in different canvas,and different block. while inserting record it shows

40735::: when-button-pressed trigger raised unhandle exception
ora-01400.how to insert record

Report message to a moderator

Re: problem with inserting record [message #133417 is a reply to message #133404]

Fri, 19 August 2005 00:15

kiran
Messages: 503
Registered: July 2000

Senior Member

Usually this error comes when you try to "insert a null in not null column".
This may be the reason that you are getting the exception.

Can you paste the code that you have written for your form.

--Kiran.

Report message to a moderator

Re: problem with inserting record [message #133697 is a reply to message #133404]

Sun, 21 August 2005 17:22

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

You do not need to use a second block if all you want to do is put fields on a different canvas. Blocks and canvases do not have to be 'paired'. That is, you can data from several blocks on a single canvas and vice versa, one block on many canvases.

I suggest that you put all the fields from a particular table into the one block.

David

Report message to a moderator

Previous Topic:	PLZ Refer me the SITE for Oracle form Tutorial
Next Topic:	Deploying Forms & Reports for web-Urgent

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 23:14:58 CDT 2024