Special

Clearance Sale!

We've been publishing for over five years now and it's time to clear out our inventory of back issues, so we're slashing prices!

RBD Magazines

Check out this amazing clearance sale of all our past issues. Missing some issues? This is a great time to complete your RBD collection. Save up to 40% off the regular price of our printed back issue packages. These prices are only good until the end of the year May 2008 and supplies are limited, so place your order today.

Article Preview


Buy Now

Print:
PDF:

From Scratch

Swatter Part 2

A simple bug database

Issue: 6.3 (March/April 2008)
Author: Brad Rhine
Article Description: No description available.
Article Length (in bytes): 8,367
Starting Page Number: 36
RBD Number: 6316
Resource File(s):

Download Icon 6316.zip Updated: Saturday, March 15, 2008 at 12:36 PM

Related Link(s): None
Known Limitations: None

Excerpt of article text...

In this issue, we continue Swatter, a simple bug database. Last time, we began by discussing a bit about databases and proceeded to define our database structure, or schema, using SQL. I hope you still have the SQL files we created last time handy, because we're about to create our project file and build our interface.

Go ahead and fire up REALbasic, and create a new project. We'll call it Swatter. It's a good idea to create a folder to hold the project file and our SQL files, just so we have everything in one place and we always know where everything is. Once your project is created, we can begin to build our interface.

Based on the tables we defined last time (projects, users, and issues), we have six basic functions to cover, which we'll handle in five windows. Now, the more mathematically inclined among you may be wondering how I started with three tables, arrived at six functions, and decided on five windows. It's pretty simple, really. Each of our three tables has two functions: displaying and data entry. We also have deleting data and editing data, but as you'll see shortly, we can handle those along with displaying and entering data.

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

Article copyrighted by REALbasic Developer magazine. All rights reserved.


 


|

 


Weblog Commenting and Trackback by HaloScan.com