making a checkbook program - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


making a checkbook program

noob_pronoob_pro Posts: 51Member
just need to make it for one person, trying to show my dad the power of programming lol so i need to make him a program to create the account first, calculate deposits, withdrawls, interest rates, have like a huge message come up if there's not enough money in the bank for like a withdraw or something, and wanna make it easier for him so im gunna set it up with vb, im still ify on the whole using sql with vb thing but i can learn help me out?


  • noob_pronoob_pro Posts: 51Member
  • noob_pronoob_pro Posts: 51Member
    this is what i have so far prolly im just farting around with it, dunno if i need linking tables still fuzzy on stuff, prolly gunna need store procedures and views since im using vb hmmm here's the sql code so far

    use master

    drop database checkbook

    create database checkbook

    use checkbook

    create table login(
    LName varchar(20) not null,
    LPass char(20) not null
    insert into login values('brian','1234567');
    insert into login values ('chris','stuff');

    create table checking(
    CFName varchar(20) not null,
    CLName varchar(20) not null,
    CPhone char(7) not null check (CPhone like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9]' or CPhone like ' '),
    CAddress varchar(20) not null,
    Cmoney char(20) not null

    insert into checking values('brian','jack','6980654','snowshow','100');
    insert into checking values('chris','goof','6995545','blues','200');
    create table WithDep(

    Wdate char(12) not null,
    Wdesc varchar(20) not null,
    Wcash char(12),
    Wdep char(12)
    insert into WithDep values('2/20/2005','Carpayment','-50','');
    insert into WithDep values('2/20/2005','Paycheck','','+100');

    create table Saving(

    SFName varchar(20) not null,
    SLName varchar(20) not null,
    SPhone char(7) not null check (SPhone like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9]' or SPhone like ' '),
    SAddress varchar(20) not null,
    Smoney char(20) not null

    insert into saving values('brian','poof','6980654','crom','200');
    insert into saving values('dave','chris','6546547','shangful','100');

Sign In or Register to comment.