Data type mismatch in criteria expression.

[veda55536]

Hi,

I've been trying to execute below query in C#.(DataBase :Access)

strTemp = "SELECT Students.Studen tid, Persons.FirstNa me FROM (Persons INNER JOIN Students ON Persons.PersonI d = Students.Person Id) " +
"WHERE Students.Studen tid not in ( select UnableToEnterSc hools.Studentid from UnableToEnterSc hools where UnableToEnterSc hools.SchoolId = " + SchoolId.ToStri ng() + ")";

i.e...

SELECT Students.Studen tid, Persons.FirstNa me FROM (Persons INNER JOIN Students ON Persons.PersonI d = Students.Person Id) WHERE Students.Studen tid not in ( select UnableToEnterSc hools.Studentid from UnableToEnterSc hools where UnableToEnterSc hools.SchoolId = 1)

I'm getting below ERROR message,

Data type mismatch in criteria expression.

Please help me out in passing this obstacle.

Thanks in advance.

Regards,
Bob

[r035198x]

.. where UnableToEnterSc hools.SchoolId = " + SchoolId.ToStri ng() + ")";

..

Your problem is probably in the quote above.
If the datatype of UnableToEnterSc hools.SchoolId is some numeric value then you shouldn't be calling ToString() on SchoolId.ToStri ng(). That would mean you are comparing a numeric column with a character column.

[Curtis Rutland]

I don't think that's the problem, r0. Since that is just the string building part, that's ok.

I think that you should post the actual string. Like, do a MessageBox or Console.WriteLi ne of the string that you build and show exactly what you are passing on to the database.

[r035198x]

I don't think that's the problem, r0. Since that is just the string building part, that's ok.

I think that you should post the actual string. Like, do a MessageBox or Console.WriteLi ne of the string that you build and show exactly what you are passing on to the database.

I see what you mean now. Perhaps the column definitions for the OP's tables should also be posted to provide more information.