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!

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

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?

Comments

  • 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
    go

    drop database checkbook
    go

    create database checkbook
    go

    use checkbook
    go

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

    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

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

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

    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
    );
    go

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


Sign In or Register to comment.