Club Membership Database using SQLite3

[Allan]

A small Windows Program keeps records of members using SQLite3 for the Database.
Source Code attached.

Club Membership -  by Allan

Using Sqlite3 Database

Creative BASIC - Compile as Windows

*** HOW TO USE CLUB MEMBERSHIP ***   ----------------------------------

ADD A NEW RECORD
1. Enter the Data in the Edit Boxes
2. Click the Add New Button

EDIT A RECORD
1. Double Click on a Record in the ListView.
    The data is entered into the Edit Boxes for editing
2. Make the changes in the Edit Boxes that are needed.
3. Click the Edit Button.
Note: Selecting a different Row in the ListView will cancel an Edit function.

DELETE A RECORD
1. Select a Record in the ListView.
2. Click the Delete Button.

SORT LISTVIEW CONTENTS
1. Click on the Heading of any Column other than Member Date to SORT the ListView.

Allan

[Trevor]

That is really good. I didn't know CB could use databases like that. The program won't run if the start path is too long though.

[Allan]

That is really good. I didn't know CB could use databases like that. The program won't run if the start path is too long though.

Change the DbasePath Variable from a String to an ISTRING

DEF DbasePath[500]:ISTRING

which will allow for longer path.

Allan

[GWS]

That's a nice piece of work Allan .. 

I'm sure a lot of folk will be interested in how to use a database in Creative.

best wishes,

Graham

[Haim]

Nice job!
Good for learning how to use sqlite in CBASIC!
Thanks for sharing
Haim

[Allan]

Only used a small set of features of SQLite3 in this program. There is much more it can do.
Allan