4GL 单身输入,项次自动加1

xxy02是项次

BEFORE INSERT
     LET l_n = ARR_COUNT()
     LET p_cmd='a'
     INITIALIZE g_tc_xxy[l_ac].* TO NULL       #900423
     LET g_tc_xxy_t.* = g_tc_xxy[l_ac].*          #新輸入資料
#180731-A-项次加1
     SELECT MAX(xxy02)+1 INTO g_tc_xxy[l_ac].xxy02 FROM xxy_file
     WHERE xxy01 = g_tc_xxy01
     IF g_tc_xxy[l_ac].xxy02 IS NULL THEN
       LET g_tc_xxy[l_ac].xxy02 = g_tc_xxy[l_ac-1].xxy02+1
     END IF
#180731-A-项次加1
     CALL cl_show_fld_cont()     #FUN-550037(smin)
     NEXT FIELD xxy02

  #180731-A-项次加1   
  BEFORE FIELD xxy02                        #default 序號
         IF g_tc_xxy[l_ac].xxy02 IS NULL OR g_tc_xxy[l_ac].xxy02 = 0 THEN
            SELECT MAX(xxy02)+1 INTO g_tc_xxy[l_ac].xxy02 FROM xxy_file
             WHERE xxy01 = g_tc_xxy01
             IF g_tc_xxy[l_ac].xxy02 IS NULL THEN
               LET g_tc_xxy[l_ac].xxy02 = 1
             END IF
         END IF
  #180731-A-项次加1 
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值