Olá como sabem sou um javanes iniciante…rs***
o código abaixo
cSql = "UPDATE ARPARLOC SET " +
“DIRSER=’” + TxtDirArqServ.getText() + “’,” +
“DIRLOC=’” + TxtArqLocaEst.getText() + “’,” +
“NUMCAI=’” + cNumCai + “’,” +
“TIPLEC=’” + Mid_Combo(cmbTeclado.getSelectedItem().toString()) + “’,” +
“TIPIMP=’” + Mid_Combo(cmbImpressora.getSelectedItem().toString()) + “’,” +
“TIPGAV=’” + Mid_Combo(cmbGaveta.getSelectedItem().toString()) + “’,” +
“TIPTEC=’” + Mid_Combo(cmbTeclado.getSelectedItem().toString()) + “’,” +
“NOMFAN=’” + TxtNomFan.getText() + “’,” +
“POSALI=’” + cPosICM + “’,” +
“ALIQ01=’” + TxtAliq01.getText() + “’,” +
“ALIQ02=’” + TxtAliq02.getText() + “’,” +
“ALIQ03=’” + TxtAliq03.getText() + “’,” +
“ALIQ04=’” + TxtAliq04.getText() + “’,” +
“ALIQ05=’” + TxtAliq05.getText() + “’,” +
“ALIQ06=’” + TxtAliq06.getText() + “’,” +
“ALIQ07=’” + TxtAliq07.getText() + “’,” +
“ALIQ08=’” + TxtAliq08.getText() + “’,” +
“ALIQ09=’” + TxtAliq09.getText() + “’,” +
“ALIQ10=’” + TxtAliq10.getText() + “’,” +
“ALIQ11=’” + TxtAliq11.getText() + “’,” +
“ALIQ12=’” + TxtAliq12.getText() + “’,” +
“NUMSER=’” + TxtNSerieImp.getText() + “’,” +
“PORIMP=’” + cmbPortaImpre.getSelectedItem().toString().substring(3,4) + “’,” +
“MODOFF=’” + Salva_Check(chkTrabalhaOffline) + “’,” +
“TABICM=’” + Salva_Check(chkUtilizaTabelaICMS) + “’,” +
“LNKCLI=’” + Salva_Check(chkConsulCadCli) + “’,” +
“LNKVEN=’” + Salva_Check(chkConsultaCadastroVendedores) + “’,” +
“LNKCPG=’” + Salva_Check(chkConsultaCondPagamento) + “’,” +
“LNKORC=’” + Salva_Check(chkAnexaOrcamentoPedido) + “’,” +
“LNKCRE=’” + Salva_Check(chkLancaContasReceber) + “’,” +
“LNKCAI=’” + Salva_Check(chkTerminalCaixa) + “’,” +
“IMPUNI=’” + Salva_Check(chkImpostoUnico) + “’,” +
“LNKPVE=’” + Salva_Check(chkLancaVendasRetaguarda) + “’,” +
“DIRAUX=’” + TxtAuxEst.getText() + “’,” +
“DIRDOS=’” + TxtSeguraEst.getText() + “’,” +
“CODLOJ=’” + “01” + “’,” +
“DIRTMP=’” + TxtArqLocaEst.getText() + “’,” +
“PRORET=’” + Salva_Check(chkBuscaRetaguarda) + “’,” +
“ATUBCO=’” + Salva_Check(chkAtualizaBanco) + “’,” +
“MELDES=’” + Salva_Check(chkDesempenho) + “’,” +
“LANEST=’” + Salva_Check(chkLancaEstoque) + “’,” +
“MAPRED=’” + Salva_Check(chkMapearUnidade) + “’,” +
“UNIRED=’” + TxtUniRed.getText() + “’,” +
“NOMSER=’” + TxtNomSer.getText() + “’,” +
“UTLTEF=’” + Salva_Check(chkUtilizaTEF) + “’,” +
“VOLSER=’” + TxtVolSer.getText() + “’” ;
/* “ESTORI=’” & TxtEstado & “’,” & _ */
try {
System.out.println("
" + cSql + "
");
Class.forName(cConexao).newInstance();
Connection cConn = DriverManager.getConnection(cDriverUrl);
Statement stmt = cConn.createStatement();
stmt.execute(cSql);
mBox.showMessageDialog(null,“Dados alterados com sucesso!”,“Ok”,mBox.INFORMATION_MESSAGE);
mBox = null;
}
catch(Exception ex) {
ex.printStackTrace();
}
dá o seguinte erro:
java.sql.SQLException: Failed to parse: Couldn’t repair and continue parse
at com.hxtt.c.c.a(Unknown Source)
at com.hxtt.c.c.a(Unknown Source)
at com.hxtt.c.c.case(Unknown Source)
at com.hxtt.sql.StatementInfo.a(Unknown Source)
at com.hxtt.sql.StatementInfo.(Unknown Source)
at com.hxtt.sql.HxttSQL.a(Unknown Source)
at com.hxtt.sql.HxttStatement.a(Unknown Source)
at com.hxtt.sql.HxttStatement.execute(Unknown Source)
Alguém pode me dizer o porque tá dando este erro?
Valeu Thanks!