使用UniDAC操作Mysql报错，那位大大帮忙看看(100)

sql := 'insert into ysscrkb(rq,czaqts,zhiban_ld) '; sql := sql + 'values('''; sql := sql + t + ''','; sql := sql + ''''+czaqts.Text + ''','; sql := sql + ''''+zhiban_ld.text + ''')'; shuju.baocun.SQL.Add(sql); shuju.baocun.Execute;直接打命令没有问题成功写入，程序运行出‘#42000You have an error in your SQLsyntax:check the manual that correponds to your MySQL server version for the right syntax to use near'insert into ysscrkb(rq,czaqts,zhiban_ld) values('20100824','1850','王荣') at line 2.

'20100824' 改为 '2010-08-24' 试试

不关20100824的问题，我定义的是varchar(8)

接受答案了.