Thread: function in command text - ASP.NET
View Single Post
  #1 (permalink)  
Old 11-10-2008, 5:10 PM
casper casper is offline
VB.NET Forum Newbie
.NET Framework: .NET 2.0 (VS 2005)
  
Join Date: Jun 2006
Posts: 10
Reputation: 48
casper is on a distinguished programming path ahead
Default function in command text - ASP.NET
can you really have a function in the command text?

I have a line of code as below:

oCommand.CommandText = "UPDATE [SHEET1$] SET TEST = replace([test], '~', ';')"

I keep getting an error "Undefined function 'Replace' in expression"
Reply With Quote