Consultor Eletrônico

Status: Unverified

SYMPTOM(s):

4GL/ABL: OpenAPI: Primary keys are lost when loading an XML file into .NET Dataset.

Loading an XML file created by WRITE-XML method operating on a ProDataSet with TEMP-TABLE that has a primary index into a .NET dataset using OpenAPI .NET looses the primary index information.

The XML file is generated using the WRITE-XML method operating on an OpenEdge ProDataSet with TEMP-TABLE that has a primary index.

FACT(s) (Environment):

Windows
OpenEdge 10.1B

CAUSE:

This is a Microsoft .NET limitation. The Microsoft .NET only recognizes its proprietary attribute msdata:PrimaryKey (namespace "urn:schemas-microsoft-com:xml-msdata") in an XML Schema to signify a primary key, and Progress can not use the attributes in the Microsoft namespace in its XML Schema. Progress uses its own prodata:primaryIndex instead.

FIX:

Avoid loading an XML file created by WRITE-XML method operating on a ProDataSet with TEMP-TABLE that has a primary index into a .NET dataset using OpenAPI .NET or preprocess the XML file generated by the WRITE-XML method to make it recognizable by the the Microsoft .NET.