adoquery 的sql问题－－－－－在线等待，急啊(30分)

adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add(' insert into client ');
adoquery1.SQL.Add(' values('+label9.caption+''''+trim(flatedit1.Text)+''''+trim(flatedit2.Text)+''''
+''''+trim(flatedit3.Text)+''''+trim(flatedit4.Text)+''''+trim(flatedit5.Text)
+''''+trim(flatmemo1.Text)+' ) ');
adoquery1.ExecSQL;
d6编译通过，可是一执行，就出错，谁能帮我看看怎么回事？

用
showmessage(adoquery1.SQL.Text);显示一下你的SQL语句就明白了。

insert into 表 values('字符串A','字符串B',.....)

adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add(' insert into client valuespara1,ara2)');
adoquery1.Parameters.ParamByName('para1').Value:=label9.caption;
adoquery1.Parameters.ParamByName('para2').Value:=trim(flatedit1.Text);
adoquery1.ExecSQL;

用参数比较好

语句还没写全当然出错了

sql语句错
adoquery1.SQL.Add(' values('''+label9.caption+''','''+trim(flatedit1.Text)+''','''+trim(flatedit2.Text)+''','''
+trim(flatedit3.Text)+''','''+trim(flatedit4.Text)+''','''+trim(flatedit5.Text)
+''','''+trim(flatmemo1.Text)+''' ) ');

3ks~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~