TweetFollow Us on Twitter

Beginning REALBasic

Volume Number: 24 (2008)
Issue Number: 07
Column Tag: REALBasic

Beginning REALBasic

Designing the Application

by Norman Palardy

REALbasic is a Rapid Application Develpment (RAD) tool from REALSoftware. In previous columns we've looked at it briefly and even talked with Geoff Perlmann, the CEO of REAL Software. This month we're continuing our series of articles that aim to get you started with REALbasic and show you how to be productive with it. For this series we're using the latest version of REALbasic; version 2008r1.

Designing the Interface

In this installment we're creating an application that tracks the prices of stocks. This will involve accessing the Internet to grab quotes, graphs and a database. Some of the components required are built in to REALbasic itself, and others will have to come from third parties.

In this installment we'll design the interface, the database and the windows we'll need for adding stocks to track. We'll get started writing the basics that make the whole project come together.

First, start REALbasic so you have a new project to work with.


Figure 1. REALbasic default project

As we saw last month, this default project is a fully functioning program. You could immediately run it by pressing the green Run button.

Let's consider the tasks we'll need to accomplish to make this program work the way we want.

  • We'll need a way to add and remove stocks from the list of ones we're interested in.

  • It should keep quotes for any stocks we currently have, or had an interest in at any time

  • We'll need a way to view the current set of stocks we're interested in and their prices

  • We'll need a way to get the stock prices from a designated source

  • We'll need a way to designate which source we're going to read data from

  • Eventually we'll want a way to graph prices of stocks over time

That's a lot of things to consider so we'll tackle them one at a time. Lets start with how we show our list of stocks of interest.

In the project we created earlier, there should already be a window called Window1. Let's start by editing that window and altering its layout to turn it into one that shows our list of stocks.


Figure 2. Editing a REALbasic window

Down the left hand side is a list of the standard controls that are available in REALbasic. Note that I'm using the Professional version. The Personal version has a smaller set of controls.

In the center is the actual editor where you lay out the look of your window. On the right is the properties palette that displays the properties of the currently selected item.

First, rename this window so that at a glance, you can know which window it is. Click the window so it is selected as shown in Figure 2, and then click on the Name in the property list on the right. Name this window wStocks.

Then add a Listbox control to the window. Rename the listbox lstStocks and position and resize it so your window appears about like the one in Figure 3. Note that Figure 3 shows you the position and size of my listbox in the properties palette on the right hand side.

You'll also notice that the listbox has several lock properties set (LockLeft, LockRight, LockTop, LockBottom). These properties tell REALbasic to keep the listbox "locked" to the respective sides of the window if the window is resized.


Figure 3. Create the stock list window

If you run the project at this point you wont see much except that a window with a large white area shows up. That area is the listbox, which is empty at this point.

The question, then, is how to fill it with data and what data to fill it with.

Every control has a number of "events" that allow you provide custom code when something (an event) occurs. Different controls have different events. The list of events that exist for a control varies depending on what kind of control it is. Simple controls have few events. Timers only have one event. The listbox has a fairly long list of events. For our program let's start with just using the Open event.

This event occurs when the control is about to be shown on a window that is being opened. It occurs only once when the window is initially opened. There are other events that occur more frequently but for the start of this project we'll use this event.

One thing to be aware of is that event ordering is generally not something you want to rely on. You have no idea if the listbox Open event occurs before or after some other controls Open event. The other control may not even exist yet. So you have to be careful about how you use certain events and what you try to do in the code for that event.

If you double-click the listbox you will be shown the code editor. REALbasic also tries to be helpful and selects the most likely event you are going to want to edit. In this case that's the Change event for the list box.


Figure 4. Editing the listbox events in the stock list window

Select the Open event in the left hand pane and then add the following code :

  me.ColumnCount = 3 // change the number of visible columns
  me.HasHeading = true // make the list box have a leading row
  me.Heading(0) = "Symbol" // set the heading for the first column
  me.Heading(1) = "Time" // set the heading for the second column
  me.Heading(2) = "$" // set the heading for the third column

