do not understand the following error

[Yoramo]

I'm getting the following error: "Cannot interpret token 'Child' at position
1."

when I run the following code:
sqlDataAdapter1.Fill(ds1,"Table1") ;
sqlDataAdapter2.Fill(ds1,"bbb") ;
ds1.Relations.Add("id2pk",ds1.Tables["Table1"].Columns["fk"],ds1.Tables["bbb
"].Columns["id"]) ;
ds1.Tables["Table1"].Columns.Add("Exp1",typeof(int),"Child(id2pk).id") ;

can any one explain?
Thanks in advance
Yoramo.

 

[Miha Markic]

Hi Yoramo,

You need to use one of the aggregation functions on child, because there
might be more that one child rows.
This is what the help says:
However, because child relationships may return multiple rows, you must
include the reference to the child column in an aggregate function. For
example, Sum(Child.Price) would return the sum of the column named Price in
the child table.

 

[Yoramo]

is there a aggregation function for strings? I need my field to be of type
string.

Thanks
Yoramo

Hi Yoramo,

You need to use one of the aggregation functions on child, because there
might be more that one child rows.
This is what the help says:
However, because child relationships may return multiple rows, you must
include the reference to the child column in an aggregate function. For
example, Sum(Child.Price) would return the sum of the column named Price in
the child table.

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

I'm getting the following error: "Cannot interpret token 'Child' at position
1."

when I run the following code:
sqlDataAdapter1.Fill(ds1,"Table1") ;
sqlDataAdapter2.Fill(ds1,"bbb") ;

ds1.Relations.Add("id2pk",ds1.Tables["Table1"].Columns["fk"],ds1.Tables["bbb

"].Columns["id"]) ;
ds1.Tables["Table1"].Columns.Add("Exp1",typeof(int),"Child(id2pk).id") ;

can any one explain?
Thanks in advance
Yoramo.

 

[Miha Markic]

Hi Yoramo,

I don't think you can aggregate strings.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

is there a aggregation function for strings? I need my field to be of type
string.

Thanks
Yoramo

Hi Yoramo,

You need to use one of the aggregation functions on child, because there
might be more that one child rows.
This is what the help says:
However, because child relationships may return multiple rows, you must
include the reference to the child column in an aggregate function. For
example, Sum(Child.Price) would return the sum of the column named Price in
the child table.

ds1.Relations.Add("id2pk",ds1.Tables["Table1"].Columns["fk"],ds1.Tables["bbb

"].Columns["id"]) ;
ds1.Tables["Table1"].Columns.Add("Exp1",typeof(int),"Child(id2pk).id") ;

can any one explain?
Thanks in advance
Yoramo.

 

[Yoramo]

what can I do with strings?

Hi Yoramo,

I don't think you can aggregate strings.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

is there a aggregation function for strings? I need my field to be of type
string.

Thanks
Yoramo


Price
in

ds1.Relations.Add("id2pk",ds1.Tables["Table1"].Columns["fk"],ds1.Tables["bbb

"].Columns["id"]) ;

ds1.Tables["Table1"].Columns.Add("Exp1",typeof(int),"Child(id2pk).id")

;

 

[Miha Markic]

Hi,

I guess pretty much nothing.

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

what can I do with strings?

Hi Yoramo,

I don't think you can aggregate strings.

ds1.Relations.Add("id2pk",ds1.Tables["Table1"].Columns["fk"],ds1.Tables["bbb

"].Columns["id"]) ;

ds1.Tables["Table1"].Columns.Add("Exp1",typeof(int),"Child(id2pk).id")

;

can any one explain?
Thanks in advance
Yoramo.