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

Backblaze 4.2.0.966 - Online backup serv...
Backblaze is an online backup service designed from the ground-up for the Mac. With unlimited storage available for $5 per month, as well as a free 15-day trial, peace of mind is within reach with... Read more
Tunnelblick 3.6.7beta02 - GUI for OpenVP...
Tunnelblick is a free, open source graphic user interface for OpenVPN on OS X. It provides easy control of OpenVPN client and/or server connections. It comes as a ready-to-use application with all... Read more
calibre 2.65.1 - Complete e-book library...
Calibre is a complete e-book library manager. Organize your collection, convert your books to multiple formats, and sync with all of your devices. Let Calibre be your multi-tasking digital librarian... Read more
jAlbum Pro 13.4 - Organize your digital...
jAlbum Pro has all the features you love in jAlbum, but comes with a commercial license. You can create gorgeous custom photo galleries for the Web without writing a line of code! Beginner-friendly... Read more
jAlbum 13.4 - Create custom photo galler...
With jAlbum, you can create gorgeous custom photo galleries for the Web without writing a line of code! Beginner-friendly, with pro results - Simply drag and drop photos into groups, choose a design... Read more
Parallels Desktop 12.0.0 - Run Windows a...
Parallels allows you to run Windows and Mac applications side by side. Choose your view to make Windows invisible while still using its applications, or keep the familiar Windows background and... Read more
Firefox 48.0.2 - Fast, safe Web browser.
Firefox offers a fast, safe Web browsing experience. Browse quickly, securely, and effortlessly. With its industry-leading features, Firefox is the choice of Web development professionals and casual... Read more
Apple iOS 9.3.5 - The latest version of...
iOS is the world’s most advanced mobile operating system, and it’s the foundation of iPhone, iPad, and iPod touch. It comes with a collection of apps and features that let you do the everyday things... Read more
Spotify 1.0.36.124. - 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
Apple iOS 9.3.5 - The latest version of...
iOS is the world’s most advanced mobile operating system, and it’s the foundation of iPhone, iPad, and iPod touch. It comes with a collection of apps and features that let you do the everyday things... Read more

