with DataModule1 do begin CDS_Public.Close; CDS_Public.CommandText:='insert into Position'+ '(PositionLocation) values (:PositionLocation )'; CDS_Public.Params.ParamByName('PositionLocation').AsString:=trim(Edt_PositionLocation.Text); try CDS_Public.Execute; except ... end; end; 最最简单的插入语句
server用的是:DataSetProvider、ado
client用的是:SocketConnection、ClientDataSet、
begin
CDS_Public.Close;
CDS_Public.CommandText:='insert into Position'+
'(PositionLocation) values (:PositionLocation )';
CDS_Public.Params.ParamByName('PositionLocation').AsString:=trim(Edt_PositionLocation.Text);
try
CDS_Public.Execute;
except
...
end;
end;
最最简单的插入语句
这样试试看
还有你要看一下你字段的大小
中文一般占四个字节的 是一个字符的两倍