Delete, insert(select...),Select ????
Please explain these codes:
delete from report_summary;
commit;
ls_currentSQL=dw_1.GetSQLSelect() // get current SQL select from datawindow.
ls_date_t="(From "+em_1.text+" To "+em_2.text+")"
ldt_retrieve_datetime1=date(em_1.text)
ldt_retrieve_datetime2=date(em_2.text)
ls_newSQL = ls_currentSQL
insert into report_summary("badge_id","join_date","emp_name","pay_rule_id","department","division","actual_work_hours",
"lateness","undertime","ot_1","ot_2","ot_3","ot_4","allow_1","allow_2","allow_3","allow_4")
(SELECT "reports"."badge_id",
"employee"."join_date",
"employee"."emp_name",
"employee"."pay_rule_id",
"reports"."department",
"reports"."division",
sum("reports"."actual_work_hours"),
sum("reports"."lateness"),
sum("reports"."undertime"),
sum("reports"."ot_1"),
sum("reports"."ot_2"),
sum("reports"."ot_3"),
sum("reports"."ot_4"),
sum("reports"."allow_1"),
sum("reports"."allow_2"),
sum("reports"."allow_3"),
sum("reports"."allow_4")
FROM "reports",
"employee"
WHERE ( "reports"."badge_id" = "employee"."badge_id" )
and (reports.record_date >= date(:ldt_retrieve_datetime1))
and (reports.record_date <= date(:ldt_retrieve_datetime2))
group by "reports"."badge_id",
"employee"."join_date",
"employee"."emp_name",
"reports"."department",
"reports"."division",
"employee"."pay_rule_id");
commit using SQLCA;
select count (*) into :li_check from report_summary;
问题点数：40、回复次数：5Top
1 楼killerdanny（堕落的瓦拉斯塔兹）回复于 2001-11-05 14:42:45 得分 0
你什么地方不明白？？？Top
2 楼laotong（老童）回复于 2001-11-05 15:08:44 得分 0
1. Insert into...(select...) ??
2. select count (*) into... ??
Top
3 楼laotong（老童）回复于 2001-11-05 16:05:07 得分 0
HELP!Top
4 楼killerdanny（堕落的瓦拉斯塔兹）回复于 2001-11-05 16:21:03 得分 0
语句没有错误呀！你最好用ISQL试试！！！Top
5 楼Alps_lou（云飞扬）回复于 2001-11-05 16:26:34 得分 40
1.将SELECT出来的插入到report_summary中
2。将记录数目插入到:li_check变量代表的表中Top
相关问题
- [insert into...select and insert into ... valuse]
- update,delete,insert into 出错!!!
- 嵌入式SQL中的select、insert、update、delete语句要检查sqlcode吗？
- 有关Tquery ---- insert update delete
- Insert Into Table Select 问题
- 紧急求救:在VC++里如何通过ADO访问(INSERT\UPDATE\DELETE\SELECT)ORACLE里的BLOB字段内容?
- 为什么我用ASP访问Access数据库，select正常，但insert和delete都会报错？
- LS ODBC 为什么使用UPDATE 语句报错！而 insert delete select 都是正确的！
- INSERT...SELECT 出问题了
- 我在PB中用insert...select
