Article Preview
Buy Now
| Print: | |
| PDF: |
From Scratch
CashFlow
Building a simple database application in REALbasic.
Issue: 5.3 (March/April 2007)
Author: Will Leshner
Article Description: No description available.
Article Length (in bytes): 10,168
Starting Page Number: 42
RBD Number: 5316
Resource File(s):
5316.sit Updated: Thursday, March 15, 2007 at 9:03 AM
Related Web Link(s):
http://www.rbgazette.com/
Known Limitations: None
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
In the previous article we learned how to create a new CashFlow database and how to initialize it in order to start working with it. The next step is to implement the ability to populate CashFlow's ItemsListBox with expense and income items from the database. The code we will be talking about is located in MainWindow's RepopulateItemsListBox. You might want to navigate to that method first in CashFlow's REALbasic project before reading any more of this article.
...End of Excerpt. Please purchase the magazine to read the full article.
Article copyrighted by REALbasic Developer magazine. All rights reserved.
|
