Operator/operand type mismatch

Question

I'm using the Visual FoxPro OLE DB provider to query a VFP DB and I'm getting:

System.Data.OleDb.OleDbException 'Operator/operand type mismatch`

What could I be doing wrong?

Answer 1

In my where clause I had an int on one side and a char(15) on the other side

Table Schema

id int

Query

SELECT *
FROM [some-table]
WHERE id = 'some string'