2,722
社区成员
发帖
与我相关
我的任务
分享
select 序号,邮编,地址,单位,收件人,份数 into table 目标表 from 原表 where 份数<=50
select 序号,邮编,地址,单位,收件人,50 as 份数 into cursor t2 from 原表 where 份数>50
select 序号,邮编,地址,单位,收件人,(份数-50) as 份数 into cursor t1 from 原表 where 份数>50
select 目标表
append from dbf("t1")
append from dbf("t2")
*--如果是VFP9.0:
Do While .T.
Select Max(份数) As fs Into Cursor t1 From c:\zmn.Dbf
If t1.fs>50
Insert Into c:\zmn.Dbf (序号,邮编,地址,单位,收件人,份数) Select 序号,邮编,地址,单位,收件人,50 From c:\zmn.Dbf Where 份数>50
Update c:\zmn.Dbf Set 份数=份数-50 Where 份数>50
Else
Return .F.
Endif
Enddo
Select 序号,邮编,地址,单位,收件人,份数 Into Table yzbq.Dbf From c:\zmn.Dbf Where 份数<=50
Select zmn
Set Filter To 份数>50
Scan
For i=1 To Int(zmn.份数/51)
Replace zmn.份数 With zmn.份数-50
Insert Into yzbq (序号,邮编,地址,单位,收件人,份数) Values (zmn.序号,zmn.邮编,zmn.地址,zmn.单位,zmn.收件人,50)
Endfor
Endscan
Select yzbq
Append From Dbf("zmn")
试试这个
Select 序号,邮编,地址,单位,收件人,份数 Into Table yzbq.Dbf From c:\zmn.Dbf Where 份数<=50
Select zmn
Set Filter To 份数>50
Scan
For i=1 To Int(zmn.份数/51)
Replace 份数 With zmn.份数-50
Insert Into yzbq (序号,邮编,地址,单位,收件人,份数) Values (zmn.序号,zmn.邮编,zmn.地址,zmn.单位,zmn.收件人,Iif(zmn.份数-50>50,50,zmn.份数-50))
Endfor
Endscan
Select yzbq
Append From Dbf("zmn")
Select 序号,邮编,地址,单位,收件人,份数 Into Table yzbq.Dbf From c:\zmn.Dbf Where 份数<=50
Select 序号,邮编,地址,单位,收件人,50 As 份数 Into Cursor t2 From c:\zmn.Dbf Where 份数>50
Select 序号,邮编,地址,单位,收件人,(份数-50) As 份数 Into Cursor t1 From c:\zmn.Dbf Where 份数>50
Select yzbq
Append From Dbf("t1")
Append From Dbf("t2")
--试试,再不行帖全你的代码,并指出报错行和错误信息