Special

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.3

COLUMN

CashFlow

Building a simple database application in REALbasic.

Issue: 5.3 (March/April 2007)
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,722
Starting Page Number: 42
Article Number: 5316
Resource File(s):

Download Icon 5316.zip Updated: 2007-03-15 08:24:22

Related Web Link(s):

http://www.rbgazette.com/

Excerpt of article text...

Introduction

This is the third in a series of articles about building CashFlow, a database application for tracking income and expenses. If you were here last time, then you know that the primary goal for this article is to introduce readers to REALbasic's database classes in general, and to the REAL SQL Database in particular. A secondary goal is the creation of a useful application.

In today's article we will be looking at how to query the CashFlow database for expense and income items, how to display those items in CashFlow's main ListBox, and how to filter the query by category, type, and date.

I recommend that you refer often to the REALbasic project for CashFlow as you read this article. I have taken the liberty of filling out a good deal more of CashFlow's functionality than we will be talking about in this article. If you want to see where we are headed, feel free to explore the code we don't talk about here.

Querying The Database

...End of Excerpt. Please purchase the magazine to read the full article.