Power raising in a datacolumn expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

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)
 
Hi Jos,

It should be like

MyDataSet.Tables("MyTable").Columns("NewColumn").Expression = "FirstColumn ^
1.2345"
 
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




Val Mazur (MVP) said:
Hi Jos,

It should be like

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

--
Val Mazur
Microsoft MVP

http://xport.mvps.org
Click to expand...
 
Back
Top