I am trying to insert data into my database, but I get the "data type mismatch in criteria expression" error. Everything in the database is stored as text EXCEPT the autonumber field id. It is the first field in the database.
This is my insert:
I tried to insert an empty string into the id field and that's what gives me the error.Code:
String query = "INSERT INTO Customer VALUES ('','" + fname + "','"+ lname + "','" + address + "','"+ city + "','"+ state + "','"+ zipcode + "','"+ phone + "')";
I just need to know how to deal with the autonumber field...somebody pls help...and thx :)