2,727
社区成员
发帖
与我相关
我的任务
分享
Select Max(dah) From zmd Where Alltrim(mc)==Alltrim(Thisform.txtmc.Value) Into Array aMaxdah
If _Tally>0
lcLeft=Substr(aMaxdah,1,Rat('-',aMaxdah))
lnMax=Val(Substr(aMaxdah,Rat('-',aMaxdah)+1))
Create Cursor t1 (mydah c(20))
For lnI=1 To lnMax
Insert Into t1 (lcLeft+Transform(lnI))
Endfor
Select mydah From t1 Where mydah Not In (Select Distinct dah From zmd) Order By mydah Into Cursor t2
If _Tally>0
Thisform.txtdah.Value=t2.mydah
Else
Thisform.txtdah.Value=lcLeft+Transform(lnMax+1)
Endif
Else
Thisform.txtdah.Value=Alltrim(Thisform.txtmc.Value)+"-1"
Endif