Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / .NET Framework / General / November 2004

Tip: Looking for answers? Try searching our database.

LIKE operation on SYSTEM.DECIMAL

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ksedran - 04 Nov 2004 22:33 GMT
Hello all,

I am having an issue with a dataview.RowFilter expression.

I am trying to filter a dataview with the following:

DV_TXN.RowFilter = "MCC LIKE '" & MCCselection & "'"

But get the following error:
"Cannot perform 'Like' operation on System.Decimal and System.String"

The datatype of the "MCC" column in the oracle table is NUMBER.

Any ideas on how I can filter this??

Thanks in advance!

Signature

Kevin

W.G. Ryan eMVP - 04 Nov 2004 23:27 GMT
You can create an expression column on your datatable that simply converts
the decimal column to string and you can compare on this new column.

Signature

W.G. Ryan, MVP

www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com

> Hello all,
>
[quoted text clipped - 12 lines]
>
> Thanks in advance!
Cor Ligthert - 05 Nov 2004 10:11 GMT
To add a little bit to the text from Bill.

> You can create an expression column on your datatable that simply converts
> the decimal column to string and you can compare on this new column.

You can create an extra column in your datatable. Direct with that command
you can use the expression to fill the data that than converts the decimal
column to string. Than you can compare on this new column.

By the way, did you know that there are newsgroups
microsoft.public.dotnet.framework.adonet
microsoft.public.dotnet.languages.vb

That are newsgroups more specialized on questions like this, where for this
question the first one is in my opinion the right one.

Cor

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.