这段代码怎么还是不对啊?
xlwz 2003-12-12 09:44:14 string ls_bh, ls_seq,ls_date
datetime ldt_date
int rowno,rowno0=0
select isnull( max(gzsqdbh), 'SG' + string(today(),'yyyymm') + '000' )
into :ls_bh
from t_gzsq
where left(gzsqdbh, 8 ) = 'SG' + string(today(),'yyyymm');
//ls_seq = right( ls_bh, 3 )
ls_seq = right('000'+string( long( ls_bh ) + 1 ), 3 )
//ls_bh = left( ls_bh, 8 ) + ls_seq
do
rowno0++
loop while isnull(dw_1.object.gzsqdbh[rowno0])
rowno=rowno0
dw_1.object.gzsqdbh[rowno] = 'SG' + string(today(),'yyyymm')+ls_seq
dw_1.object.sqrq[rowno] = today()
dw_1.object.sqr[rowno] = "zx"
rowno++
运行是没有从表中找出符合条件的值。