Power raising in a datacolumn expression

[Guest]

Hello,

Does anybody know how to use power raising in a datacolumn expression ??

Example:

NewColumn = FirstColumn ^ 1.2345

or

NewColumn = Power (FirstColumn,1.2345)

 

[Val Mazur \(MVP\)]

Hi Jos,

It should be like

MyDataSet.Tables("MyTable").Columns("NewColumn").Expression = "FirstColumn ^
1.2345"

 

[Guest]

Hello Val,

Thanks for your response.

I already tried this, but power raising using the ^ operator is not
supported in an expression. So I am looking for an acceptable work around.

Jos Beelen

Hi Jos,

It should be like

MyDataSet.Tables("MyTable").Columns("NewColumn").Expression = "FirstColumn ^
1.2345"

--
Val Mazur
Microsoft MVP

http://xport.mvps.org