图的蓝色标题,拖拽到表单中,保存,完成。
答案:2.select 客户名,图书名,数量,单价,(单价*数量) 金额 from goods a,orderitem b,order c where a.图书号 =b.图书号 and b.订单号=c.订单号 and month(签订日期)>=7 order by 客户名,图书名 into table
mysqltable 3.菜单项: 运行表单 do form myform 执行程序 do
sql 退出 set sysmenu to default clear events 4.main
程序: do mymenu.mpr Read events 5.在项目管理器中右下角 单击 “连编” ,选择第二个选项“连编应用程序” ,写上程序名:myproject.app 6.选择 VF 菜单中的“程序” ,运行刚生成的应用程序文件:myproject.app
第9套
答案:一.4. 文件-新建-程序,命令:alter table employee alter 性别 set check 性别$”男女”,保存为 sone,并运行.
答案:二. 1 程序修改为: SELECT Department.部门名, count(*) as 总人数; FROM employee_m!department INNER JOIN employee_m!employee ;
ON Department.部门号 = Employee.部门; group by Employee.部门; INTO TABLE tone.dbf SELECT Department.部门名, count(*) as 人数_男; FROM employee_m!department INNER JOIN employee_m!emplo
yee ; ON Department.部门号 = Employee.部门; where 性别="男" ; group by Employee.部门; INTO TABLE ttwo.dbf SELECT tone.部门名, ttwo.人数_男, tone.总人数-ttwo.人数_男 as 人数_女, tone.总人数; FROM tone INNER JOIN ttwo ; on tone.部门名=ttwo.部门名 ; order by tone.部门名 desc ; INTO TABLE tableone 保存并运行。
答案: 文件-新建-表单, 保存为 formone,文本框的 value 属性改为 =date() , 查询的 click 事件中: SELECT 职员号, , 性别, 出生日期,部门名 FROM department ,employee ; WHERE Department.部门号= Employee.部门 AND 出生日期>=ctod(thisform.text1.value); ORDER BY 部门名 DESC, Employee.职员号 INTO TABLE tablethree