inserton problem. [message #603999] |
Sun, 22 December 2013 08:03 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shahzad-ul-hasan
Messages: 625 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.
|
|
|
|
|
Re: inserton problem. [message #604003 is a reply to message #604002] |
Sun, 22 December 2013 09:51 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shahzad-ul-hasan
Messages: 625 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.
|
|
|
|
Re: inserton problem. [message #604218 is a reply to message #604167] |
Thu, 26 December 2013 06:36 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shahzad-ul-hasan
Messages: 625 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 1204 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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
shahzad-ul-hasan wrote on Sun, 22 December 2013 15:51When 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 #604258 is a reply to message #604242] |
Thu, 26 December 2013 23:14 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
shahzad-ul-hasan
Messages: 625 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
|
|
|