how do i deal with the error "DATA TYPE MISMATCH IN CRITERIA EXPRESSION" in VB6?

dataExam.RecordSource = "SELECT [exam score] FROM exams WHERE [Sctr] = '" & DataStudandClass.Recordset(0).value & "' AND [Cctr] = '" & DataStudandClass.Recordset(1).value & "'"

dataExam.Refresh 'when i click debug, this line is highlighted

Update:

Both Sctr and Cctr are autoNumbers...

3 Answers

Relevance
  • 1 decade ago
    Best Answer

    You need to check the datatypes for [Sctr] and [Cctr] and verify that you are plugging in the right data type. It is hard to give you a solution without seeing the types of the table.

    ***EDIT***

    Are you using single quotes for the numbers? It is kind of hard to tell here. Do not use single quotes or double quotes for numeric values. Just a thought.

  • launer
    Lv 4
    3 years ago

    it is traditionally a bother along with your the placement clause. you're announcing "the place 'something' equals 'some element else'. those 2 values must be on the instant comparable, the two provided that they are the comparable documents type (e.G. each and each numbers), or they're close enogh for an implicit conversion. Double ensure your total '=' and ensure the two gadgets are the equivalent documents form.

  • 1 decade ago

    It's probably a problem with your WHERE clause. You are saying "Where 'something' equals 'something else'. Those two values need to be directly comparable, either because they are the same data type (e.g. both numbers), or they are close enogh for an implicit conversion.

    Double check all of your '=' and make sure the two items are the same data type.

Still have questions? Get your answers by asking now.