Special

Special Print Closeout!

We're clearing out the remainder of our print issues at fire sale prices -- as much as 75% off! Quantities are extremely limited and only available while supplies last. Hurry to take advantage of this one-time offer.

RBD Magazines

Once these printed back issues are gone, they are gone!

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