I am getting the message Incorrect syntax near the keyword 'Transaction'. I
have looked and looke dna dlooked and searched and searched to no avail. the
XSD file is below. I left out the simple types, except for the one used by
transaction, for the sake of space. Any help would be appreciated.
<?xml version="1.0"?>
<xs:schema id="FileSummary"
xmlns:sql="urn:schemas-microsoft-com:mapping-schema"
xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:annotation>
<xs:appinfo>
<sql:relationship name="FailTrans_Trans" parent="FailedTransaction"
parent-key="TransactionType" child="Transactions"
child-key="TransactionType"/>
<sql:relationship name="FileSum_SuccTrans" parent="FileSummary"
parent-key="ProcessedFileName" child="SuccessfulTransactions"
child-key="ProcessedFileName" />
<sql:relationship name="Tl_ST" parent="FileSummary"
parent-key="ProcessedFileName" child="SuccessfulTransactions"
child-key="ProcessedFileName"/>
<sql:relationship name="ST_TR" parent="SuccessfulTransactions"
parent-key="TransactionType" child="Transactions"
child-key="TransactionType"/>
<sql:relationship name="FS_FT" parent="FileSummary"
parent-key="ProcessedFileName" child="FailedTransactions"
child-key="ProcessedFileName" />
<sql:relationship name="FT_RC" parent="FailedTransactions"
parent-key="TransactionType" child="REOCases" child-key="TransactionType" />
<sql:relationship name="RC_TR" parent="REOCases"
parent-key="TransactionType" child="Transaction" child-key="TransactionType"
/>
<sql:relationship name="FT_TR" parent="FailedTransactions"
parent-key="TransactionType" child="Transactions" child-key="TransactionType"
/>
<sql:relationship name="FS_FE" parent="FileSummary"
parent-key="ProcessedFileName" child="FileError"
child-key="ProcessedFileName"/>
</xs:appinfo>
</xs:annotation>
<xs:element name="FileSummary" sql:is-constant="true" >
<xs:complexType>
<xs:sequence>
<xs:element name="ResponseHeader" type="SummaryHeaderType" />
<xs:element name="ProcessedFileName" type="xs:string" />
<xs:element name="FileProcessedDateAndTime" type="xs:dateTime"
/>
<xs:element name="TotalTransactions" type="xs:int" />
<xs:element name="TotalSuccessfulTransactions" type="xs:int" />
<xs:element name="TotalFailedTransactions" type="xs:int" />
<xs:element minOccurs="0" name="SuccessfulTransactions"
sql:relation="SuccessfulTransactions" sql:relationship="Tl_ST" >
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" name="Transactions"
sql:relation="Transactions" sql:relationship="ST_TR"
sql:key-fields="TransactionType" type="IncomingTransactionSummaryType" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="FailedTransactions"
sql:relation="FailedTransactions" sql:relationship="FS_FT" >
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" name="Transactions"
sql:relation="Transactions" sql:relationship="FT_TR"
sql:key-fields="TransactionType" type="IncomingTransactionSummaryType" />
<xs:element maxOccurs="unbounded" name="REOCases"
sql:relation="REOCases" sql:relationship="FT_RC" sql:key-fields="reo_id">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded"
name="Transaction" sql:relation="Transaction" sql:relationship="RC_TR"
sql:key-fields="TransactionType">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded"
name="transactionType" type="IncomingTransactionTypeCode" />
<xs:element maxOccurs="unbounded"
name="errorMessage" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="reo_id" type="REOIDType" />
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="FileError"
sql:relation="FileError" sql:key-fields="ProcessedFileName"
sql:relationship="FS_FE">
<xs:complexType>
<xs:sequence>
<xs:element name="errorMessage"
type="AlphaNumeric4000Type" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:complexType>
<xs:complexType name="IncomingTransactionSummaryType">
<xs:annotation>
<xs:documentation>Transactions complex element used in File Summary
schema</xs:documentation>
</xs:annotation>
<xs:all>
<xs:element name="transactionCount" type="xs:int" />
<!--<xs:element name="transactionType" type="IncomingTransactionTypeCode"
/>-->
</xs:all>
</xs:complexType>