SQL table field named "Language" giving SQL error - delphi -


i building application school displays , adds entries tables in neat , user friendly way. whilst programming "adding of new records" part, came across error

syntax error in insert statement 

i tried fixing manually going through list of fields entering , found 1 gave error though field same other fields. if purposefully spell field wrong error. code looks this:

with dminfo begin   qryinfo.sql.clear;   qryinfo.sql.add('insert tblgymnast');   qryinfo.sql.add('(gymnastid, surname, name, nickname, familyid, poscode, cellno, sagfid, photo, startdate, birthdate, gender, race, category, idnum, upgrdto, schoolid, levelid, transid, dokterid, mednum, medid, language)');    qryinfo.sql.add(' values(:gymnastid, :surname, :name, :nickname, :familyid, :poscode, :cellno, :sagfid, :photo, :startdate, :birthdate, :gender, :race, :category, :idnum, :upgrdto, :schoolid, :levelid, :transid, :dokterid, :mednum, :medid, :language)');        qryinfo.parameters.parambyname('gymnastid').value:= 'a';       qryinfo.parameters.parambyname('surname').value:= 'a';       qryinfo.parameters.parambyname('name').value:= 'a';       qryinfo.parameters.parambyname('nickname').value:= 'a';       qryinfo.parameters.parambyname('familyid').value:= 'a';       qryinfo.parameters.parambyname('poscode').value:= 'a';       qryinfo.parameters.parambyname('cellno').value:= 'a';       qryinfo.parameters.parambyname('sagfid').value:= 'a';       qryinfo.parameters.parambyname('photo').value:= 'a';       qryinfo.parameters.parambyname('startdate').value:= 'a';       qryinfo.parameters.parambyname('birthdate').value:= 'a';       qryinfo.parameters.parambyname('gender').value:= 'a';       qryinfo.parameters.parambyname('language').value:= 'a'; //this gives error       qryinfo.parameters.parambyname('race').value:= 'a';       qryinfo.parameters.parambyname('category').value:= 'a';       qryinfo.parameters.parambyname('idnum').value:= 'a';       qryinfo.parameters.parambyname('upgrdto').value:= 'a';       qryinfo.parameters.parambyname('schoolid').value:= 'a';       qryinfo.parameters.parambyname('levelid').value:= 'a';       qryinfo.parameters.parambyname('transid').value:= 'a';       qryinfo.parameters.parambyname('dokterid').value:= 'a';       qryinfo.parameters.parambyname('mednum').value:= 'a';       qryinfo.parameters.parambyname('medid').value:= 'a';    qryinfo.execsql; end; 

please have been struggling whole day , haven't gotten anywhere.

regards

[] or "" signifys rdbms word column name not reserved keyword. language reserved keyword in sql.

for measure changed parameter name lang because identified parameter assignment teh issue location.

with dminfo begin   qryinfo.sql.clear;   qryinfo.sql.add('insert tblgymnast');   qryinfo.sql.add('(gymnastid, surname, name, nickname, familyid, poscode, cellno, sagfid, photo, startdate, birthdate, gender, race, category, idnum, upgrdto, schoolid, levelid, transid, dokterid, mednum, medid, [language])');    qryinfo.sql.add(' values(:gymnastid, :surname, :name, :nickname, :familyid, :poscode, :cellno, :sagfid, :photo, :startdate, :birthdate, :gender, :race, :category, :idnum, :upgrdto, :schoolid, :levelid, :transid, :dokterid, :mednum, :medid, :lang)');        qryinfo.parameters.parambyname('gymnastid').value:= 'a';       qryinfo.parameters.parambyname('surname').value:= 'a';       qryinfo.parameters.parambyname('name').value:= 'a';       qryinfo.parameters.parambyname('nickname').value:= 'a';       qryinfo.parameters.parambyname('familyid').value:= 'a';       qryinfo.parameters.parambyname('poscode').value:= 'a';       qryinfo.parameters.parambyname('cellno').value:= 'a';       qryinfo.parameters.parambyname('sagfid').value:= 'a';       qryinfo.parameters.parambyname('photo').value:= 'a';       qryinfo.parameters.parambyname('startdate').value:= 'a';       qryinfo.parameters.parambyname('birthdate').value:= 'a';       qryinfo.parameters.parambyname('gender').value:= 'a';       qryinfo.parameters.parambyname('lang').value:= 'a'; //this gives error       qryinfo.parameters.parambyname('race').value:= 'a';       qryinfo.parameters.parambyname('category').value:= 'a';       qryinfo.parameters.parambyname('idnum').value:= 'a';       qryinfo.parameters.parambyname('upgrdto').value:= 'a';       qryinfo.parameters.parambyname('schoolid').value:= 'a';       qryinfo.parameters.parambyname('levelid').value:= 'a';       qryinfo.parameters.parambyname('transid').value:= 'a';       qryinfo.parameters.parambyname('dokterid').value:= 'a';       qryinfo.parameters.parambyname('mednum').value:= 'a';       qryinfo.parameters.parambyname('medid').value:= 'a';    qryinfo.execsql; end; 

Comments