DataTable.Compute Problem 1

[ceyhorn]

I have been racking my brains for hours over this.

totalNewHours = myTable.Compute("SUM(Time)", "FundSourceIni = AH")

This code is suppose to take the sum of all the rows in "Time" while adding up only rows with "AH" in the FundSourceIni column. I keep getting "column AH does not exist. Any ideas to why? Thanks in advance.

Chris

 

[JCruz063]

Chris,
The column type where AH is is probably of type string, isn't it? If yes, then add single quotes around AH and it should work fine:

totalNewHours = myTable.Compute("SUM(Time)", "FundSourceIni = [COLOR=red][b]'[/b][/color]AH[COLOR=red][b]'[/b][/color]")

JC

Oh Wow!!! I was unaware of all the smileys available here at tek-tips.

 

[ceyhorn]

I'm such an idiot. Thanks

 

[ceyhorn]

But what if I want to pass in a variable like:

totalNewHours = myTable.Compute("SUM(Time)", "FundSourceIni = Variable")

Thanks again

 

[JCruz063]

It works the same way... simply do this:

totalNewHours = myTable.Compute("SUM(Time)", "FundSourceIni = [COLOR=red][b]'[/b][/color]" + Variable + "[COLOR=red][b]'[/b][/color]")

I'm assuming you're using C#. If our using Visual Basic .NET, the concatenation operator is & as opposed to the plus sign (+).

JC

Oh Wow!!! I was unaware of all the smileys available here at tek-tips.

 

[Isadore]

JCruz - excellent post - thanks.