[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.dotnet.framework.odbcnet

dataset

freddy parra

3/3/2005 12:41:00 AM

Good day.
We have a trouble with a datatable field in a dataset (FH.GTVTC).
It has a sum expression referencing a child datatable field (BH.SVTC).
This Field is also a sum expression from another child datatable field
(ED.VT).
Problem is than dt1.f1 value is not sum(BH.SVTC) but first row BH.SVTC value.
How can we fixed. It´s very important this can work properly.
Note: A count field FH.GTC is working properly. FH.GTVTD has same trouble.
The DTD is:
<?xml version="1.0" standalone="yes"?>
<NCHCM>
<xs:schema id="NCHCM" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSc...
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="NCHCM" msdata:IsDataSet="true" msdata:Locale="es-CO">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element name="FG">
<xs:complexType>
<xs:sequence>
<xs:element name="IDFG" type="xs:integer" minOccurs="1" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="FH">
<xs:complexType>
<xs:sequence>
<xs:element name="IDFG" type="xs:integer" minOccurs="1"
default="1" />
<xs:element name="IDFH" type="xs:integer" minOccurs="1"
default="1" />
<xs:element name="CEDI" type="xs:string" minOccurs="1" />
<xs:element name="CEOI" type="xs:string" minOccurs="1" />
<xs:element name="FCA" type="xs:string" minOccurs="1" />
<xs:element name="HCA" type="xs:string" minOccurs="1" />
<xs:element name="IA" type="xs:string" minOccurs="1" />
<xs:element name="GTVTC" type="xs:integer"
msdata:Expression="Sum(Child([FH-BH]).SVTC)" minOccurs="0" /> <!--Here is the
problem-->
<xs:element name="GTVTD" type="xs:integer"
msdata:Expression="Sum(Child([FH-BH]).SVTD)" minOccurs="0" /> <!--Here is the
problem-->
<xs:element name="GTC" type="xs:integer"
msdata:Expression="Count(Child([FH-BH]).IDLote)" minOccurs="0" />

<xs:element name="Estado" type="xs:byte" default="2"
minOccurs="0" />
<xs:element name="Causal" type="xs:integer" default="0"
minOccurs="0" />
<xs:element name="Error" type="xs:string" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<!--File Control-->
<xs:element name="FC" maxOccurs ="1">
<xs:complexType>
<xs:sequence>
<xs:element name="IDFH" type="xs:integer" minOccurs="1"
maxOccurs ="1"/>
<xs:element name="CL" type="xs:integer" minOccurs="1"/>
<xs:element name="NT" type="xs:integer" minOccurs="1"/>
<xs:element name="TC" type="xs:integer" minOccurs="1"/>
<xs:element name="VTD" type="xs:integer" minOccurs="1"/>
<xs:element name="VTC" type="xs:integer" minOccurs="1"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<!--Encabezado Lote-->
<xs:element name="BH">
<xs:complexType>
<xs:sequence>
<xs:element name="IDFH" type="xs:integer" minOccurs="1"/>
<xs:element name="IDLote" msdata:AutoIncrement="true"
msdata:AutoIncrementSeed="1" type="xs:integer" minOccurs="0" />
<xs:element name="CCTL" type="xs:integer" minOccurs="1" />
<xs:element name="NCO" type="xs:string" minOccurs="1" />
<xs:element name="DDCO" type="xs:string" minOccurs="1" />
<xs:element name="ICO" type="xs:integer" minOccurs="1" />
<xs:element name="CTS" type="xs:integer" minOccurs="1" />
<xs:element name="DL" type="xs:string" minOccurs="1" />
<xs:element name="FDCO" type="xs:string" minOccurs="1" />
<xs:element name="FET" type="xs:integer" minOccurs="1" />
<xs:element name="REFO" type="xs:string" minOccurs="1" />
<xs:element name="TEFO" type="xs:string" minOccurs="1" />
<xs:element name="NL" type="xs:integer" minOccurs="1" />
<xs:element name="SVTC" type="xs:integer"
msdata:Expression="Sum(Child([BH-ED]).VTC)" minOccurs="0" />
<xs:element name="SVTD" type="xs:integer"
msdata:Expression="Sum(Child([BH-ED]).VTD)" minOccurs="0" />
<xs:element name="Estado" type="xs:byte" default="2"
minOccurs="0" />
<xs:element name="Causal" type="xs:integer" default="0"
minOccurs="0" />
<xs:element name="Error" type="xs:string" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<!--batch Control-->
<xs:element name="BC">
<xs:complexType>
<xs:sequence>
<xs:element name="IDLote" type="xs:integer" minOccurs="1"/>
<xs:element name="CCTL" type="xs:integer" minOccurs="1"/>
<xs:element name="NT" type="xs:integer" minOccurs="1"/>
<xs:element name="TC" type="xs:integer" minOccurs="1"/>
<xs:element name="VTD" type="xs:integer" minOccurs="1"/>
<xs:element name="VTC" type="xs:integer" minOccurs="1"/>
<xs:element name="ICO" type="xs:integer" minOccurs="1"/>
<xs:element name="CEFO" type="xs:string" minOccurs="1"/>
<xs:element name="NL" type="xs:integer" minOccurs="1" />
</xs:sequence>
</xs:complexType>
</xs:element>
<!--Transaccion-->
<xs:element name="ED">
<xs:complexType>
<xs:sequence>
<xs:element name="IDTrans" msdata:AutoIncrement="true"
msdata:AutoIncrementSeed="1" type="xs:integer" minOccurs="0" />
<xs:element name="IDLote" type="xs:integer" minOccurs="0"/>
<xs:element name="CT" type="xs:integer" minOccurs="0" />
<xs:element name="REFR" type="xs:string" minOccurs="0" />
<xs:element name="TEFR" type="xs:string" minOccurs="0" />
<xs:element name="DEFR" type="xs:string" minOccurs="0" />
<xs:element name="NCCR" type="xs:integer" minOccurs="0" />
<xs:element name="VT" type="xs:integer" minOccurs="0" />
<xs:element name="NICR" type="xs:integer" minOccurs="0" />
<xs:element name="NCR" type="xs:string" minOccurs="0" />
<xs:element name="DD" type="xs:string" minOccurs="0" />
<xs:element name="IRA" type="xs:integer" minOccurs="0" />
<xs:element name="NRTEO" type="xs:string" minOccurs="0" />
<xs:element name="NS" type="xs:integer" minOccurs="0" />
<xs:element name="NTEFR" type="xs:integer"
msdata:Expression="Convert(REFR + TEFR,'System.Int32')" minOccurs="0" />
<xs:element name="VTC" type="xs:integer"
msdata:Expression="IIF(CT in (22,32,52), VT, 0)" minOccurs="0" />
<xs:element name="VTD" type="xs:integer"
msdata:Expression="IIF(not CT in (22,32,52), VT, 0)" minOccurs="0" />
<xs:element name="IDFH" type="xs:integer" minOccurs="1"
default="1" />
<xs:element name="Estado" type="xs:byte" default="2"
minOccurs="0" />
<xs:element name="Causal" type="xs:integer" default="0"
minOccurs="0" />
<xs:element name="Error" type="xs:string" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<!--addenda-->
<xs:element name="AD">
<xs:complexType>
<xs:sequence>
<xs:element name="IDTrans" type="xs:integer" minOccurs="0"/>
<xs:element name="CTR" type="xs:integer" minOccurs="0" />
<xs:element name="IRP" type="xs:string" minOccurs="0" />
<xs:element name="NSRA" type="xs:integer" minOccurs="0" />
<xs:element name="NSRD" type="xs:integer" minOccurs="0" />
<xs:element name="Blanco" type="xs:string" minOccurs="0" />
<xs:element name="Estado" type="xs:byte" default="2"
minOccurs="0" />
<xs:element name="Causal" type="xs:integer" default="0"
minOccurs="0" />
<xs:element name="Error" type="xs:string" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<!--FILE GROUP-->
<xs:unique name="UQFG">
<xs:selector xpath=".//FG" />
<xs:field xpath="IDFG" />
</xs:unique>
<!--FILE HEADER-->
<xs:keyref name="FG-FH" refer="UQFG">
<xs:selector xpath=".//FH" />
<xs:field xpath="IDFG" />
</xs:keyref>
<xs:unique name="UQFH">
<xs:selector xpath=".//FH" />
<xs:field xpath="IDFH" />
</xs:unique>
<!--FILE CONTROL-->
<xs:keyref name="FH-FC" refer="UQFH">
<xs:selector xpath=".//FC" />
<xs:field xpath="IDFH" />
</xs:keyref>
<!--BH-->
<xs:keyref name="FH-BH" refer="UQFH">
<xs:selector xpath=".//BH" />
<xs:field xpath="IDFH" />
</xs:keyref>
<xs:unique name="UQLote">
<xs:selector xpath=".//BH" />
<xs:field xpath="IDLote" />
</xs:unique>
<!--BC-->
<xs:keyref name="BH-BC" refer="UQLote">
<xs:selector xpath=".//BC" />
<xs:field xpath="IDLote" />
</xs:keyref>
<!--ED-->
<!--xs:keyref name="FH-ED" refer="UQFH">
<xs:selector xpath=".//ED" />
<xs:field xpath="IDFH" />
</xs:keyref-->
<xs:keyref name="BH-ED" refer="UQLote">
<xs:selector xpath=".//ED" />
<xs:field xpath="IDLote" />
</xs:keyref>
<xs:unique name="UQTrans">
<xs:selector xpath=".//ED" />
<xs:field xpath="IDTrans" />
</xs:unique>
<!--AD-->
<xs:keyref name="ED-AD" refer="UQTrans">
<xs:selector xpath=".//AD" />
<xs:field xpath="IDTrans" />
</xs:keyref>
</xs:element>
</xs:schema>
<FG>
<IDFG>1</IDFG>
</FG>
</NCHCM>

Atte
Neurona Team.