Appa~acws1.py | Python Fiddle

#first program to create acc sw and related table
import sqlite3
conn = sqlite3.connect('rajadb1.db')
c= conn.cursor()
mylist  =[]
#c.execute("CREATE TABLE IF NOT EXISTS rajacust8(id primary key int, name text, bal int)")
c.execute("CREATE TABLE IF NOT EXISTS rcust(id int primary key, name text,bal int)")
c.execute("SELECT id, name FROM rcust ORDER BY id ASC")
aa = c.fetchall()
print aa
#c.execute("INSERT INTO custac8 VALUES(10, 'RAJA', 50)")
mfld1 = 1
mfld2 = "x"
mfld3 = 10
count = 1
while True :
	mfld1 = int(input("id"))
	if mfld1 == 0:
		break
	mfld2 = input("name")
	mfld3 = int(input("bal"))
	#count = count +1
	mylist.append((mfld1,mfld2,mfld3))
	#continue
c.executemany("INSERT INTO rcust VALUES(?,?,?)", mylist)
conn.commit	
c.execute("SELECT *  FROM rcust")
c.fetchone()
conn.text_factory = str
ar= c.fetchall()
print ar
slist =[]
c.execute("CREATE TABLE IF NOT EXISTS salinv(invid int , cusid int   , amt int )" )
sfld1 = 1
sfld2 = 1
sfld3 = 100
scount = 1
while True :
	sfld1 = int(input("invid"))
	if sfld1 == 0 :
		break
	sfld2 = int(input("cusid"))
	sfld3 = int(input("amt"))
	#scount = scount +1
	slist.append((sfld1,sfld2,sfld3))
c.executemany("INSERT INTO salinv VALUES(?,?,?)", slist)
#c.execute("SELECT cusid FROM salinv")
#sr = c.fetchall()
#print sr
c.execute("SELECT   amt , cusid  FROM salinv ORDER BY  cusid ASC")
nr = c.fetchall()
print nr
#c.execute("SELECT   cusid   FROM salinv")
#cr = c.fetchall()
#print cr
c.executemany("UPDATE rcust SET  bal = bal + ?  WHERE  id  = ? " , nr )
c.execute("SELECT *  FROM rcust")
pr = c.fetchall()
print pr
print "reached last line"

#c.execute('''UPDATE rajacust8 SET rajacust8.bal = rajacust8.bal + salinv.amt FROM rajacust8 T1, salinv T2 WHERE T1.id = T2.cusid''')

#c.execute("SELECT bal FROM rajacust8")
#qr = c.fetchall()
#print qr
print "reached last line"

Python Fiddle

Python Cloud IDE