Thursday, 15 January 2015

sql - Data Type Mismatched Query -


I am using VB and Access, try to use, select statement filtering WHERE EmployeeID Equals that is an int value, but giving me an error is the data type mismatch

  set MyRec = MyDB.OpenRecordset (select "id from employee WHERE employee = '" and User input and "")   

I feel that something like this happens that you create a query When this is where the statement of INT values ​​is done. Thank you guys.

Exclude single quotation marks.

  set MyRec = MyDB.OpenRecordset ("ID of WHERE employee from select employee =" & user input and "")    

No comments:

Post a Comment