Progress
Language Tutorial
for Character


Using Database Fields

Before you can reference a database field, you must connect the database that contains it. To reference a field in your code, specify its name. You may also need to specify the table name that contains the field if more than one table in the database contains a field of the same name. To avoid ambiguity, add the table name and a period before the field name.

SYNTAX
table-name.field-name 

In many cases, programmers feel that supplying both the table and field name makes the code more readable, even if it is not required.

At other times, you may need to specify the database name that contains the table. Add the database name and a period before the table name.

SYNTAX
database-name.table-name.field-name 

This example adds $500 to the credit limit of a customer:

sports.Customer.Credit-Limit = sports.Customer.Credit-Limit + 500. 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095