文档介绍：第1题
a=allt()
n=
do case
case n=1
select * from sb where 商品名=a
case n=2
update sb set 单价=出厂单价* where left(商品号,2)="10"
browse
case n=3
copy to
case n=4
endcase
关注第二题
a=alltrim()
b=left(a,2)
i=2
do while len(b)<len(a)
b=alltrim(left(a,i))
c=allt(right(a,len(a)-i))
a=b+c
i=i+1
enddo
messagebox(a)
a=""
i=1
s=
do while i<=len()
t=allt(substr(s,i,1))
a=a+t
i=i+1
enddo
messagebox(a)
第4题
update 成绩 set 总成绩=计算机+英语+数学
sele avg(计算机) from 成绩 into array q
=q
第5题
上一条click事件代码
skip-1
ifbof()
=.f.
=.t.
endif
下一条click事件代码
skip+1
ifeof()
=.f.
=.t.
endif
第6题
a=val()
b=val()
cx="select * from student where val(学号) between a and b into cursor cx1"
=cx
第7题
n=
do case
case n=1
creat table XLDA;
(学号 c(6),姓名 c(10),成绩 n(5,1))
insert into XLDA;
values ("100101","德华",89)
insert into XLDA;
values ("100202","曼玉",90)
insert into XLDA;
values ("100103","学友",88)
case n=2
sele * from XLDA order by 成绩desc
case n=3
sele left(学号,4)as 班级,sum(成绩) as 班级总成绩 from XLDA