Article Preview
Buy Now
COLUMN
Credits & Debits
Building a simple database application in REALbasic.
Issue: 5.1 (September/October 2006)
Author: Will Leshner
Author Bio: Will Leshner is a Software Engineer who has spent a good deal of the last several years building REALbasic applications, utilities, and plugins. Check out his REALbasic weblog at
Article Description: No description available.
Article Length (in bytes): 11,137
Starting Page Number: 42
Article Number: 5118
Resource File(s):
5118.zip Updated: 2006-09-28 14:14:10
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/
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.
In this article I plan to give a brief introduction to database programming in REALbasic, and to the REAL SQL Database in particular. I will also briefly describe the Credits & Debits user interface. We will get into actual programming beginning in the next article.
...End of Excerpt. Please purchase the magazine to read the full article.