posted 16 years ago
i have tried this.
long DATE= Date.parse("12/1/2006");
stat.executeUpdate("insert into ORDERS (CoustmerID,serviceID,service_details,order_no,date) values('"+keyCostumer+"','"+keyservice+"','"+keyservice_Details+"','"+OrderId+"','"+DATE+"')");
this error message
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Sy
ntax error in INSERT INTO statement.