OraFAQ Forum: Forms » inserton problem.

Home » Developer & Programmer » Forms » inserton problem. (form 6i)

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

inserton problem. [message #603999]

Sun, 22 December 2013 08:03

shahzad-ul-hasan
Messages: 615
Registered: August 2002

Senior Member

Add arrears and insert months in fee table.please see the attached fmb file. The picture i have atatched is the fees table in which i insrt data from the fmb. /forum/fa/11475/0/

Attachment: feeinsert.fmb
(Size: 60.00KB, Downloaded 1158 times)

Report message to a moderator

Re: inserton problem. [message #604000 is a reply to message #603999]

Sun, 22 December 2013 08:11

shahzad-ul-hasan
Messages: 615
Registered: August 2002

Senior Member

file is missing in th above message. /forum/fa/11477/0/

Attachment: 13.JPG
(Size: 55.02KB, Downloaded 1269 times)

Report message to a moderator

Re: inserton problem. [message #604002 is a reply to message #604000]

Sun, 22 December 2013 08:57

cookiemonster
Messages: 13923
Registered: September 2008
Location: Rainy Manchester

Senior Member

I have no idea from looking at that picture what your problem actually is.

Report message to a moderator

Re: inserton problem. [message #604003 is a reply to message #604002]

Sun, 22 December 2013 09:51

shahzad-ul-hasan
Messages: 615
Registered: August 2002

Senior Member

When i press the fee insert button(from fmb file) it will insert nothing. becoz of first record.when i remove the sno from the button code it will insert the record. but when i press another record it will not pickup the previouseunpaid fees into new record(arrears).please advised.

Report message to a moderator

Re: inserton problem. [message #604167 is a reply to message #604003]

Wed, 25 December 2013 07:32

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

Dear have you solved your problem if not then upload your table structure

Regard
Mughal

Report message to a moderator

Re: inserton problem. [message #604218 is a reply to message #604167]

Thu, 26 December 2013 06:36

shahzad-ul-hasan
Messages: 615
Registered: August 2002

Senior Member

Here is the fee Structure: and fees fmb file.(the feeinsert fmb file already uploaded.

SQL> desc fees
 Name                                      Null?    Type
 ----------------------------------------- -------- -----------------
 FAM_ID                                             NUMBER(7)
 STUID                                              NUMBER(8)
 SNO                                                NUMBER(6)
 CHL_NO                                             NUMBER(7)
 FDATE                                              DATE
 FMONTH                                             VARCHAR2(25)
 TMONTH                                             VARCHAR2(25)
 FYEAR                                              NUMBER(5)
 ADM                                                NUMBER(5)
 REGIST                                             NUMBER(5)
 FTUTION                                            NUMBER(7)
 ANNUAL                                             NUMBER(5)
 FINE                                               NUMBER(5)
 OTHER                                              NUMBER(6)
 TOT                                                NUMBER(7)
 ARREAR                                             NUMBER(7)
 PAID                                               NUMBER(7)
 BAL                                                NUMBER(7)
 REMAK                                              VARCHAR2(120)
 FSTAT                                              VARCHAR2(30)

[EDITED by LF: applied [code] tags]

Attachment: Fees.fmb
(Size: 136.00KB, Downloaded 1115 times)

[Updated on: Thu, 26 December 2013 09:58] by Moderator

Report message to a moderator

Re: inserton problem. [message #604232 is a reply to message #604003]

Thu, 26 December 2013 08:32

cookiemonster
Messages: 13923
Registered: September 2008
Location: Rainy Manchester

Senior Member

shahzad-ul-hasan wrote on Sun, 22 December 2013 15:51

When i press the fee insert button(from fmb file) it will insert nothing.

So it would be a good idea if you shared the button code with us.

shahzad-ul-hasan wrote on Sun, 22 December 2013 15:51

becoz of first record.when i remove the sno from the button code it will insert the record.

Since we have no idea what sno does in the button code that's not particularly helpful.

shahzad-ul-hasan wrote on Sun, 22 December 2013 15:51

but when i press another record it will not pickup the previouseunpaid fees into new record(arrears).please advised.

Why would it do that?

We know nothing about your form code or what it's supposed to do apart from what you tell us.
And you've told us very little.
More details are required.

[Updated on: Thu, 26 December 2013 08:32]

Report message to a moderator

Re: inserton problem. [message #604242 is a reply to message #604232]

Thu, 26 December 2013 11:54

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

Yes @cookiemonster is right need more details required.

What do you get from this??? can you tell us?

select nvl(S.Stuid,0),nvl(S.Tuition,0),F.FAM_ID,nvl(ff.sno,0)
from student s,family f,fees ff
where LTRIM(s.stuid)=RTRIM(ff.stuid) AND S.FAM_ID = f.fam_id
and ff.fam_id=f.fam_id
order by s.stuid;

Regard
Mughal

Report message to a moderator

Re: inserton problem. [message #604258 is a reply to message #604242]

Thu, 26 December 2013 23:14

shahzad-ul-hasan
Messages: 615
Registered: August 2002

Senior Member

i want to insert the month fees from fee insert fmb. the purpose of this above query is to check the data is null then start from (sno)=1 and arrears=0. but if from and to month is not null and fees status is unpaidby any student then it will insert sno=2,3,4,....., arrears=2000 to current month every time button is pressed from fee insert fmb.
====================
Table structure for Student and family.

SQL> desc family
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 FAM_ID                                    NOT NULL NUMBER(7)
 FCNIC                                              VARCHAR2(30)
 F_NAME                                             VARCHAR2(300)
 MOBILE                                             VARCHAR2(30)
 PROFESS                                            VARCHAR2(100)
 MNAME                                              VARCHAR2(120)
 MCNIC                                              VARCHAR2(30)
 ADDRES                                             VARCHAR2(300)
 GUARD_NAME                                         VARCHAR2(200)
 GMOBILE                                            VARCHAR2(20)
 MON_INCM                                           NUMBER(8)
 CASTE                                              VARCHAR2(20)

SQL> desc student
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 FAM_ID                                             NUMBER(7)
 STUID                                     NOT NULL NUMBER(8)
 STATUS                                             VARCHAR2(20)
 CLASS                                              VARCHAR2(20)
 SECTION                                            VARCHAR2(20)
 SESION                                             VARCHAR2(20)
 ROLLNO                                             NUMBER(5)
 ADM_NO                                             NUMBER(7)
 NAME                                               VARCHAR2(250)
 GENDER                                             VARCHAR2(15)
 DOA                                                DATE
 DOB                                                DATE
 PRVSCHOOL                                          VARCHAR2(100)
 PRVCLASS                                           VARCHAR2(20)
 LEAV_DATE                                          DATE
 BOARD                                              VARCHAR2(100)
 GRUP                                               VARCHAR2(50)
 BRDREGNO                                           VARCHAR2(40)
 TUITION                                            NUMBER(6)
 COMENT                                             VARCHAR2(150)
 BAYFORM                                            VARCHAR2(25)
 ADM_CLASS                                          VARCHAR2(30)
 CONS_TYPE                                          VARCHAR2(60)
 COMENT1                                            VARCHAR2(300)
 RELIGION                                           VARCHAR2(30)

[EDITED by LF: applied [code] tags]

[Updated on: Fri, 27 December 2013 00:33] by Moderator

Report message to a moderator

Previous Topic:	Saving problem while moving from database block to non database block
Next Topic:	How to create a news bar using Forms 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 21:53:11 CDT 2024