Cannot perform 'like' operation on system.double and system.string

[mjassalina]

Hi, Im experiencing this error, Can anyone help me regarding this?

Here's the code:


LstTableBindingSource.Filter = "(Convert([Defect ID], 'System.String') LIKE '" & txtSearch.Text & "')" &
"OR (Sen LIKE '" & txtSearch.Text & "')"


Thank you.

 

[strongm]

Which bit of this question relates to VB6?

System.String suggests this to be related to VB.NET, and thus better asked in forum1867

 

[combo]

Pure syntax logic: missing space before OR.

combo

 

[strongm]

>missing space before OR.

Nope. As I say, this is a VB.NET question, and system.data filter doesn't barf on a missing space after a closing parenthesis. And if it DID, then it would produce a different system.data runtime error to the one being reported here.

But the error is in the OR clause, and the error is pretty specific about what the problem is: Sen is clearly a double (or is being coerced to one somewhere), and needs to be converted - just like [Defect ID]- to a string.

As I say, would have been better to ask this in forum1867

 

[mjassalina]

IM so sorry. I'm new to programming. I will closed this thread. Thank you for the guidance. I appreciated your replies.