PrevUpHomeProLinga-4GL Reference ManualNext

Table Object

Table — Collection of records and indices.

Introduction

Holds a collection of records and indices describing the table layout.

Properties

Table 22. Table Object Properties

NameDetailsPossible ValuesDefault Value
ExternalNameName of the table within the 3rd party data provider.*name
DataInterfaceTypeType of the data interface.GDA, RepositoryGDA
DataSourceNameName of the data source to use.*-
DescriptionDescription to be used in lists.*-
DetailDescriptionDetailed description.*-
ModifiedModification date-time stamp in ISO 8601 format.ccyy-mm-ddThh:mm:ssdate stamp
OccurrencesTableRecordEntry

Table 23. Occurrences TableRecordEntry

NameDetailsPossible ValuesDefault Value
RecordNameName of the Record.*-
ReiterateIf the record can iterate. (for repository access only)True, FalseFalse
DefaultIf this is the default record.True, FalseTrue (for first entry)

  
OccurrencesTableIndexEntry

Table 24. Occurrences TableIndexEntry

NameDetailsPossible ValuesDefault Value
IndexNameName of the index.*-
PrimaryIf the index is the primary.True, FalseTrue (for first entry)
UniqueIf the index is unique.True, FalseTrue
SortSorting of the index. (At retrieval time only)Ascending, DescendingAscending

  

Example

<Object Application="MyOrder" Type="Table" Name="Country">
  <Table>
    <ExternalName>Country</ExternalName>
    <DataSourceName>Order</DataSourceName>
    <Description>Country</Description>
    <DetailDescription>Table of countries and codes</DetailDescription>
    <Modified>2007-11-12T09:58:00</Modified>
    <OccurencesTableRecordEntry>
      <TableRecordEntry>
        <RecordName>Country</RecordName>
        <Reiterate>False</Reiterate>
        <Default>True</Default>
      </TableRecordEntry>
    </OccurencesTableRecordEntry>
    <OccurencesTableIndexEntry>
      <TableIndexEntry>
        <IndexName>CountryCode</IndexName>
        <Primary>True</Primary>
        <Unique>True</Unique>
        <Sort>Ascending</Sort>
      </TableIndexEntry>
      <TableIndexEntry>
        <IndexName>Country</IndexName>
        <Primary>False</Primary>
        <Unique>False</Unique>
        <Sort>Ascending</Sort>
      </TableIndexEntry>
    </OccurencesTableIndexEntry>
  </Table>
</Object>
<< Screen ObjectTextDocument Object >>