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:

Databases for Real

Database Bindings

Issue: 3.6 (July/August 2005)
Author: Paul Lefebvre
Author Bio: Paul Lefebvre is President and Chief Software Architect of LogicalVue Software, producers of SQLVue, RBUnit, and other products.
Article Description: No description available.
Article Length (in bytes): 3,426
Starting Page Number: 34
RBD Number: 3615
Resource File(s):

Download Icon 3615.sit Updated: Monday, July 25, 2005 at 11:27 AM

Related Link(s): None
Known Limitations: None

Excerpt of article text...

Last time, we used Database Bindings to display table data in a ListBox. This time we will use a DataControl to display the products in a more form-based fashion, with one product per page. This will allow us to progress through the list of Products, delete products, change products, and add new products. We will continue to use the Northwind database and the product table.

Product Detail

The first thing we need to do is to create a new window that will be used to display the product detail. We want this window to display the same fields that are shown in the Product List we created last time:

ProductName

UnitPrice

UnitsInStock

Discontinued

You can choose to start with the project we used last time or to create a new project.

Create a window (perhaps named wProductDetail) and add three EditFields and Labels for ProductName, UnitPrice, and UnitsInStock. Add a CheckBox for Discontinued.

Now, add a DataControl to the window. This control is what will enable the fields you just added to display data for a row in the Products table. Set these properties on the DataControl:

...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