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.