Final Tweaking of Program...Need some help badly..


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Final Tweaking of Program...Need some help badly..

  1. #1
    Join Date
    Oct 2005
    Posts
    5

    Exclamation Final Tweaking of Program...Need some help badly..

    I have created a database program (as attached) and was working fine, till I added an additional field called "Mobile No" in the program. After which, I am facing a few problems;

    1) Add function now not able to add the record to the database. (was working fine previously)

    2) The Edit function not able to populate the records from the database. (was working fine previously)

    3) The Edit source code also consists of the delete function. I need to separate this function into another file called "DeleteMemberRecord". The interface can be the same as the “EditMember” source code. I have already created the button on the Main Menu to link to this source code.

    4) I also need a “MemberReport” function which has 2 buttons at the bottom called “Generate Report” and a “Back to Main”. Once the Generate Report Button is clicked, the first 5 records from the database will be shown.

    5) Lastly, there should be a box indicated as "No. of Total Records" at the top right-had corner of the Main AddMember, EditMember and DeleteMember forms to display the current number of records in the database.

    I hope that someone can help me with these few problems. I would really appreciate all the help i can get….

    Thanks guys!!
    Last edited by phelps_steve; 10-09-2005 at 01:08 AM.

  2. #2
    Join Date
    Aug 2003
    Posts
    313
    Looking at the add() function, it doesn't look like you are inserting something into the RegDate column. I don't know if this is the only problem, but you should probably address that in some way. Your database doesn't seem to have a MemberDetails table, perhaps you meant members. Are all of your errors with your database interaction, or is there still pieces of actual code that you have to write?
    ~evlich

  3. #3
    Join Date
    Oct 2005
    Posts
    5

    Unhappy

    i have managed to find the solution to the 1st 3 issues.... All i need now is some help for points 4 & 5.

    I have removed the regDate and MobileNo fields from the prog by the way.

    Can anyone at least give some help here?

    Deadline overdued!!

  4. #4
    Join Date
    Nov 2004
    Location
    Norway
    Posts
    1,560
    To display the x firstr records of a query you can use the LIMIT parameter in the
    sql.

    To get the number of records in a table use
    Code:
    String query="select count(*) \"RCOUNT\" from aTable";
    ResultSet rs=stmt.executeQuery(query);
    rs.next();
    int nOfRecords=rs.getInt("RCOUNT");
    Its a fast query (it doesn't read through all the records).

    The procedure above could be isolated in a method that took the table name
    as input parameter, and you could call it after every DB update and display
    the result in the apprpriate frames.

    For a count of all the records in all the tables in your DB you would have to
    call it repeatedly for each table and accumulate the total.
    Last edited by sjalle; 10-07-2005 at 11:37 AM.
    eschew obfuscation

Similar Threads

  1. Replies: 0
    Last Post: 10-04-2005, 10:42 PM
  2. problem in program in c++
    By mheasen in forum Architecture and Design
    Replies: 0
    Last Post: 03-20-2002, 09:24 AM
  3. Please help with running executable vb program.
    By Gordon Reichhardt in forum VB Classic
    Replies: 2
    Last Post: 01-08-2002, 10:06 AM
  4. How can I build copy protection into my program
    By W.Pierce in forum VB Classic
    Replies: 1
    Last Post: 12-11-2001, 08:28 AM
  5. Replies: 0
    Last Post: 12-15-2000, 10:07 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center