DOC

VF

By Annie Patterson,2014-04-14 19:39
20 views 0
VF

select *from share into table share_bk copy strcuture to ……?

    insert into share_bk values ("600028",4.36,4.60,5500) update share_bk set 现价=8.88 where 股票代码="600007"

    delete from share_bk where 股票代码="600000"

    select stock_name.股票简称,stock_sl.现价,stock_sl.买入价,stock_sl.持有数量 from stock_name inner join stock_sl on stock_name.股票代码=stock_sl.股票代码 where stock_sl.现价>stock_sl.买入价=.t. order by stock_sl. 持有数量 desc into table temp

set talk off

    open DATABASE WAGE3.DBC

    SELECT 仓库号,AVG(工资) AS AvgGZ FROM ZG GROUP BY 仓库号 INTO CURSOR CurTable SELECT ZG.* FROM ZG,CurTable WHERE ZG.仓库号=CurTable.仓库号 AND ZG.工资<CurTable.AvgGZ ORDER BY zg.仓库号,zg.职工号 INTO TABLE lever

    set talk on

open database salarydb SELECT DEPT.部门号,dept.部门名,;

    DO CASE SUM(工资) AS 工资,SUM(补贴) AS 补贴,SUM(奖励) AS 奖励 ,;

     CASE THISFORM.OPTIONGROUP1.VALUE=1 SUM(失业保险) AS 失业保险,SUM(医疗统筹) AS 医疗统筹;

     use SVIEW FROM DEPT,SALARYS;

     brow WHERE DEPT.部门号=SALARYS.部门号;

     SELECT * FROM SVIEW INTO TABLE GZ1.DBF GROUP BY DEPT.部门号;

     CASE THISFORM.OPTIONGROUP1.VALUE=2 ORDER BY DEPT.部门号;

     use dept CASE THISFORM.OPTIONGROUP1.VALUE=3

     brow INTO TABLE HZ1.DBF

     SELECT * FROM DEPT INTO TABLE BM1.DBF ENDCASE

Report this document

For any questions or suggestions please email
cust-service@docsford.com