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 "")    

 








Posted by



at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)