Advanced dataset filtering help.

[Iamthewalrus15]

arows = ListsTBL.Select("col001 like '%caseIMDATA1%\" & BOID & ".tif'")

Ok the this is the dataset filter criteria it translates out to:


col001 like '%caseIMDATA1%\30301.tif' :::::::::: as the filter

In sql the equivalant

select * from lists where col001 like '%caseIMDATA1%\30301.tif'

works like a charm!

IN vb.net i get this error:

An unhandled exception of type 'System.Data.EvaluateException' occurred in system.data.dll

Additional information: Error in Like operator: the string pattern '%caseIMDATA1%\30301.tif' is invalid.


Please anyone that can privde any info help! My entire project has been leading up to the requirements of this filter to work, else i have a LOT of rewrite to do :/

[nswan]

try using *'s instead of %'s

[Iamthewalrus15]

I don't think the problem is in the wildcard character because running a filter with %fred works absolutely fine.

[Iamthewalrus15]

I figured out a way around this using multiple queries, but does anyone know if this is a bug in vb.net? or just not supported?