Announcement

Collapse

Forum Guidelines

This forum is for finished source code that is working properly. If you have questions about this or any other source code, please post it in one of the Discussion Forums, not here.
See more
See less

Sample SQLite/SQLitening Address Book project

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • PBWin Sample SQLite/SQLitening Address Book project

    Attached is a sample AddressBook project. This is an improved version of the previously posted example. This program uses SQLite/SQLitening 1.20 and FF3 and PB9. Some of the features of the program:

    * Six indexes - you can switch between index via a radiobutton

    * Create and save new records

    * Modify/edit records

    *Delete records

    *Search/Find Records

    *Browse Records by selected index via an Up/Down Arrow control

    *displays the SLQ command string being executed (hellp in understand how the program works.

    Note: the main window is devide into two parts: the upper portion of the window has text fileds that display the currect record's fields. The lower portion of the window, lists where you are in the database, it shows three records previous to the current record and three record after the currect record. These are displayed in current index sort order. There's an Up/Down Arrow control that allows you to move to the next or the previous record. This is done in a similar way that Cheetah was able to do next/prev.

    I would appreciate feed back as to your impression of the ease/difficult in working with or understanding this sample program.

    Also, if you have recommendations how I might improve the program, please share.

    The project comes with a small sample database. It is set up to run locally no server needs to be setup. You can either load the program in FF3 and Compile/RUN or just run the AdBook.EXE that's in the "release" directory.

    One thing you might like to test is to add 10,000s record and see what the preformace is like. If you you do, please report back your findings.

    Heres a link on which to comment:

    http://www.powerbasic.com/support/pb...801#post327801
    Attached Files
    Last edited by Martin Francom; 13 Nov 2009, 10:13 AM.
Working...
X