Much of this CAN be done without writing code. If you review figure 3, you'll see that in the right hand properties pane there are settings for ColumnCount, HasHeading and InitialValue. If you set the columnCount property to 3 then the listbox will have 3 columns. If you check HasHeading then the listbox will have a heading and the setting for InitialValue will be used as the column headings. We've done these things in the Open event simply to illustrate that you can change some properties on the fly and they will take effect right away. Being able to alter the number of columns and their headings at run time will be shown in future articles.

If you run the program now, you can see that when the window opens it has 3 columns with the headings we wanted.

Now we have a way to get the display looking like what we want, so now let's see about getting some rows into it that display data.

If you look up ListBox in the built-in Language Reference, you'll see it has numerous events, properties and methods. Again, an event is some piece of code that gets run when something happen; a person selects a row, clicks a button or presses a key. Properties are the "settings" of various aspects of the control; the number of columns, which row is selected, or other display related values like the text font and size.

Methods are behaviors that the listbox will perform. These are actions like adding a row (AddRow), remove a row (RemoveRow), or ways to get data from the listbox (Cell and CellTag).

For our use AddRow is the one we need at present. At the end of the open event add the following code :

  me.AddRow "AAPL" // add one symbol we're interested in watching
  dim newDate as new Date // create a new instance of a Date
  me.cell(me.LastIndex,1) = newDate.ShortDate + " " + newDate.ShortTime // add the date / time stamp
  me.cell(me.LastIndex,2) = format(169.73,"$,#.00") // display Apple's current value

Let's review this code closely.

  me.AddRow "AAPL" // add one symbol we're interested in watching

This line adds the data for the first cell (the left most one also known as column 0) and leaves the other cells empty.

  dim newDate as new Date

For the second column we want the current date and time. In order to get that information we need to create an instance of a Date object, which is conveniently initialized to the date and time from the OS when the instance was created. A Date instance is not a clock and does not automatically count forward.

 me.cell(me.LastIndex,1) = newDate.ShortDate + " " + newDate.ShortTime // add the date / time stamp

Then we fill the middle cell — the one we want to contain the date and time — by using the CELL method to refer to a specific cell. Note that in order to make sure we set the correct cell in the correct row there is a convenient property called "lastIndex" that is the row number that was last added. The code says "set the last rows cell 1 to the short date and short time" which is exactly what we want.

  me.cell(me.LastIndex,2) = format(169.73,"$,#.00")

For the last column, column 2, we want a value. But the listbox only knows how to display strings. So we have to take the current value of Apple's stock, 169.73, which is a number and convert it into a string that the listbox can display. Also, we want to make sure the string that the listbox displays is formatted so it looks just the way we want. To do that we use the FORMAT method which gives us control over how numbers look when they are converted to strings.

Run this now and you'll see we're making headway. We can make the listbox display data, and we can add data to it.

Next time we'll look at how to make the data that we display more dynamic and actually get it from a web based quote service like Yahoo finance.


Norman Palardy has worked with SQL databases since 1992, and has programmed in C, C++, Java, REALbasic and other languages on a wide variety of platforms. In his 15+ years of IT experience, Norman has developed innovative and award-winning applications for TransCanada Pipelines, Minerva Technologies (now XWave), Zymeta Corporation, and the dining and entertainment industry. He holds a BSc from the University of Calgary in Alberta. He's also the Vice President of the Association of REALbasic Professionals (http://www.arbp.org)

 

Community Search:
MacTech Search:

Software Updates via MacUpdate

