OraFAQ Forum: Forms » Problem in table updation

Home » Developer & Programmer » Forms » Problem in table updation

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

Problem in table updation [message #166885]

Mon, 10 April 2006 02:54

sarfraz_attari
Messages: 123
Registered: July 2005

Senior Member

Dear all

Please find a form attached

Sometimes I am facing two problems while running this form
1. I cant check duplicate record at the time of entry of part no(PART1,PART2,PART3 in form) due to which whenever user is saving record error message is coming because of primary key on table (tr_out_details) but it is not updating latest l_tr_out no due to which user is not able to create new transfer out.

2. sometimes l_tr_out field in sparts_lastno table become blank whenever user is trying to save the record.

Table Structures are as follows

Tr_out_header
 Name                            Null?    Type
 ------------------------------- -------- ----
 TROUT_NO                        NOT NULL VARCHAR2(10)
 TROUT_DT                        NOT NULL DATE
 DEST_LOC                        NOT NULL VARCHAR2(2)
 USER_ID                         NOT NULL VARCHAR2(10)
 WHOUSE_ID                                VARCHAR2(2)
 UPD_DT                                   DATE
 TR_IN_CHK_PRN                            CHAR(1)
 TRANS_IND                                CHAR(1)

SQL> desc tr_out_details
 Name                            Null?    Type
 ------------------------------- -------- ----
 PART1                                    VARCHAR2(5)
 PART2                                    VARCHAR2(5)
 PART3                                    VARCHAR2(5)
 QTY                                      NUMBER(10,3)
 LOCATION                                 VARCHAR2(15)
 TROUT_NO                                 VARCHAR2(10)
 WAVG_COST                                NUMBER(12,3)
 BAL_QTY                                  NUMBER(5)

SQL> desc sparts_lastno
 Name                            Null?    Type
 ------------------------------- -------- ----
 CR_RINVNO                                NUMBER(8)
 BS_LINV                                  NUMBER(8)
 L_TR_OUT                                 NUMBER(8)
 L_TR_IN                                  NUMBER(8)
 L_TR_OUT_HIL                             NUMBER(8)

Can anyone help me on these issues

Thanks

Sarfraz

Attachment: transfer_out.fmb
(Size: 216.00KB, Downloaded 972 times)

[Updated on: Mon, 10 April 2006 03:12] by Moderator

Report message to a moderator

Re: Problem in table updation [message #166895 is a reply to message #166885]

Mon, 10 April 2006 03:15

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

Senior Member
Account Moderator

Please, in the sticky it says, "for the table structure, provide DDL (CREATE TABLE, etc.) as appropriate instead of listing the table structure. It'll help people setting up a test set (yes, some people really do that)." That way we will get the primary key definitions.

David

Report message to a moderator

Previous Topic:	minimize a form and maximize a form
Next Topic:	Mass change Oracle Menu

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 06:44:27 CDT 2024