You have an error in your SQL syntax check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit,idno) VALUES(_binary ', Text: 1001', _binary '' at line 1īeside '?' ,i have tried also before using for the p variable but same result "VALUES(?p1, ?p2, ?p3, ?p4, ?p5, ?p6, ?p7, ?p8, ?p9, ?p10, ?p11, ?p12, ?p13, ?p14)"ĬMD.Parameters.AddWithValue("?p1", kodetxt)ĬMD.Parameters.AddWithValue("?p2", namatxt)ĬMD.Parameters.AddWithValue("?p3", alamattxt)ĬMD.Parameters.AddWithValue("?p4", viptxt)ĬMD.Parameters.AddWithValue("?p5", tanggallahirtxt)ĬMD.Parameters.AddWithValue("?p6", nationalitytxt)ĬMD.Parameters.AddWithValue("?p7", perusahaantxt)ĬMD.Parameters.AddWithValue("?p8", specialratetxt)ĬMD.Parameters.AddWithValue("?p9", diskontxt)ĬMD.Parameters.AddWithValue("?p10", segmentxt)ĬMD.Parameters.AddWithValue("?p11", purposetxt)ĬMD.Parameters.AddWithValue("?p12", settledbytxt)ĬMD.Parameters.AddWithValue("?p13", limittxt)ĬMD.Parameters.AddWithValue("?p14", idnotxt)Īfter execution vb result error as below: GUESTMEMBER(membercode,nama,alamat,vip,birthday,nation,company,specialrate,diskon,segmen,purpose,settledby,limit,idno) " & _ I Have error result when executing these code I use MySql 5.7, Net Connector 6.6.7 and Visual Studio Vb Net 2008
0 Comments
Leave a Reply. |