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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
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
 
Back
Top