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
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.
QuoteThat 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
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
Nice job!
Good for learning how to use sqlite in CBASIC!
Thanks for sharing
Haim
Only used a small set of features of SQLite3 in this program. There is much more it can do.
Allan