Introducing the “Welcome to Xojo” Bundle!

New to Xojo and looking for guidance? We've put together a terrific bundle to welcome you! Xojo Bundle

This bundle includes six back issues of the magazine -- all of year 21 in printed book and digital formats -- plus a one-year subscription (beginning with 22.1) so you'll be learning all about Xojo for the next year. It's the perfect way to get started programming with Xojo. And you save as much as $35 over the non-bundle price!

This offer is only available for a limited time as supplies are limited, so hurry today and order this special bundle before the offer goes away!

Article Preview

Buy Now

Issue 5.1


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 http://www.rbgazette.com/.
Article Description: No description available.
Article Length (in bytes): 11,137
Starting Page Number: 42
Article Number: 5118
Resource File(s):

Download Icon 5118.zip Updated: 2006-09-28 14:14:10

Related Web Link(s):


Excerpt of article text...


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.