Are there configuration options available at design-time to

Posted by Rom Elwell on 20-Aug-2012 08:21

Good morning,

QUESTION:
Are there configuration options available at design-time to allow for additional defined field-options in a DEFINE TEMP-TABLE statement to be passed in an associated dataset XSD?

EXAMPLE:
The following (partial) design for a temp-table includes these field-options:

DEFINE TEMP-TABLE ttEmployeeStage1 NO-UNDO
    FIELD empid                 AS CHARACTER        XML-NODE-NAME "Employee ID"    LABEL "Employee ID"     COLUMN-LABEL " Emp ID"          FORMAT "x(12)"

When a ProDataSet is built using this temp-table as a buffer, the associated XSD reads (in part):
<?xml version="1.0" encoding="utf-16"?>
<xs:schema id="dsEmployee" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop">
  <xs:element name="dsEmployee" msdata:IsDataSet="true" msdata:Locale="" msprop:PROGRESS.brejected="False" msprop:PROGRESS.bdata_source_mod="False">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="ttEmployee" msdata:Locale="" msprop:PROGRESS.bundo="False" msprop:PROGRESS.errorString="" msprop:PROGRESS.bdata_source_mod="False" msprop:PROGRESS.brejected="False" msprop:PROGRESS.bimage_flag="True">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="empid" msdata:Caption="Employee ID" msprop:PROGRESS.progressType="1" msprop:PROGRESS.position="2" msprop:PROGRESS.user_order="0" type="xs:string" minOccurs="0" />

*****
As seen in the example above, the only field-option passed in the XSD is 'Caption'.  We would like to be able to pass the values for additional field-options (namely the XML-NODE-NAME and COLUMN-LABEL values) in the XSD of an associated dataset to a .NET client to consume. 

All Replies

This thread is closed