Clean Text (Productivity)
Clean Text 1.0 Device: iOS Universal Category: Productivity Price: $3.99, Version: 1.0 (iTunes) Description: | Read more »
Gemini - A Journey of Two Stars (Games)
Gemini - A Journey of Two Stars 1.0.1 Device: iOS Universal Category: Games Price: $2.99, Version: 1.0.1 (iTunes) Description: *** SPECIAL LAUNCH SALE: $2.99 (25% off) *** "A mesmerizing and unexpectedly emotional journey." -- Los... | Read more »
How to get four NFL superstars for your...
Even though you're probably well on your way to building a top notch squad for the new season in Madden NFL Mobile, let's say you could beef it up by adding Rob Gronkowski, Antonio Brown, Von Miller, and Todd Gurley to your roster. That's... | Read more »
Cartoon Network Superstar Soccer: Goal!!...
Cartoon Network Superstar Soccer: Goal!!! – Multiplayer Sports Game Starring Your Favorite Characters 1.0 Device: iOS Universal Category: Games Price: $2.99, Version: 1.0 (iTunes) Description: Become a soccer superstar with your... | Read more »
NFL Huddle: What's new in Topps NFL...
Can you smell that? It's the scent of pigskin in the air, which either means that cliches be damned, pigs are flying in your neck of the woods, or the new NFL season is right around the corner. [Read more] | Read more »
FarmVille: Tropic Escape tips, tricks, a...
Maybe farming is passé in mobile games now. Ah, but farming -- and doing a lot of a other things too -- in an island paradise might be a little different. At least you can work on your tan and sip some pina coladas while tending to your crops. [... | Read more »
Become the King of Avalon in FunPlus’ la...
King Arthur is dead. Considering the legend dates back to the 5th century, it would be surprising if he wasn’t. But in the context of real-time MMO game King of Avalon: Dragon Warfare, Arthur’s death plunges the kingdom into chaos. Evil sorceress... | Read more »
Nightgate (Games)
Nightgate 1.0 Device: iOS Universal Category: Games Price: $2.99, Version: 1.0 (iTunes) Description: *** Launch Sale: 25% OFF for a limited time! *** In the year 2398, after a great war, a network of intelligent computers known as... | Read more »
3 best fantasy football apps to get you...
Last season didn't go the way you wanted it to in fantasy football. You were super happy following your drafts or auctions, convinced you had outsmarted everyone. You were all set to hustle on the waiver wire, work out some sweet trades, and make... | Read more »
Pokemon GO update: Take me to your leade...
The Team Leaders in Pokemon GO have had it pretty easy up until now. They show up when players reach level 5, make their cases for joining their respective teams, and that's pretty much it. Light work, as Floyd Mayweather might say. [Read more] | Read more »

Price Scanner via MacPrices.net

Global Tablet Shipments Projected to Increase...
Digitimes’ Jim Hsiao reports that global tablet shipments will increase by 16.3 percent sequentially to reach nearly 47 million units in 2016′s third quarter, but that volume will still be down over... Read more
Apple’s 2016 Back to School promotion: Free B...
Purchase a new Mac or iPad using Apple’s Education Store and take up to $300 off MSRP. All teachers, students, and staff of any educational institution qualify for the discount. Shipping is free, and... Read more
Apple refurbished iPad Air 2s available start...
Apple has Certified Refurbished iPad Air 2 available starting at $339. Apple’s one-year warranty is included with each model, and shipping is free: - 128GB Wi-Fi iPad Air 2: $499 - 64GB Wi-Fi iPad... Read more
13-inch 2.5GHz MacBook Pro available for $961...
Overstock has the 13″ 2.5GHz MacBook Pro available for $961.63 including free shipping. Their price is $138 off MSRP. Read more
Clearance 12-inch Retina MacBooks, Apple refu...
Apple has Certified Refurbished 2015 12″ Retina MacBooks available starting at $929. Apple will include a standard one-year warranty with each MacBook, and shipping is free. The following... Read more
BookBook Releases SurfacePad, BookBook &...
BookBook has released three new covers just for iPad Pro: SurfacePad, BookBook and BookBook Rutledge Edition. BookBook for iPad Pro is a gorgeous leather case reminiscent of a vintage sketchbook.... Read more
Clean Text 1.0 for iOS Reduces Text Cleanup a...
Apimac today announced availability of Clean Text for iOS, a tool for webmasters, graphic designers, developers and magazine editors to reduce text cleanup and editing time, and also for any iPhone... Read more
27-inch iMacs on sale for up to $220 off MSRP
B&H Photo has 27″ Apple iMacs on sale for up to $200 off MSRP including free shipping plus NY sales tax only: - 27″ 3.3GHz iMac 5K: $2099 $200 off MSRP - 27″ 3.2GHz/1TB Fusion iMac 5K: $1899 $100... Read more
Apple refurbished 13-inch MacBook Airs availa...
Apple has Certified Refurbished 2016 and 2015 13″ MacBook Airs now available starting at $849. An Apple one-year warranty is included with each MacBook, and shipping is free: - 2016 13″ 1.6GHz/8GB/... Read more
Apple refurbished iPad mini 2s available for...
Apple is offering Certified Refurbished iPad mini 2s for up to $80 off the cost of new minis. An Apple one-year warranty is included with each model, and shipping is free: - 16GB iPad mini 2 WiFi: $... Read more

Jobs Board

*Apple* Retail - Multiple Positions (US) - A...
Job Description: Sales Specialist - Retail Customer Service and Sales Transform Apple Store visitors into loyal Apple customers. When customers enter the store, Read more
Seasonal Sales Associate - *Apple* Blossom...
Seasonal Sales Associate - Apple Blossom Mall Location:Winchester, VA, United States- Apple Blossom Mall 1850 Apple Blossom Dr Job ID:1001993 Date:August 22, Read more
*Apple* Engineer - Softthink Solutions, Inc....
Job Description:- Proven experience in administering IOS and OSX Apple devices in enterprises - Experience in administering Apple devices in Windows environments Read more
*Apple* Professional Learning Specialist - A...
# Apple Professional Learning Specialist Job Number: 51234243 Portland, Maine, Maine, United States Posted: Aug. 18, 2016 Weekly Hours: 40.00 **Job Summary** The Read more
*Apple* Mobile Master - Best Buy (United Sta...
What does a Best Buy Apple Mobile Master do? At Best Buy, our mission is to leverage the unique talents and passions of our employees to inspire, delight, and enrich Read more
All contents are Copyright 1984-2011 by Xplain Corporation. All rights reserved. Theme designed by Icreon.