tchild_qu.Close;
tchild_qu.SQL.Clear;tchild_qu.SQL.Add('insert into house_check (years,months,weeks,check_date,build_no,house_no) select '
+FloatToStr(edt_year.value)+','+FloatToStr(edt_month.value)+','+FloatToStr(edt_week.value)+','+'2005/1/8'+',build_no,house_no from house_manage');tchild_qu.Prepared:=true;
tchild_qu.ExecSQL;小弟 check_date 字段 插入'2005/1/8',但數據庫中顯示:‘1905/06/20’;數據庫為:ms-sql
tchild_qu.SQL.Clear;tchild_qu.SQL.Add('insert into house_check (years,months,weeks,check_date,build_no,house_no) select '
+FloatToStr(edt_year.value)+','+FloatToStr(edt_month.value)+','+FloatToStr(edt_week.value)+','+'2005/1/8'+',build_no,house_no from house_manage');tchild_qu.Prepared:=true;
tchild_qu.ExecSQL;小弟 check_date 字段 插入'2005/1/8',但數據庫中顯示:‘1905/06/20’;數據庫為:ms-sql
insert into house_check(check_date)
select '2005/1/8' from house_manage这样???语句队吗?
tchild_qu.Close;
tchild_qu.SQL.Clear;tchild_qu.SQL.Add('insert into house_check (years,months,weeks,check_date,build_no,house_no) select '
+FloatToStr(edt_year.value)+','+FloatToStr(edt_month.value)+','+FloatToStr(edt_week.value)+','+'''2005/1/8'''+',build_no,house_no from house_manage');tchild_qu.Prepared:=true;
tchild_qu.ExecSQL;sql的日期要用单引号引用
select '2005/1/8' from house_manage
======================================
当然不对了
应该是:
insert into house_check(check_date)
select * from house_manage where 字段名='2005/1/8'