Spotify 1.0.44.100. - Stream music, crea...
Spotify is a streaming music service that gives you on-demand access to millions of songs. Whether you like driving rock, silky R&B, or grandiose classical music, Spotify's massive catalogue puts... Read more
Microsoft OneNote 15.29 - Free digital n...
OneNote is your very own digital notebook. With OneNote, you can capture that flash of genius, that moment of inspiration, or that list of errands that's too important to forget. Whether you're at... Read more
WALTR 2 2.0.8 - $39.95
WALTR 2 helps you wirelessly drag-and-drop any music, ringtones, videos, PDF, and ePub files onto your iPhone, iPad, or iPod without iTunes. It is the second major version of Softorino's critically-... Read more
Dropbox 16.3.27 - Cloud backup and synch...
Dropbox is an application that creates a special Finder folder that automatically syncs online and between your computers. It allows you to both backup files and keep them up-to-date between systems... Read more
EtreCheck 3.1.5 - For troubleshooting yo...
EtreCheck is an app that displays the important details of your system configuration and allow you to copy that information to the Clipboard. It is meant to be used with Apple Support Communities to... Read more
Carbon Copy Cloner 4.1.12 - Easy-to-use...
Carbon Copy Cloner backups are better than ordinary backups. Suppose the unthinkable happens while you're under deadline to finish a project: your Mac is unresponsive and all you hear is an ominous,... Read more
VueScan 9.5.62 - Scanner software with a...
VueScan is a scanning program that works with most high-quality flatbed and film scanners to produce scans that have excellent color fidelity and color balance. VueScan is easy to use, and has... Read more
SpamSieve 2.9.27 - Robust spam filter fo...
SpamSieve is a robust spam filter for major email clients that uses powerful Bayesian spam filtering. SpamSieve understands what your spam looks like in order to block it all, but also learns what... Read more
Fantastical 2.3.2 - Create calendar even...
Fantastical 2 is the Mac calendar you'll actually enjoy using. Creating an event with Fantastical is quick, easy, and fun: Open Fantastical with a single click or keystroke Type in your event... Read more
PCalc 4.4.4 - Full-featured scientific c...
PCalc is a full-featured, scriptable scientific calculator with support for hexadecimal, octal, and binary calculations, as well as an RPN mode, programmable functions, and an extensive set of unit... Read more

Latest Forum Discussions

See All

Track Santa with these three festive app...
Christmas is fast approaching and that means it's time to prepare for Santa's yearly pilgrimage around the globe. Christmas Eve is an exciting time as parents help their kids get ready to welcome Santa. You've got the cookies and milk all planned... | Read more »
Galaxy on Fire 3 and four other fantasti...
Galaxy on Fire 3 - Manticore brings the series back for another round of daring space battles. It's familiar territory for folks who are familiar with the franchise. If you've beaten the game and are looking to broaden your horizons, might we... | Read more »
The best apps for your holiday gift exch...
What's that, you say? You still haven't started your holiday shopping? Don't beat yourself up over it -- a lot of people have been putting it off, too. It's become easier and easier to procrastinate gift shopping thanks to a number of apps that... | Read more »
Toca Hair Salon 3 (Education)
Toca Hair Salon 3 1.0 Device: iOS Universal Category: Education Price: $2.99, Version: 1.0 (iTunes) Description: | Read more »
Winter comes to Darkwood as Seekers Note...
MyTona, based in the chilly Siberian city of Yakutsk, has brought a little festive fun to its hidden object game Seekers Notes: Hidden Mystery. The Christmas update introduces some new inhabitants to players, and with them a chance to win plenty of... | Read more »
Bully: Anniversary Edition (Games)
Bully: Anniversary Edition 1.03.1 Device: iOS Universal Category: Games Price: $6.99, Version: 1.03.1 (iTunes) Description: *** PLEASE NOTE: This game is officially supported on the following devices: iPhone 5 and newer, iPod Touch... | Read more »
PINE GROVE (Games)
PINE GROVE 1.0 Device: iOS Universal Category: Games Price: $1.99, Version: 1.0 (iTunes) Description: A pine grove where there are no footsteps of people due to continuous missing cases. The case is still unsolved and nothing has... | Read more »
Niantic teases new Pokémon announcement...
After rumors started swirling yesterday, it turns out there is an official Pokémon GO update on its way. We’ll find out what’s in store for us and our growing Pokémon collections tomorrow during the Starbucks event, but Niantic will be revealing... | Read more »
3 reasons why Nicki Minaj: The Empire is...
Nicki Minaj is as business-savvy as she is musically talented and she’s proved that by launching her own game. Designed by Glu, purveyors of other fine celebrity games like cult favorite Kim Kardashian: Hollywood, Nicki Minaj: The Empire launched... | Read more »
Clash of Clans is getting its own animat...
Riding on its unending wave of fame and success, Clash of Clans is getting an animated web series based on its Clash-A-Rama animated shorts.As opposed to the current shorts' 60 second run time, the new and improved Clash-A-Rama will be comprised of... | Read more »

