XSD/XML; parent-child relationship#1; parent-child relationship #2

XSD/XML; parent-child relationship#1; parent-child relationship #2

Post by John_of_M » Fri, 12 Sep 2003 04:48:02


ot sure if this will solve your problem, but I had the
same error and after some reading i found that I needed
to usse the sql:key-fields attribute to specify the
primary keys on the tables concerned

for example: on the following node
<xsd:element name="HoldingClaims"
sql:relation="TBL_Holding_Claim" >

add sql:key-fields="primary key columns seperated by
comma"

Do this to all your nodes with sql:relationship
attributes. I don't know the exact reason, but doing this
made my relationships work exactly as I expected them to
work.

John

propogate the
this. Please
works. I'm
simple that
path.
against this
parent/child
it under the
parent-child
---
schema">
sql:relation="TBL_Vendor_Identity" >
type="xsd:integer" />
type="xsd:string" />
type="xsd:integer" />
type="xsd:string"
type="xsd:integer" />
type="xsd:string"
type="xsd:float" />
type="xsd:date" />
name="Contract_Identifier" type="xsd:string" />
type="xsd:float" />
sql:relation="TBL_Holding_Insured"
sql:relationship="ClaimsOfTheInsured" >
type="xsd:string" />
name="Insured_Type"
type="xsd:string" />
name="Insured_Last_Name"
type="xsd:string" />
name="Insured_First_Name"
type="xsd:string" />
name="Insured_Middle_Name"
type="xsd:string" />
name="Insured_Suffix"
type="xsd:string" />
name="Patient_Number"
type="xsd:string" />
type="xsd:string" />
name="Insured_Address1"
type="xsd:string" />
name="Insured_Address2"
type="xsd:string" />
name="Insured_City"
type="xsd:string" />
name="Insured_State"
type="xsd:string" />
name="Insured_Postal_Code"
type="xsd:string" />
name="Insured_Country"
type="xsd:string" />
type="xsd:date" />
name="Insured_Gender"
type="xsd:string" />
name="Holding_Claim_PK"
type="xsd:integer" />
name="HoldingServiceLines"
sql:relation="TBL_Holding_Service_Lines"
sql:relationship="ServiceLinesOfClaims" >
minOccurs="1">
name="Line_Counter" type="xsd:integer" />
name="Service_Date_From" type="xsd:date" />
name="Service_Date_To" type="xsd:date" />
name="Service_ID_Qualifier" type="xsd:string" />
name="Procedure_Code" type="xsd:integer" />
name="Modifier_1"
type="xsd:string" />
type="xsd:string" />
name="Modifier_3"
type="xsd:string" />
name="Modifier_4"
type="xsd:string" />
name="Line_Amount" type="xsd:float"
/>
name="Unit_Qualifier" type="xsd:string" />
name="Line_Units" type="xsd:integer"
/>
name="Place_of_Service_PK" type="xsd:integer" />
name="Diagnosis_Pointer_1" type="xsd:string" />
name="Diagnosis_Pointer_2" type="xsd:string" />
name="Diagnosis_Pointer_3" type="xsd:string" />
name="Diagnosis_Pointer_4" type="xsd:string" />
name="Contract_Identifier" type="xsd:string" />
name="Contract_Amt" type="xsd:float" />
name="Line_Note"
type="xsd:string" />
name="Note_Code"
type="xsd:string" />
name="Holding_Claim_PK" type="xsd:integer" />
name="HoldingClaimProvider"
sql:relation="TBL_Holding_Claim_Provider"
sql:relationship="ProvidersOfClaims" >
name="Holding_Service_PK" type="xsd:integer"
name="Provider_Type_PK" type="xsd:integer" />
name="Entity_Type"
type="xsd:string" />
name="Provider_Last_Name" type="xsd:st