Progress
ADM 2 Guide


Nondata Fields in the RowObject and RowObjUpd Temp–tables

A RowObject temp–table contains more than just fields selected from database tables. It also contains the following information:

For example:

DEFINE TEMP-TABLE RowObject RCODE-INFORMATION

  FIELD Cust-Num LIKE Customer.Cust-Num VALIDATE ~
  FIELD Name LIKE Customer.Name VALIDATE ~
  FIELD Address LIKE Customer.Address VALIDATE ~
  FIELD City LIKE Customer.City VALIDATE ~
  FIELD State LIKE Customer.State VALIDATE ~
  FIELD Postal-Code LIKE Customer.Postal-Code VALIDATE ~

  FIELD RowNum   AS INTEGER
  FIELD RowIdent AS CHARACTER
  FIELD RowMod   AS CHARACTER

  INDEX RowNum   IS PRIMARY RowNum
  INDEX RowMod   RowMod
  INDEX RowIdent RowIdent. 

Note that the RowObject temp–table contains three special fields named RowNum, RowIdent, and RowMod. These fields. which are maintained by the SmartDataObject support code, are used to manage queries and updates as follows:

The RowObjUpd temp–table contains the same fields as the RowObject temp–table plus the ChangedFields field, which is used only for updates:


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