FOUNDATIONUnder review

Data dictionary guide

SX2 · SX3 · SX1 · SX6 · SX7

Connects table, field, question and parameter metadata.

Data dictionary guideAdvPL

01 · OVERVIEW

Overview

The official guide defines the dictionary as part of Protheus structure and behavior. The historical subset identifies SX2 tables, SX3 fields, SX1 questions, SX6 parameters and SX7 triggers. Field changes require considering length, type, indexes, validations and references. The example is only an in-memory teaching map without direct SX reads or edits. (Sources: refs. 1–3.)

02 · SYNTAX

Syntax

SX2 · SX3 · SX1 · SX6 · SX7

03 · PRACTICAL EXAMPLE

Commented example

#Include "Protheus.ch"

User Function Ed480()
    Local aMap := {{"SX2","Tables"},{"SX3","Fields"},{"SX6","Parameters"}}
    Local nI
    // Teaching map, not a dictionary query.
    For nI := 1 To Len(aMap)
        ConOut(aMap[nI][1]+": "+aMap[nI][2])
    Next
Return Nil

Expected result

Displays three conceptual relationships without metadata changes. Under review: editorial example neither compiled nor run in Protheus. Check includes, release, RDD and context before testing.

BEST PRACTICES

Use release-supported configuration tools and maintain migrations, documentation and dependency tests.
Under review: editorial example neither compiled nor run in Protheus. Check includes, release, RDD and context before testing.

Data dictionary guide

Overview

Syntax

Commented example

Related content

Comments