Query1.close; Queyr1.sql.clear; Query1.sql.add( SELECT a.*, b.employee_name AS 员工姓名, c.depart_name AS 部门名 FROM Consume_Tbl_addmoney a INNER JOIN employee b ON a.Employee_no = b.employee_no INNER JOIN depart c ON b.depart_no = c.depart_no where Employee_no='''+edit1.text+''' and Account_date>='''+datetostr(datetimepicker1.date)+'''and Account_date<='''+datetostr(datetimepicker2.date)+''') query1.open;
你先这样测试一下呢? : Query1.close; Queyr1.sql.clear; Query1.sql.add( SELECT b.employee_name AS 员工姓名, c.depart_name AS 部门名 FROM Consume_Tbl_addmoney a INNER JOIN employee b ON a.Employee_no = b.employee_no INNER JOIN depart c ON b.depart_no = c.depart_no where Employee_no='''+edit1.text+''' and Account_date>='''+datetostr(datetimepicker1.date)+'''and Account_date<='''+datetostr(datetimepicker2.date)+''') query1.open;
----------------------------------------------
中流一壶,千金争挈。宁为铅刀,毋为楮叶。错节盘根,利器斯别。识时务者,呼为俊杰!