C Sharp and SQL (1)
dehorning The other day I thought it could have equivodo in this SQL statement, guess what the error ?:
string SQL = "INSERT INTO Programme (Name, Anio, Version, Type, ENISA, InstaladoEnPortatil, InstaladoEnPC, Comments, Description, Manufacturer, CuandoCaduca, EsLibre, ParaWindows, ParaLinux, ParaMacintosh, ConCrack, Serial, User, Password) VALUES ( '"+ _programa.nombre.ToUpper () +"', '"+ _programa.anio +"', '"+ _programa.version +"' "+ _programa.codTipo +" "+ _programa.enISO +" "+ _programa.instaladoEnPortatil +" "+ _programa.instaladoEnPC +" '"+ _programa.observaciones +"', '"+ _programa.descripcion +"', '"+ _programa.fabricante +"', '"+ _Programme . cuandoCaduca + "'" + _programa.esLibre + "" + _programa.paraWindows + "" + _programa.paraLinux + "" + _programa.paraMacintosh + "" + _programa.conCrack + "'" + _programa.serial + "','" + _programa.usuario + "','" + + "')";
_programa.password
browsed Have they good?
As the problem was that Password to be a reserved word can not be used as the name for a field in a table with Access database. Then I tried to change it ClaveDeAcceso, and error, erroneous SQL statement, he vanished.
Greetings.
0 comments:
Post a Comment