涓�銆?/p>
1
濂楋細
锛堣緭鍑哄瓧娈垫病鏈夎绠楀瓧娈碉級
鏌ヨ缁撴灉鐨勫幓鍚戯細
1.
select
鑷韩鐨勫幓鍚戯紝鑳藉鐢?/p>
select
鍛戒护涓殑鍘诲悜瀛楀彞鏉ュ畬鎴?/p>
2.
鍘诲悜涓?/p>
select
鑷韩鍘诲悜浠ュ鐨勫叾浠栧湴鏂癸細
锛堣涓浆锛?/p>
鐢?/p>
select
鑷韩鐨勬煇绉嶅幓鍚戜綔涓轰腑杞珯
,
鐒跺悗鐢ㄥ叾浠栫殑鍛戒护杩涜鏁版嵁涓浆锛?/p>
飦?/p>
鏂囨湰妗嗭細
锛堢敤鏁扮粍鍋氫腑杞級
飦?/p>
琛ㄦ牸鎺т欢锛?/p>
锛堢敤琛ㄥ仛涓浆
,
姘镐箙琛ㄦ垨鑰呬复鏃惰〃锛岃鎯呭喌鏉ュ畾锛?/p>
select
闆朵欢鍚?/p>
,
棰滆壊
,
閲嶉噺
from
闆朵欢
,
渚涘簲
where
闆朵欢
.
闆朵欢鍙?/p>
=
渚涘簲
.
闆朵欢鍙?/p>
and
宸ョ▼
鍙?/p>
=thisform.text1.value order by
闆朵欢鍚?/p>
into table pp
thisform.grid1.recordsoucetype=1
thisform.grid1.
recordsouce=
鈥?/p>
pp
鈥?/p>
(
鐩存帴鎶?/p>
select
鍛戒护涓?/p>
recordsouce
缁戝畾锛岃繖鏃?/p>
select
璇彞涓嚜韬殑鍘诲悜瑕佽缃垚
into
cursor/into table
姘镐箙琛ㄦ垨鑰呬复鏃惰〃锛岃鎯呭喌鏉ュ畾
)
thisform.grid1.recordsoucetype=4
thisform.grid1.recordsouce=
鈥?/p>
select
闆朵欢鍚?/p>
,
棰滆壊
,
閲嶉噺
from
闆朵欢
,
渚涘簲
where
闆朵欢
.
闆朵欢
鍙?/p>
=
渚涘簲
.
闆朵欢鍙?/p>
and
宸ョ▼鍙?/p>
=thisform.text1.value order by
闆朵欢鍚?/p>
into cursor temp
鈥?/p>
飦?/p>
宸茬粡瀛樺湪鐨勮〃锛堢洰鏍囪〃鍙互鏄┖琛ㄦ垨闈炵┖琛紝琚腑杞殑鏁版嵁鍙互鏄竴鏉℃垨澶氭潯锛屼絾
瀹冧滑绗﹀悎鐨勬潯浠舵槸鏁版嵁涓浆鏀惧埌鐩爣琛ㄧ殑
灏鹃儴
锛?/p>
骞朵笖琚腑杞殑鏁版嵁
涓�鏉?/p>
姝ｅソ
涓�涓�瀵?/p>
搴?/p>
鐩爣琛ㄧ殑
涓�鏁磋
銆?/p>
Select
鍛戒护涓敤
鏁扮粍
鍋氫腑杞珯锛?/p>
Select
瀛楁
1
锛屽瓧娈?/p>
2
鈥︹�?/p>
from
鈥︹�?/p>
where
鈥︹�?/p>
order by
鈥︹�?/p>
group by
鈥︹�?/p>
into
array
a
Insert
into
鐩爣琛ㄥ悕
from
array
a
飦?/p>
宸茬粡瀛樺湪鐨勮〃
鐩爣琛ㄤ笉涓虹┖琛紝
浣嗘湁鑻ュ共鍒椾负绌猴紝
闇�瑕佺敤
select
鏌ヨ缁撴灉鏉ュ～鍐欙紝
select
鍛戒护涓敤琛ㄥ仛
涓浆绔欙紝鐢ㄦ案涔呰〃鎴栬�呬复鏃惰〃锛岃鎯呭喌鏉ュ畾銆?/p>
Select
瀛楁
1(
鍏卞悓瀛楁
)
锛屽瓧娈?/p>
2
鈥?/p>
(
鎵�闇�杈撳嚭瀛楁
)
from
鈥?/p>
where
鈥︹�?/p>
order
by
鈥︹�?/p>
group
by
鈥︹�?/p>
into
dbf
b