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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problem with 'in' operator, if used with select command 2
problem with 'in' operator in select query 1
The 'Select' query sometime does not return all the records with . 2
The 'Select' query sometime does not return all the records with . 1
Headset microphone operation, and multiple microphone set-ups 1
With F1 value, look at A, if match or partial match return B 5
Multiple Selection Criterial Query some with NULL fields 5
Subquery Correllated In Select Clause - Is this possible? 3

Back
Top