problem with 'in' operator, if used with select command

[Guest]

problem with 'in' operator, if used with select query

sometimes it does not return all the records,
for ex.
select * from modelmaster where model in ('a','b','c')

sometimes it returns partial recordset. (most frequent with complex quries)
why?

 

[Van T. Dinh]

Beware that if the field values of the Filed "Model" have white spaces, e.g.
'a{space}', JET may or may not pick this up as the same as 'a'.

However, the problem is likely to be in your "complex queris", not in the In
operator.

 

[Guest]

Thanks for replying...

I used the 'In' Operator in my vb project with 'Jet driver' to generate
reports. I got incomplete report on the first attempt, but got the compelete
report on next attempt. (I also verified the recordset on incomplete report,
the records are missing)
I can't understand why this happens.


Sanjay Limbikai