Query1.SQL.Text:=('insert student(student_name,student_number,student_sex,department,majoring,experiment_year,experiment_semester,note) values '+ format('(''%s'',''%s'',''%s'',''%s'',''%s'',''%s'',''%s'',''%s'')',[str[0],str[1],str[2],str[3],str[4],str[5],str[6],str[7]]));
query1.exesql 时候,程序错误:raised execption class edbengineError with message 'Invalid use of keyword请高手指教!
query1.exesql 时候,程序错误:raised execption class edbengineError with message 'Invalid use of keyword请高手指教!
Query1.Close;
Query1.SQL.Clear;
Query1.SQL.add('insert student (student_name,student_number,student_sex,');
Query1.SQL.add('department,majoring,experiment_year,experiment_semester,note)');
Query1.SQL.add(' values (:@student_name,:@student_number,:@student_sex,');
Query1.SQL.add(':@department,:@majoring,:@experiment_year,:@experiment_semester,:@note)');
Query1.Parameters.ParamByName('@student_name').Value := edt_studentname.text;
...
Query1.Execsql;