关于如何添加文本的问题(100分)

我想用ClientDataset执行以下命令不知道如何添加到COMmandtext中请指教:
Update backup set card=left(log,10),cardtime=substring(log,11,2)+'-'+
substring(log,13,2)+'-'+substring(log,15,2)+' '+
substring(log,17,2)+':'+substring(log,19,2)+':00',
cardtime1=substring(log,11,2)+'-'+
substring(log,13,2)+'-'+substring(log,15,2)+' '+
substring(log,17,2)+':'+substring(log,19,2)+':'+substring(log,21,2)
我直接这样分解它提示语法有问题的:
ClientDataset1.close;
Clientdataset1.commandtext:='Update backup set card=left(log,10),cardtime=substring(log,11,2)+'-'+
substring(log,13,2)+'-'+substring(log,15,2)+' '+
substring(log,17,2)+':'+substring(log,19,2)+':00',
cardtime1=substring(log,11,2)+'-'+
substring(log,13,2)+'-'+substring(log,15,2)+' '+
substring(log,17,2)+':'+substring(log,19,2)+':'+substring(log,21,2)';
ClientDataset.Execute;

字符串'-'这样的单引号应该换成两个单引号:''-'',除非是数值型,否则当然会报错

你的单引号不对。你把所有单引号的地方设置正确就好。在字符串里面，''才表示一个单引号。
Clientdataset1.commandtext:='Update backup set card=left(log,10),cardtime=substring(log,11,2)+''-''+
substring(log,13,2)+''-''+substring(log,15,2)+'' ''+
substring(log,17,2)+'':''+substring(log,19,2)+'':00'',
cardtime1=substring(log,11,2)+''-''+
substring(log,13,2)+''-''+substring(log,15,2)+'' ''+
substring(log,17,2)+'':''+substring(log,19,2)+'':''+substring(log,21,2)';
ClientDataset.Execute;

[]不小心就写了单引号。习惯问题

多人接受答案了。