Price Scanner via MacPrices.net

Never Settle for Low Performing Wifi With iOS...
AppYogi Software has announced the release of WiFi Signal Strength Status App 1.0, the company’s new utility developed exclusively for macOS. WiFi Signal Strength Status App features a unique, single... Read more
New 2016 13-inch Touch Bar MacBook Pros in st...
B&H Photo has stock of new 2016 Apple 13″ Touch Bar MacBook Pro models, each including free shipping plus NY sales tax only: - 13″ 2.9GHz/512GB Touch Bar MacBook Pro Space Gray: $1999 - 13″ 2.... Read more
New 2016 15″ Touch Bar MacBook Pros in stock...
B&H Photo has new 2016 Apple 15″ Touch Bar MacBook Pro models in stock today including free shipping plus NY sales tax only: - 15″ 2.7GHz Touch Bar MacBook Pro Space Gray: $2799 - 15″ 2.7GHz... Read more
DietSensor App Targeting Diabetes and Obesity...
DietSensor, Inc., a developer of smart food and nutrition applications designed to fight diabetes and obesity and help improve overall fitness, has announced the launch of its DietSensor app for... Read more
Holiday 2016 13-inch 2.0GHz MacBook Pro sales...
B&H has the non-Touch Bar 13″ MacBook Pros in stock today for $50-$100 off MSRP. Shipping is free, and B&H charges NY sales tax only: - 13″ 2.0GHz MacBook Pro Space Gray (MLL42LL/A): $1449 $... Read more
Holiday sale: Apple TVs for $51-$40 off MSRP,...
Best Buy has dropped their price on the 64GB Apple TV to $159.99 including free shipping. That’s $40 off MSRP. 32GB Apple TVs are on sale right now for $98 on Sams Club’s online store. That’s $51 off... Read more
12-inch Retina MacBooks, Apple refurbished, n...
Apple has restocked a full line of Certified Refurbished 2016 12″ Retina MacBooks, now available for $200-$260 off MSRP. Refurbished 2015 models are available starting at $929. Apple will include a... Read more
Holiday sale: 12-inch Retina MacBook for $100...
B&H has 12″ Retina MacBooks on sale for $100 off MSRP as part of their Holiday sale. Shipping is free, and B&H charges NY sales tax only: - 12″ 1.1GHz Space Gray Retina MacBook: $1199 $100... Read more
Apple refurbished 13-inch MacBook Airs availa...
Apple has Certified Refurbished 13″ MacBook Airs available starting at $849. An Apple one-year warranty is included with each MacBook, and shipping is free: - 13″ 1.6GHz/8GB/128GB MacBook Air: $849 $... Read more
Apple refurbished iMacs available for up to $...
Apple has Certified Refurbished 2015 21″ & 27″ iMacs available for up to $350 off MSRP. Apple’s one-year warranty is standard, and shipping is free. The following models are available: - 21″ 3.... Read more

Jobs Board

*Apple* Retail - Multiple Positions - Apple,...
Job Description: Sales Specialist - Retail Customer Service and Sales Transform Apple Store visitors into loyal Apple customers. When customers enter the store, Read more
US- *Apple* Store Leader Program - Apple (Un...
…Summary Learn and grow as you explore the art of leadership at the Apple Store. You'll master our retail business inside and out through training, hands-on Read more
Automotive Detailer - *Apple* Used Autos -...
We are currently conductinginterviews and will be accepting applications for a part-time detailer. Apple Used Autos is a great place to work andstart a career. We Read more
*Apple* Retail - Multiple Positions - Apple,...
Job Description: Sales Specialist - Retail Customer Service and Sales Transform Apple Store visitors into loyal Apple customers. When customers enter the store, Read more
*Apple* Retail - Multiple Positions- Trumbul...
Sales Specialist - Retail Customer Service and Sales Transform Apple Store visitors into loyal Apple customers. When customers enter the store, you're also the Read more
All contents are Copyright 1984-2011 by Xplain Corporation. All rights reserved. Theme designed by Icreon.