Programming with VB causes a data type mismatch in standard expressions

private sub cha_click()dim sql as string

sql = "select * from usage record where kahao='" & text1(0).text & "'or " & "(shijian>='" & text2(1).text & "' and shijian<='" & text3(2).

text & "')"

What is the data type of the shijian field, if it is a time type, it cannot be in single quotation marks, or should be changed to and, otherwise there will be many records with different card numbers.

The SQL sentence is to get the query recordset.

update is to modify this record, which control is bound to the shijian field? Besides, why do you want to modify it now, you don't know what the status of the query recordset is, what if the query recordset is empty? What if there are more than one?

Remove it and see.

Flushed? update doesn't work, and this sentence doesn't do anything.

end sub

Time is used between ...and try, I remember so.

sql = "select * from usage record where kahao='" & text1(0).text & "'or " & "(shijian>='" & text2(1).text & "' and shijian<='" & text3(2).

text & "')"

Missing parentheses.

Hello dear<>

The answer you are looking for: The data type mismatch in the standard expression means that when you use the standard expression, the data type involved in the expression is inconsistent with the required data type. For example, if a standard expression requires an integer to be entered, but a string type of data is entered, a data type mismatch error will occur.

In this case, you need to check the data type requirements in the standard expression, and then double-check whether the data type entered meets the requirements. If the entered data type does not meet the requirements, you need to convert the data type or change the data type to meet the requirements of the standard expression. For example, if a standard expression requires the input of integer data, but the input is of the quiet string type, you can use the type conversion function provided by the language to convert the string type to an integer type, such as the atoi() function in C++ and the int() function in Python.

If you're not sure what type of data is required in a standard expression, you can check the documentation or consult the relevant technician.