Article Preview
Buy Now
| Print: | |
| PDF: |
From Scratch
Credits & Debits
Building a simple database application in REALbasic.
Issue: 5.1 (September/October 2006)
Author: Will Leshner
Article Description: No description available.
Article Length (in bytes): 9,688
Starting Page Number: 42
RBD Number: 5118
Resource File(s):
5118.sit Updated: Friday, September 29, 2006 at 11:34 AM
Related Web Link(s):
http://www.rbgazette.com/
http://en.wikipedia.org/wiki/Sql
http://www.w3schools.com/sql/default.asp
http://sqlzoo.net/
http://www.postgresql.org/docs/8.1/static/sql.html
http://databases.about.com/od/sql/
http://www.sql-ex.ru/
Known Limitations: None
Excerpt of article text...
Introduction
The time has come to begin a new From Scratch project, and I've decided this time around to work on a program that uses the REAL SQL Database. The new project, called "Credits & Debits," is a database application that tracks revenue and expenses for a small business. Basically, Credits & Debits allows you to add, edit, and delete credit and debit items. Each item has a category, a description, the date it was entered, and an amount. Credits & Debits displays items in a list box, and has facilities for filtering items by criteria that include category and date. Credits & Debits will even have a rudimentary facility for generating reports.
The intent of the Credits & Debits project is not to create a world-class application, but rather, to introduce the key concepts of database development in REALbasic. The techniques we will use to develop Credits & Debits are real and are the same techniques we would use to develop any database application in REALbasic. But Credits & Debits itself won't be much more than a toy. Which isn't to say that Credits & Debits can't be a useful application. I myself have often felt the need for a simple application to track my own expenses and revenue. My needs are modest, however, and I think something like Credits & Debits will be more than adequate.
...End of Excerpt. Please purchase the magazine to read the full article.
Article copyrighted by REALbasic Developer magazine. All rights reserved.
|
